- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Hi SAS Community,
I am having trouble viewing the available data( I can see the SAS datasets but not the excel spreadsheets) once I write a libname to the shared drive. It works when I write a libname to my personal documents folder though. We have SAS running on windows 2012 r2 server. Can you please help me on this? Any suggestions would be much appreciated.
Raghu.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Check your path names. I had a similar issue recently and, depending on how the report is run, the output is placed in different locations.
This was my solution:
%if &sysuserid = sasrpt %then %do;
PROC IMPORT out=health
FILE= "/home/sasrpt/output/prod/filename.csv"
DBMS=csv REPLACE;
guessingrows=3000;
RUN;
%end;
%else %if &sysuserid = study%then %do;
PROC IMPORT out=health
FILE= "/home/study/study/filename.csv"
DBMS=csv REPLACE;
guessingrows=3000;
RUN;
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Thanks Tanya for the response. I will follow it and let you know.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
This solution was successful but I had to program for three different possibilities because of our environments and how the report was run.
Thank you for the guidance.