SAS Macro Series Part 5: Creating macro variables with Proc SQL and three ways to use them
Vložit
- čas přidán 22. 08. 2024
- In this video, I will how to create macro variable in Proc SQL and also how to use them. In here I also discuss how to use dictionary.tables and control table to solve them.
Link to understand indirect macro variable references.
• SAS Macro Series Part ... (starts after 23 minutes).
Dictionary.tables ( and other dictionary tables) and some application
• Append all sheets of a...
• Increasing length of a...
• Deleting rows with any...
It is a great lecture, Thanks!
This is very helpful. Thanks for sharing video's. Can you please share How to generate the reports using proc print and proc tabulate.
Thank you. I did not work a lot on generating reports
Hello Sir..Thank you so much for the video😊
Nice video
Hlo sir your videos are really helpful. One question how to import multiple sheets of an excel file using dynamic macro
simply use xlsx engine it is engine.
libname myXL xlsx 'path to xlsx file';
proc copy in=myXL out=work; run;
check the below l
stackoverflow.com/questions/60271504/is-there-a-way-to-import-multiple-excel-sheets-using-code-in-sas-enterprise-when
Hi Sir , Can I pls know how to convert multiple sas files into txt files using the dynamic macro
This is more of operating system work and you do not need a macro for this and please checkout this link communities.sas.com/t5/SAS-Programming/Convert-Program-to-TXT-file/m-p/455155