topic Re: Loading and appending multiple table in to lasr from SASAPP in SAS Enterprise Guide

Loading and appending multiple table in to lasr from SASAPP

Rahul_SAS — Sun, 25 Dec 2016 13:55:21 GMT

Dear Experts,

I have got a task which I am not able to solve please help me to get the result:

There are 10 or so datasets availble in SASAPP named Jan, Feb,...Sept, Dec. I have to upload all the datasets into lasr and append them so please help me to write that program whick will load the data into LASR.

for a single dataset is use SASIOLA, SAS LASR Engine and able to load a dataset quite easily but not multiple so please help.

Thnx

Rahul

Re: Loading and appending multiple table in to lasr from SASAPP

Shmuel — Sun, 25 Dec 2016 21:41:15 GMT

I hope next link and the inner links will help you:

http://support.sas.com/documentation/cdl/en/etlug/67323/HTML/default/viewer.htm#p1kdntr0rquru3n1oxzx6wbjihsb.htm

Re: Loading and appending multiple table in to lasr from SASAPP

SASKiwi — Sun, 25 Dec 2016 23:55:41 GMT

The easiest way to do this is to append all ten tables first into a temporary table, then load the one temporary table into LASR by running the following code on your SAS VA app server (default LIBREF is LASRLIB - you may need to check this):

data load_table;
  set jan feb mar apr........dec;
run;

data LASRLIB.load_table;
  set load_table;
run;