Link to home
Start Free TrialLog in
Avatar of premkripalani
premkripalaniFlag for Australia

asked on

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
Avatar of Aloysius Low
Aloysius Low
Flag of Singapore image

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?
Avatar of premkripalani

ASKER

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 ;
since you are running as a sas code, you can do a libname assignment:
libname HOH "[physical path]";

before running your code.
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.

ASKER CERTIFIED SOLUTION
Avatar of Aloysius Low
Aloysius Low
Flag of Singapore image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
no problem, got it.