BookmarkSubscribeRSS Feed
cgates
Obsidian | Level 7

I'm running a simple program with SAS EG (Version 7.15 HF9 (7.100.5.6226) (64-bit)) that outputs an excel file to two different file paths. Prior to a few weeks ago, this code ran without any issues. My IT team uninstalled and reinstalled SAS on my PC and it has created more problems than it has solved. There remains one issue that they cannot resolved after the installation so I'm hoping you can help me out. I have my Y drive mapped to an online SharePoint location. When I try to output to this location now I get an error message that says  "ERROR: Physical file does not exist, Y:\1_Output\Report 01AUG2020 - 31AUG2020.xlsx.  The file outputs to the second location "G drive" with no issues. I've checked my mapped drives and the Y drive is there with the folder (image attached). I run SAS EG as administrator so there shouldn't be any privilege issues. My coworkers and I all have the SharePoint location mapped to our Y drives and they can run the same program and the file outputs to the G drive and Y drive with no problem. It's just me with the issue now. 

 

*Generating Excel spreadsheet;

ods listing close;
ods excel file = "Y:\1_Output\Report &first - &last..xlsx"

options (embedded_titles = 'yes' embedded_footnotes = 'yes');

ods excel (id=srf) file = "G:\Groups\Automation\Output\Monthly\Report &first - &last..xlsx"

options (embedded_titles = 'yes' embedded_footnotes = 'yes');

*By Gender;
ods excel options (sheet_name="By Gender");
proc freq data=Final;
tables group*gender/ nopercent norow nocol;
title "By Gender, &first - &last";
footnote 'Pulled today';
run;

ods _all_ close;
ods listing;

 

Log Error:

ERROR: Physical file does not exist, Y:\1_Output\Report 01AUG2020 - 31AUG2020.xlsx.
NOTE: Writing EXCEL(SRF) file: G:\Groups\Automation\Output\Monthly\Report 01AUG2020 - 31AUG2020.xlsx

 

Mapped drive:

Y Drive.PNG

 

Thank you!

 
2 REPLIES 2
SASKiwi
PROC Star

If your coworkers can run exactly the same code and it works for them, then this is not a SAS problem, it is a permissions / setup problem. You could try getting one of your coworkers to log onto your PC and try the program. If the error still occurs then it is likely a problem with your Y mapping. If it doesn't then the problem is with your userid. Raise the problem with your IT people.

SAS Innovate 2025: Save the Date

 SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!

Save the date!

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
  • 2 replies
  • 931 views
  • 1 like
  • 2 in conversation