Date:         Wed, 19 Nov 1997 22:24:57 -0500
Reply-To:     Jaguar5764@AOL.COM
Sender:       "SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>
From:         Mike Janicke <Jaguar5764@AOL.COM>
Subject:      Combining Two Data Sets

I have the following Data Sets:
(note that i am giving the ouput form proc print; )
 
(DATA CARS)
OBS MAKE    OCT94  NOV94  DEC94
1      ACURA   24        49         100
2      BMW      4          2            9
3      MAZDA   200      223        4
 
(DATA HEADERS)
OBS  COL1     COL2    COL3    COL4
1       MAKE     OCT94  NOV94  DEC94
 
 
ok,  data set HEADERS was obtained by using an algoritm to find variables in
data set cars and taking the transpose.  Hence the COL headings.  I would
like to Append these two data sets so that the final data set is as follows:
 
DATA HEADERS;
OBS   COL1     COL2    COL3    COL4
1        MAKE     OCT94  NOV94  DEC94
2        ACURA    24        49         100
3        BMW       4          2            9
4        MAZDA    200      223        4
 
 
the point is that i want to code the rest of the program using the COL names
assigned in the proc transpose because these dates will change with each
running. So it would be better to work with generic variable names.  But I
would like to have the original variable names in the data set for
downloading to EXCEL.
 
I hope this isn't too wordy.  Thank you very much!
Mike Janicke