THANKS A LOT TOM for your sizable time and explanation - this will help me for other logic creation too... Really appreciate your efforts.... Thanks! ... View more

This is awesome Tom - it worked fine - just few questions if you got some time... Is there any way i can stay with date logic to use below mkdir/copy/zip command? why i am asking is because i will have different dates files and i want to treat specific date files only - so basically this process will run daily - for example - if this sas code (the one you gave me) run today then it supposed to created folder with yesterday's date and copy yesterday's files into yesterday folder and then zip the files - but what if folder has more than one different date files - how this code will treat it? ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------- /*i wanted to stay with this code if i can - but it doesn't seems feasible for me*/ %macro trans; data _null_; set  transfer_yesterday_files;   if file_last_written_date=&date6 then    do;         x "mkdir d:\woo\test\&date6";         x "copy /*i need copy command here which would copy files which are having "file_last_written_date=&date6*/         x "copy "d:\woo\test\*.txt d:\woo\test\&date6";         x "gzip "/*i need gzip command here which will zip all transferred files into newly created folder "&date6" which will be date folder like 2014-07-18*/    end; run; %mend; %trans; ... View more

No Tom - you are right - i am not going to copy all text files - just specific text file filename all_txt pipe 'dir "d:\woo\test\*.txt" /tw'; data transfer_yesterday_files;    attrib  buffer format=$2000.               file_last_written_date format=yymmdd10.               file_last_written_time format=time5.               file_name format=$100.;    infile all_txt truncover ;    input buffer $2000.;    /* Remove some extra info */    if substr(buffer,1,5) in ("Volum","Direc") or index(buffer,"<DIR>")>0 or index(buffer,"Dir(s)")>0 or index(buffer,"File(s)")>0 then delete;    file_last_written_date=input(put(scan(compbl(buffer),1,' '),$10.),mmddyy10.);  /* note dependant on system settings */    file_last_written_time=input(put(scan(compbl(buffer),2,' '),$5.),time5.);    file_name=trim(scan(compbl(buffer),5,' ')) ;    if file_name = ' ' then delete ; run; data _null_; tempdate1=intnx('day',today(),0); tempdate2=intnx('day',today(),-1); tempdate3=intnx('day',today(),-2); tempdate4=intnx('day',today(),-3); tempdate5=intnx('day',today(),-4); tempdate6=intnx('day',today(),-5); tempdate7=intnx('day',today(),-6); call symput('date1',put(tempdate1,yymmdd10.)); call symput('date2',put(tempdate2,yymmdd10.)); call symput('date3',put(tempdate3,yymmdd10.)); call symput('date4',put(tempdate4,yymmdd10.)); call symput('date5',put(tempdate5,yymmdd10.)); call symput('date6',put(tempdate6,yymmdd10.)); call symput('date7',put(tempdate7,yymmdd10.)); run; %put _user_; %macro trans; data _null_; set  transfer_yesterday_files;   if file_last_written_date=&date6 then    do;         x "mkdir d:\woo\test\&date6";         x "copy /*i need copy command here which would copy files which are having "file_last_written_date=&date6*/         x "copy "d:\woo\test\*.txt d:\woo\test\&date6";         x "gzip "/*i need gzip command here which will zip all transferred files into newly created folder "&date6" which will be date folder like 2014-07-18*/    end; run; %mend; %trans; ... View more

Thanks Tom...!!! ... View more

Sorry Tom my bed - it ran fine...by mistake i was using my different dataset to create final dataset... Thanks a lot...Tom... But if you can explain below part and why we used "/" for each line...and what is the meaning of /source2 filename +(-1) "'" Appreciate your time... ... View more

Hi Tom - i am running this code but below piece of code giving libname statement error by reading "dsname" as libname so error is coming like; ERROR: Libanme 'sales_abc_20140716_test_file_1' exceed 8 characters. ... View more

actually even all files has different numbers of variables...just for information... ... View more

i don't have it at this moment but can work on it...would this worked? sales_abc_20140716_test_file_1.txt finance_abc_20140716_test_file_2.txt sales_xyz_20140716_test_file_3.txt finance_xyz_20140716_test_file_4.txt ... View more

thanks Reeza for your quick response but i need datasets separately...if we cannot do that then i can minimize the file names somehow, like this; sales_abc_20140716_test_file_1.txt finance_abc_20140716_test_file_2.txt sales_xyz_20140716_test_file_3.txt finance_xyz_20140716_test_file_4.txt ... View more

thanks a lot Reeza for your quick response. I checked and it worked... ... View more