• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 765
  • Last Modified:

SAS Program Running with SAS Server and Local

hi,
I am running a SAS Program. I have two sas dataset reading from SAS server and two from Local Computer.
when I run program and select server, i get an error msg "Local lib is not assigned",
may I know how to access both the libraries in a same program.
thanks
0
premkripalani
Asked:
premkripalani
  • 3
  • 3
1 Solution
 
Aloysius LowCommented:
do you have the physical location on your hard disk where the 2 sas datasets are stored?

how are you running the program? is it a user written code or some out-of-box functions?
0
 
premkripalaniAuthor Commented:
do you have the physical location on your hard disk where the 2 sas datasets are stored?

YES, IT IS ON SHARE DRIVE.

how are you running the program? is it a user written code or some out-of-box functions?
ITS A USER WRITTEN CODE AS PER BELOW

data Head_of_school ;
set HOH.school;
if staff_id = staff_id_1 ;
if relationship_code = '0' ;
keep Staff_Id;;
run ;
0
 
Aloysius LowCommented:
since you are running as a sas code, you can do a libname assignment:
libname HOH "[physical path]";

before running your code.
0
Improve Your Query Performance Tuning

In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!

 
premkripalaniAuthor Commented:
I have done that. assign the physical path. but half the code has library on server so i have to select server to run program. while doing that it is not reading local computer filename.

0
 
Aloysius LowCommented:
I see what you are referring to.

I don't know of anything which allows you to do so. The solution I see is to split the code into 2 and process separately. However, it won't be straightforward and in between, some work-around might be required.
0
 
premkripalaniAuthor Commented:
no problem, got it.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now