I was able to succesfully count the number of files in the New Folder in unix shell and output it to My SAS files folder
cd H:\My_SAS_Files\New_Folder
count='ls | wc -w'
{ echo -n 'Number of Files is ' & eval "$count"; } >> H:\My_SAS_Files\output
To Check Number of Files:
cd ..
tail output
I need to execute this in SAS to encoperate a loop and some macros, but I'm not sure how to get the X comamnd to work. Any ideas?
X "cd H:\My_SAS_Files\New_Folder";
X "count='ls | wc -w'";
X "{ echo -n 'Number of Files is ' & eval "$count"; } >> H:\My_SAS_Files\output";
Unix is not going to be able to find any files on a directory name that starts with H:.
I find is is easier to code using a DATA _NULL_ and the PIPE engine.
%let path=/mydirectory ;
data file_count;
infile "cd &path ; ls -A | wc -l" pipe;
path="&path";
input files;
run;
Unix is not going to be able to find any files on a directory name that starts with H:.
I find is is easier to code using a DATA _NULL_ and the PIPE engine.
%let path=/mydirectory ;
data file_count;
infile "cd &path ; ls -A | wc -l" pipe;
path="&path";
input files;
run;
Make a Shell file xx.sh and put all the command into it ,execute it at SAS side: X '/home/xx.sh' ;
Another option would be to use SAS external file functions.
May require some more programming lines the the shell counterpart, but you'll keep all logic in SAS.
Yet another option is to first call your shell script, then call SAS with your SAS program, avoiding the OS call from within SAS.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 16. Read more here about why you should contribute and what is in it for you!
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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: