Hi here is how my input file ( it can have thousands records) looks like   input file: name  /home/tej/a.sas7bdat /home/bn/b.sas7bdat /hom/df.sas7bdat   Outputfile:  name                                  user            date /home/tej/a.sas7bdat          x                   ...  /home/bn/b.sas7bdat         y                  .... /hom/df.sas7bdat               z                     ....     In a nutshell i should run 'ls -ul ' command on each record of the input file and append its output to the record.  My way or most obvious way of doing this create intermediate data for each record and finally append everything.  Is there any other smart way of doing where we can avoid creating intermediate data set for each record.    Thanks   ... View more

I created a file (metadata.sas7bdat) which has 100 entries with two columns directory and sasdatasets.   Directory                filename /home                    abc.sas7bdat /home                    def.sas7bdat /home/sub_dir       ghj.sas7bdat   Assume I have sample.sas which just gets the means of each dataset.   Proc means data=abc.sas out=x; Run;   The above sample.sas should run on each dataset present in metadata file. Right now I have written it in very traditional way of it loops through all the files in metadata and runs proc means on each file and appends all the data. The final dataset has the means of all the files present in metadata.   I believe if I can split the metadata file into 4 parts each having (100/4=25 entries) and submit it as 4 programs and finally merge the output from all the 4 programs It would reduce the processing time by large amount. ( think of 10,000 entries and also assume there is more processing than proc means). Its just I am not well versed with what kind of options to use to submit it as 4 programs and how to sync the output from 4 different processes.   Can you provide me the skeleton of how I should construct this program , I have my vague thoughts but I am sure I can take away   some elegant answers . ... View more