BookmarkSubscribeRSS Feed
HeatherNewton
Quartz | Level 8
%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?

4 REPLIES 4
HeatherNewton
Quartz | Level 8

I found the bug!! I forgot to create the directory

thank you guys 

Tom
Super User Tom
Super User

@HeatherNewton wrote:

I found the bug!! I forgot to create the directory

thank you guys 


Did you also fix the fact that your posted code was NOT making any attempt to create a CSV file?

HeatherNewton
Quartz | Level 8
Yes i missed proc export line here
Thanks
mkeintz
PROC Star

@HeatherNewton 

 

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.

--------------------------
The hash OUTPUT method will overwrite a SAS data set, but not append. That can be costly. Consider voting for Add a HASH object method which would append a hash object to an existing SAS data set

Would enabling PROC SORT to simultaneously output multiple datasets be useful? Then vote for
Allow PROC SORT to output multiple datasets

--------------------------

hackathon24-white-horiz.png

The 2025 SAS Hackathon Kicks Off on June 11!

Watch the live Hackathon Kickoff to get all the essential information about the SAS Hackathon—including how to join, how to participate, and expert tips for success.

YouTube LinkedIn

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 4 replies
  • 1721 views
  • 2 likes
  • 3 in conversation