Hi SAS users, I have a simple macro (macro1) that creates a dataset with n observations of 1 string variable. I use the string variable to construct a file name. Within a data step I want to pass the file name to macro2 (n times), Macro2 uses the filename as an argument to open the appropriate file and do some stuff. But the filename is not being passed to macro2. Can someone tell me what I'm doing wrong? All help will be greatly appreciated. SAS version 9.2 Win7 Code looks like this: %macro macro1; * do some stuff to create dset1 with n observations of 1 string variable ('prov'); * I have confirmed that dset1 exists, and that it has the correct string variable 'prov'; data _NULL_; set dset1; f2r = 'c:\directoryname\'||trim(prov)||'_vol.dat'; call execute('%macro2(f2r)'); run; %mend macro1; %macro macro2(fname); data dset2; infile dummy filevar = &fname firstobs=2; input name $ id_no ecoreg; run; * do some stuff with dset2; %mend macro2;
... View more