Loading and appending multiple table in to lasr from SASAPP

[Rahul_SAS]

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

[Shmuel]

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

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

[SASKiwi]

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;