Hi RW9, Thanks for your kind suggestions. Apart all i resolved my issue by storing gzip in location where no space in paths and now no matter if space is in path of raw files, its running fine. ans of ur que one: i didnt find any need for defining output path while i need data on sas plateform[work lib for for other tasks] Que 2: i getting near about 300+ .gz files every month. in this case mannual work would be a additional pain 🙂 Thanks 2 all for great inputs ... View more

Thanks for your input. My concern is raw file can be store anywhere, if i store gzip file one location its ok , but still having error if raw file's path have space in between. is there any solution for it??? ... View more

still not working same error FILENAME in Pipe '"I:\anuj\temp folder\gzip.exe" -dc "I:\Anuj\temp folder\rawdata.txt.gz"'; DATA anuj.test;   INFILE in missover;   INPUT make $ 1-14 mpg 15-18 weight 19-23 price 24-27 ; RUN; Log: 102  FILENAME in Pipe '"I:\anuj\temp folder\gzip.exe" -dc "I:\Anuj\temp folder\rawdata.txt.gz"'; 103  DATA anuj.test; 104    INFILE in missover; 105    INPUT make $ 1-14 mpg 15-18 weight 19-23 price 24-27 ; 106  RUN; NOTE: The infile IN is:       Unnamed Pipe Access Device,       PROCESS="I:\anuj\temp folder\gzip.exe" -dc "I:\Anuj\temp folder\rawdata.txt.gz",       RECFM=V,LRECL=256 Stderr output: 'I:\anuj\temp' is not recognized as an internal or external command, operable program or batch file. NOTE: 0 records were read from the infile IN. NOTE: The data set ANUJ.TEST has 0 observations and 4 variables. NOTE: DATA statement used (Total process time):       real time           0.04 seconds       cpu time            0.00 seconds ... View more

Still getting error: below are code and log for both scenario: code1: FILENAME in Pipe "I:\anuj\gzip -dc I:\Anuj\rawdata.txt.gz" LRECL=80; libname anuj "I:\anuj\"; DATA anuj.test;   INFILE in missover;   INPUT make $ 1-14 mpg 15-18 weight 19-23 price 24-27 ; RUN; LOG1 81   FILENAME in Pipe "I:\anuj\gzip -dc I:\Anuj\rawdata.txt.gz" LRECL=80; 82   libname anuj "I:\anuj\"; NOTE: Libname ANUJ refers to the same physical library as AJ. NOTE: Libref ANUJ was successfully assigned as follows:       Engine:        V9       Physical Name: I:\anuj 83   DATA anuj.test; 84     INFILE in missover; 85     INPUT make $ 1-14 mpg 15-18 weight 19-23 price 24-27 ; 86   RUN; NOTE: The infile IN is:       Unnamed Pipe Access Device,       PROCESS=I:\anuj\gzip -dc I:\Anuj\rawdata.txt.gz,       RECFM=V,LRECL=80 NOTE: 5 records were read from the infile IN.       The minimum record length was 27.       The maximum record length was 27.       One or more lines were truncated. NOTE: The data set ANUJ.TEST has 5 observations and 4 variables. NOTE: DATA statement used (Total process time):       real time           0.09 seconds       cpu time            0.00 seconds CODE 2 FILENAME in Pipe 'I:\anuj\temp folder\gzip -dc "I:\Anuj\temp folder\rawdata.txt.gz"'; DATA anuj.test;   INFILE in missover;   INPUT make $ 1-14 mpg 15-18 weight 19-23 price 24-27 ; RUN; LOG2: 87   FILENAME in Pipe 'I:\anuj\temp folder\gzip -dc "I:\Anuj\temp folder\rawdata.txt.gz"'; 88   DATA anuj.test; 89     INFILE in missover; 90     INPUT make $ 1-14 mpg 15-18 weight 19-23 price 24-27 ; 91   RUN; NOTE: The infile IN is:       Unnamed Pipe Access Device,       PROCESS=I:\anuj\temp folder\gzip -dc "I:\Anuj\temp folder\rawdata.txt.gz",       RECFM=V,LRECL=256 Stderr output: 'I:\anuj\temp' is not recognized as an internal or external command, operable program or batch file. NOTE: 0 records were read from the infile IN. NOTE: The data set ANUJ.TEST has 0 observations and 4 variables. NOTE: DATA statement used (Total process time):       real time           0.07 seconds       cpu time            0.03 seconds ... View more

Thanks for response. ... View more

using "-" for missing value is not advisable. every tool has its own limitation and solution vary desired output to output. there are 3 way 1- create dashboard template for files and create refrence with ur output excel files. in this case u just need to refresh ur templates. 2- use tagset that will provide desired formatted output, but in this ur need to save as excel 3-compromise with ur format and export excel . and once set ur format to excel. from next time excel export file will create file as format set by you. but in this u will get only one row for ur header. ... View more

for this warning need not to worry. Basically tagset create XML file which u need to open it  on excel and after that u need to save as excel workbook. at the same time u find ur missing format will be there NOTE: "-" this missing option is not advisable. ... View more

can anyone help me on this?? ... View more

Thanks, i will try to look into. Just drop few sample files and exact path, i will replicate that from myside. Good day ... View more

try this : %let dirname = %nrbquote("I:\Anuj\temp folder"); %let dirname2 = I:\Anuj\temp folder; %put &dirname &dirname2; filename DIRLIST pipe "dir /B &dirname\*.xls"; data dirlist ;      length fname $256;      infile dirlist length=reclen ;      input fname $varying256. reclen ; run; proc sql noprint; select fname into: fname separated by "|" from dirlist; %let filecount= &sqlobs; quit; %put &fname &filecount; %macro readfiles(); %do i= 1 %to &filecount; %let infile= %scan(%bquote(&fname),&i,%str(|)); %let outfile=%substr(&infile,1,%eval(%index(&infile, xls)-2)); proc import datafile="I:\Anuj\temp folder\&infile." out=&outfile dbms=excel; run; %end; %mend readfiles; %readfiles; ... View more

run ur script in batch mode. ... View more