Excellent work. Why don't you create one video to pull data from multiple excel file and combined as single one. It will be easier for new comer to understand rather than following below suggested url
Hello sir, from the last point you said, truncation of data with different lengths while combining datasets, what's the solution for that ? Please reply
Nice
Great video, what about appending several excel files in a sas dataset
Please checkout some common answers on thid topic here. stackoverflow.com/questions/53836924/how-do-i-read-multiple-excel-files-in-sas-using-a-macro
@@kiranvenna wow, great link and great response. I guess I just needed to phrase it correctly to find the answer. Thanks
Hello sir, very nice video. I just have one question. Can you please tell me how can we read multiple sheets in SAS 9.4. Thank you.
you mean without libname
Excellent work. Why don't you create one video to pull data from multiple excel file and combined as single one. It will be easier for new comer to understand rather than following below suggested url
Hi Sir
If I have 30 external text file , how I combine all these file in one Dataset by macro. Or if any other method .
Please guide me?
check this blog out. blogs.sas.com/content/sasdummy/2018/10/09/read-multiple-text-files/
Hello sir, from the last point you said, truncation of data with different lengths while combining datasets, what's the solution for that ? Please reply
in set statement always give dataset with greater length variables first to avoid truncation