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. 

 

sas-innovate-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

Register now!

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
  • 656 views
  • 0 likes
  • 2 in conversation