Desktop productivity for business analysts and programmers

Loading and appending multiple table in to lasr from SASAPP

Reply
Contributor
Posts: 52

Loading and appending multiple table in to lasr from SASAPP

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

Super User
Posts: 1,243

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

Respected Advisor
Posts: 3,065

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

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;
Ask a Question
Discussion stats
  • 2 replies
  • 160 views
  • 1 like
  • 3 in conversation