@aarnold18 wrote: Thanks, changing the single quotes to double got the file to export with the macro properly running.    However, it isn't in the CSV format now. it just exports as "file" Any ideas?    proc export data=Member outfile="......../Member_&date" dbms=csv replace; run; Huh?  If you wrote a CSV file it IS a CSV file.  Just look at it with any text editor. I suspect you are talking about the fact that you did not NAME the file with an extension of .csv. outfile="......../Member_&date..csv" Note the extra period.  The first one will be used by the macro processor to indicate where the name of the macro variable ends so you need the second one so it will be part of the actual name.   PS Don't let EXCEL open your CSV without double checking that it hasn't converted character strings to numbers (or worse thought they were date strings) and changed the values. ... View more