SAS Macro Series Part 5: Creating macro variables with Proc SQL and three ways to use them

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...

[@jinpenggao1943]

It is a great lecture, Thanks!

[@gvsuresh79]

This is very helpful. Thanks for sharing video's. Can you please share How to generate the reports using proc print and proc tabulate.

[@kiranvenna]

Thank you. I did not work a lot on generating reports

[@7979sunny]

Hello Sir..Thank you so much for the video😊

[@adityabatra8894]

Nice video

[@rashamdeepsingh5970]

Hlo sir your videos are really helpful. One question how to import multiple sheets of an excel file using dynamic macro

[@kiranvenna]

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

[@kesanasai4798]

Hi Sir , Can I pls know how to convert multiple sas files into txt files using the dynamic macro

[@kiranvenna]

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