premkripalani
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
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
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 ;
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.
libname HOH "[physical path]";
before running your code.
ASKER
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
no problem, got it.
how are you running the program? is it a user written code or some out-of-box functions?