macro quotation mark export

Xiaoyi — Tue, 12 Jan 2021 22:19:05 GMT

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;

Re: macro quotation mark export

Reeza — Tue, 12 Jan 2021 22:20:51 GMT

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

topic macro quotation mark export in SAS Programming

macro quotation mark export

Re: macro quotation mark export