macro quotation mark export

[Xiaoyi]

I would like to write a macro to export a dozen of SAS data files to .csv (with different names).  I want the file exported in the assigned folder to be data1.csv, but using the following code, I ended up with a file called '&outfile' NOT  the file name data1 which is what I wanted. Can anyone help to resolve this? Thank you.

Here is my code:

%let outfile=data1

proc export data=&outfile

outfile='C:\Users\shanx\Desktop\temp files\&oufile.csv' replace; 

run; 

[Reeza · Accepted solution]

You need to use double quotes when using macro variables, not single quotes.