data a; input y $26.; datalines; 2017-04-19-11.06.29.370264 2017-03-13-14.57.30.837560 2017-03-13-14.57.43.389704 2017-03-13-14.57.56.050378 2017-04-19-11.06.43.894610 2017-03-23-15.02.05.599148 ; run;      I want variable y to be converted to datetime22.3;   2017-04-19-11.06.29.370 2017-03-13-14.57.30.838 2017-03-13-14.57.43.389   how can i do that    ... View more

%let source=c:\New folder; %let target=c:\shubham; data source ;   infile "dir /b ""&source\"" " pipe truncover;   input fname $256. ; run; data target ;   infile "dir /b ""&target\"" " pipe truncover;   input fname $256. ; run;   data new;    set source ;    length cmd1 $100.;   cmd1 = catx(' ','xcopy',quote(catx('\',"&source",fname)),quote("&target"));   cmd= cat('X ',cmd1);      infile cmd  filevar=cmd end=eof ;    do while (not eof);      input;      put _infile_;    end; run;   Below is the error that comes up    ERROR: Invalid physical name. fname=file1.txt cmd1=xcopy "c:\New folder\file1.txt" "c:\shubham" cmd=X xcopy "c:\New folder\file1.txt" "c:\shubham" eof=0 _ERROR_=1 _INFILE_=  _N_=1 NOTE: The SAS System stopped processing this step because of errors. NOTE: There were 1 observations read from the data set WORK.SOURCE. WARNING: The data set WORK.NEW may be incomplete.  When this step was stopped there were 0          observations and 2 variables. WARNING: Data set WORK.NEW was not replaced because this step was stopped. NOTE: DATA statement used (Total process time):       real time           0.01 seconds       cpu time            0.01 seconds     My goal is to copy all directories and subdirectories dynamically    how can I do that  ... View more

  Hello    I want to copy all the files from one folder to another folder  for ex-C:\old folder   I want all the the  folder and file to be copied from old folder to new folder in the C drive   I am using below code    let source=c:\old folder ; %let target=c:\new folder ;   data source ;   infile "dir /b ""&source\"" " pipe truncover;   input fname $256. ; run;   data target ;   infile "dir /b ""&target\"" " pipe truncover;   input fname $256. ; run;   proc sql noprint ;   create table newfiles as     select * from source     where not (upcase(fname) in (select upcase(fname) from target ) )   ; quit;   data _null_;    set newfiles ;   cmd = catx(' ','copy',quote(catx('\',"&source",fname)),quote("&target"));    infile cmd pipe filevar=cmd end=eof ;    do while (not eof);      input;      put _infile_;    end; run;     the problem that I am facing is that    a) if there is folder called  great and inside it has file new.txt  in C;\old folder then it copies in new path as new.txt but it can not creates  new.txt in a folder called great     b) If I run my above program again it does not replace the file with the new one   please let em know how can I acheive ths      ... View more

  ods listing close; Ods pdf file "C:\download\abc.pdf"; Proc print data=sashelp.class; run; ods _all_ close;     my code is running fine but when I am ruuning this code it open the PDF  'abc'  autmatically . I do not want PDF to be open automatically .How can i acheive that      ... View more

I have written a PDF by using below statement    ODS PDF FILE="C:\download\output.pdf'; proc  print data=rCCH; run; ODS _all_ close;   Once I have written the print output to PDF .Now I want to delete the PDF    How Can I delete the PDF from the directory      ... View more