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.
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;
Thanks Tanya for the response. I will follow it and let you know.
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.
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.