Thanks a lot SASKiwi and stat@sas... ... View more

Thanks a lot Peter - it worked fine... ... View more

how can we perform it from code perspective - because this piece of code should goes with automation... Thank you... ... View more

No Scott, i didn't run it   ...may be that's why...- Thanks Thanks all for your detail...many ways to do it... 🙂 I am using RW9 solution... ... View more

YMDDT. is giving error...format cannot ound and could not be loaded... i am trying create macro for only datetime function not with filename, so i can write down like this.... filename xyz_abc_&fname.txt ... View more

Okay Reeza, i got ONLY those files which are needs to transfer in "want" dataset and then i used below macro code and it worked fine... /*get some macro variables*/ data _null_; set want end=eof; call symput ('file'||trim(left(_n_)), trim(file_name)); call symput ('crdate'||trim(left(_n_)), put (file_last_written_date_new, date9.)); if eof then call symput ('filecount', _n_); %macro transfer;         %if &filecount>0 %then                 %do;                     data _null_;                     set want;                     infile cmd pipe filevar=copycmd;                     input @;                     run;                  %end;                   %else                            %do;                                  data _null_;                                  put "no files to transfer";                                  run;                            %end; %mend; %transfer; Thanks a lot Reeza.... BUT just to know, why above macro transfer all files every time it check condition for any individual file...? IF YOU CAN TELL ME PLEASE...what went wrong...? do you see any solution in above code if we want to do more macronize work.... Thanks again... Thanks! ... View more

I think i am not clear yet, my main problem is how copycmd would look like...let't say if i got this using you above steps from 1 to 3...        file_last_written_date_new       file_name                                   targetdir                    file_last_written_date_old                1     05may2014                                 username1_finance.mdb                j:\shares\USA             .                                                                                                                                              30APR2014 2     05may2014                                 username2_finance.mdb                j:\shares\USA             .                                                                                                                                              30APR2014 . . . 10   05may2014                                  username10_finance.mdb               j:\shares\USA            .                                                                                                                                               30APR2014 how my copycmd wold look like then?   i am still there ... ... View more

let me show transfer dataset, its looks like this,        file_last_written_date       file_name                                   targetdir                      copycmd                      1     05may2014                        username1_finance.mdb                j:\shares\USA               copy "j:\jim\db\username1_finance.mdb                                                                                                                                                j:\shares\USA\username1_finance.mdb" 2     05may2014                        username2_finance.mdb                j:\shares\USA               copy "j:\jim\db\username2_finance.mdb                                                                                                                                                j:\shares\USA\username2_finance.mdb" . . . 10   05may2014                       username10_finance.mdb               j:\shares\USA                copy "j:\jim\db\username10_finance.mdb                                                                                                                                                 j:\shares\USA\username1_finance.mdb" /*so basically transfer all files which are under "file_name" variable (in "transfer" dataset) after checking date stamp at "j:\shares\USA" one by one...becasue same files would be there with today's date, if file is there with today's date, i am not transferring it */ ... View more

so i think i need to modified below command (because filevar=copycmd has all the files which needs to be transfer to target folder...) to only one individual file at the same time, not all files like below... data _null_;                  set transfer; where date ne today();                  infile cmd pipe filevar=copycmd;                  input @;              run; ... View more

no then "transfer" dataset is not giving any file to the cmd command to transfer and it will return 0 observation.... data _null_;                  set transfer; where date ne today();                  infile cmd pipe filevar=copycmd;                  input @;              run; NOTE: There were 0 observations read from the data set WORK.TRANSFER. ... View more