|
Hi,
I have two different datasets, for each of the datasets I have the
data for each variable for 20 years (in 20 different data files).
I want to merge the two datasets:
DATA ONE;
INFILE 'D:\DATA\ANN84.CSV' DLM=',' DSD MISSOVER FIRSTOBS=2;
INPUT VAR1 VAR2 VAR3 YEAR ID;
DATA TWO;
INFILE 'D:\DATA\EXE84.CSV' DLM=',' DSD MISSOVER FIRSTOBS=2;
INPUT VAR1 VAR2 VAR3 YEAR ID;
DATA THREE;
MERGE ONE (IN=A) TWO (IN=B);
BY ID;
IF A AND B;
RUN;
I need to do this for every year. Is there some way to run the program
just once and get the required results? I just don't like the idea of
run the same program over and over again.
Thanks!
| 
