Hello All,
After I run a SAS program in UNIX the program can create a folder " /home/A123456ABC/XYZ/ABC" for me. how to write the SAS code?
Thanks!
x123456789-aaa-15$ pwd
/home/A123456ABC/My_report
x123456789-aaa-16$ sas the_code_needed.sas
SAS doesn't have any special code to create a directory. Instead, it lets you issue a Unix command. For example, within a SAS program you could code:
%sysexec cd /home/A123456ABC;
%sysexec mkdir My_Reports_test1;
I can't test it right now, but you should test it when the program you submit is in your home folder, as well as when the program is in some other folder.
SAS doesn't have any special code to create a directory. Instead, it lets you issue a Unix command. For example, within a SAS program you could code:
%sysexec cd /home/A123456ABC;
%sysexec mkdir My_Reports_test1;
I can't test it right now, but you should test it when the program you submit is in your home folder, as well as when the program is in some other folder.
How to embed the unix command into SAS code? I want the SAS code be executed automation include creating new folder step.
%sysexec is the SAS code. It doesn't need to be embedded. Just save it as a .sas file and run it.
Not strictly true. This can also be useful if you don't have xcmd permissions:
http://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a002986745.htm
Check function DCREATE() .
It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.