Exploring, modeling, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

SAS VA Program script

Accepted Solution Solved
Reply
New Contributor
Posts: 3
Accepted Solution

SAS VA Program script

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 

 


Accepted Solutions
Solution
‎06-15-2016 05:35 AM
Contributor
Posts: 26

Re: SAS VA Program script

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

View solution in original post


All Replies
Contributor
Posts: 50

Re: SAS VA Program script

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.

New Contributor
Posts: 3

Re: SAS VA Program script

Thanks for your reply sir.

Solution
‎06-15-2016 05:35 AM
Contributor
Posts: 26

Re: SAS VA Program script

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

New Contributor
Posts: 3

Re: SAS VA Program script

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

Frequent Contributor
Posts: 121

Re: SAS VA Program script

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

 


Tricia Aanderud
Zencos Consulting
Twitter: @taanderud - Follow me!

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 5 replies
  • 387 views
  • 1 like
  • 4 in conversation