SAS EG Libname statements

[raghubachu123]

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.

[tanya_henderson]

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;

[raghubachu123]

Thanks Tanya for the response. I will follow it and let you know.

[tanya_henderson]

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.