SAS VA Program script

[NitinSingh]

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 

[naveenraj]

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.

[NitinSingh]

Thanks for your reply sir.

[RichardPaterson · Accepted solution]

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

[NitinSingh]

Thanks for your reply Sir. I have the script for unload a table. but i need script for load a table into LASR Server. 

[TriciaAanderud]

If you look back - the response from @naveenraj contains the code.  There are some other methods but he is showing a straight-forward one.