topic Re: SAS VA Program script in SAS Visual Analytics

SAS VA Program script

NitinSingh — Mon, 13 Jun 2016 13:53:50 GMT

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 — Mon, 13 Jun 2016 14:26:13 GMT

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.

RichardPaterson — Tue, 14 Jun 2016 15:17:31 GMT

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 — Wed, 15 Jun 2016 09:37:35 GMT

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

NitinSingh — Wed, 15 Jun 2016 09:40:16 GMT

Thanks for your reply sir.

TriciaAanderud — Wed, 15 Jun 2016 14:27:39 GMT

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