%macro conversion_sdata(filename); data &filename.; set twonov.&filename.; run; filename exprt "/mpoint/data_migration/&filename..csv" encoding="utf-8"; run; %mend; %conversion_sdata(ambs);
I tried this in sas on demand academic and it works fine,
when tried at work sas server, I get the following:
"ERROR: physical file does not exist, /mpoint/data/migration/ambs.csv.
0 records created in EXPRT from ambs.
why is that? how to resolve?
You resolved the problem yourself - great.
Please mark your own response as the solution. This helps potential respondents understand in advance that the original request has been satisfied.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.