Help using Base SAS procedures

Reg:Finding the recently updated Dataset

Reply
Regular Contributor
Posts: 229

Reg:Finding the recently updated Dataset

data x1;
input id sal ;
cards;
12 23
78 45
run;

data x2;
input id sal;
cards;
23 56
78 59
run;

data x3;
input id sal;
cards;
02 56
45 86
run;


data x_fin;
set x1 x3 x2;
run;

data x5;
input id sal;
cards;
02 56
45 86
run;


data x_fin;
set x1 x3 x2 x5 ;
run;


data x6;
input id sal;
cards;
02 56
45 86
run;

data x_fin;
set x1 x3 x2 x5 x6;
run;

i have created x_fin dataset by keeping x1,x2,x3 and after that i have added x5 and updated and after that i have added x6 to the dataset x_fin now.i want the dataset that was recently updated to x_fin and i should move that observations to a new dataset as x_updsets.so please help me out this is a example as Real time daily many datesets will come and set to one dataset now i want to find which dataset was added to it recently Message was edited by: Main
Valued Guide
Posts: 2,174

Re: Reg:Finding the recently updated Dataset

are you looking for [pre] &SYSLAST[/pre]
That provides the name of the latest data set created. The online doc is at http://support.sas.com/documentation/cdl/en/mcrolref/61885/HTML/default/a000210371.htm .

hope it helps

PeterC
Ask a Question
Discussion stats
  • 1 reply
  • 110 views
  • 0 likes
  • 2 in conversation