BookmarkSubscribeRSS Feed
raghubachu123
Calcite | Level 5

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.

3 REPLIES 3
tanya_henderson
Obsidian | Level 7

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
Calcite | Level 5

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

tanya_henderson
Obsidian | Level 7

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. 

 

Ready to join fellow brilliant minds for the SAS Hackathon?

Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.

Register today!
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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 3 replies
  • 694 views
  • 0 likes
  • 2 in conversation