|
Hi SASLers,
I am trying to resolve a macro name 'inlib' inside filename pipe feature
(Windows NT env.) as follows:
%let inlib = C:\Accenture_Interactive_Projects\VISA_CANADA\VC_Sep09
\input_data\CSV_Files\Input;
filename indata pipe 'dir &inlib /b';
data file_list;
length fname $35;
infile indata truncover; /* infile statement for file names */
input fname $35.; /* read the file names from the directory */
if scan(compress(fname),-1,.)='csv'; /*only csv files qualify to
be read from folder**/
run;
My overall objective is to read all csv files in a folder.
But the macr variable 'inlib' does not resolve the way I expected. I have
tried playing around with double quotes. I really could not achieve it.
TIA,
Sharat
| 
