topic Re: SAS EG Libname statements in SAS Programming

SAS EG Libname statements

raghubachu123 — Thu, 01 Aug 2019 14:58:54 GMT

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.

Re: SAS EG Libname statements

tanya_henderson — Thu, 01 Aug 2019 19:40:45 GMT

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;

Re: SAS EG Libname statements

raghubachu123 — Thu, 01 Aug 2019 20:02:58 GMT

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

Re: SAS EG Libname statements

tanya_henderson — Thu, 30 Apr 2020 12:13:10 GMT

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.