Hi All,
I want to know how to load/unload a table (In SAS VA) by sas programming script because i need to save that script for futher useage.
could anyone please help for the same.
Appreciate your help.
Thanks,
Nitin Singh
an alternative to unloading a LASR table is by using the proc datasets procedure -
proc datasets lib = LASRLIB nolist nowarn memtype = (data view);
delete <tablename>;
quit;
regards,
Richard
Unload a table
proc lasr port='portnumber';
remove libref.dataset;
performance host="sas.server.com"
install="/opt/TKGrid";
run;
Load a table
LIBNAME LASRLIB SASIOLA TAG=PUBLIC PORT=10031 HOST="sas.server.com" SIGNER="http://sas.server.com:7980/SASLASRAuthorization";
data LASRLIB.test;
set libref.test1;
run;
u have to find your port numbers host name etc. Most probably from sas administrators.
Thanks for your reply sir.
an alternative to unloading a LASR table is by using the proc datasets procedure -
proc datasets lib = LASRLIB nolist nowarn memtype = (data view);
delete <tablename>;
quit;
regards,
Richard
Thanks for your reply Sir. I have the script for unload a table. but i need script for load a table into LASR Server.
If you look back - the response from @naveenraj contains the code. There are some other methods but he is showing a straight-forward one.
Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
Register now!
See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.
Find more tutorials on the SAS Users YouTube channel.