Helo. I am having problems with this programme
proc export data=pg1.storm_final
outfile="&outpath/storm_final.csv"
dbms=csv replace;
run;
Says
ERROR: Export unsuccessful. See SAS Log for details.
How do I go about this?
Hi,
there is big chance you don't have write permission on a server to "/opt/sasinside/SASConfig/Lev1/SASApp" folder.
If I may suggest, try to change path to the file you want to create to something like: "~/storm_final.csv" for the beginning, to test if you can create it in your home directory.
The second thing is that since log says: "Physical file does not exist, /opt/sasinside/SASConfig/Lev1/SASApp/&outpath/storm_final.csv." it looks like macro variable &outpath didn't resolve properly, try to check if following results with proper path:
%put *&outpath*;
Let us know if it helped?
all the best
Bart
Did you look at the SAS Log as suggsted ?
What does it say ?
Your macro variable &outpath isn't set up correctly. Ensure that the macro variable is created and points to the directory you want it to.
@Adekemi wrote:
Yes. It reads
0 records created in &outpath/storm_final.csv from PG1.STORM_FINAL.
And also:
ERROR: Physical file does not exist, /opt/sasinside/SASConfig/Lev1/SASApp/&outpath/storm_final.csv.
Hi,
there is big chance you don't have write permission on a server to "/opt/sasinside/SASConfig/Lev1/SASApp" folder.
If I may suggest, try to change path to the file you want to create to something like: "~/storm_final.csv" for the beginning, to test if you can create it in your home directory.
The second thing is that since log says: "Physical file does not exist, /opt/sasinside/SASConfig/Lev1/SASApp/&outpath/storm_final.csv." it looks like macro variable &outpath didn't resolve properly, try to check if following results with proper path:
%put *&outpath*;
Let us know if it helped?
all the best
Bart
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.