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
filename indata pipe 'dir &inlib /b';
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**/
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.