Hi, I am trying to export my sas code into an excel file. However, when I typed this code this is the message I am receiving.
code:
proc export data=WORK.IMPORT
outfile="C:/User/user/Documents/export/resultingdataset.xlsx"
dbms=xlsx;
run;
result:
This problem has been discussed so many times .... the server your sas session is running on can't access your local drives.
I am able to export with the SAS Export Wizard but I get this error when I try to do it with proc export. I have copied and pasted the path from the wizard.
What is the path from the SAS Export Wizard? If it is a path on your PC then the remote SAS server running PROC EXPORT will not be able access it. Talk to your SAS administrator about setting up a folder share that will work for both methods.
Ok that makes sense.
Btw, the path is to a location on the LAN.
Same applies for LAN folders. You'll need to get an IT administrator to set up a SAS server folder share with the LAN folder.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.