Thanks, ... I think we are getting closer. I don't get any "errors" with this code but I get a lot of notes that the tables have been dropped. This may be a dumb question, but since I'm literally just learning SAS data steps for this project, what does it mean when a table is "dropped" in the SAS universe? Does that mean the table no longer exists? I also get a note (below) about performing one or more Cartesian product joins, and I'm not sure how that affects the tables. MPRINT(GETDATA): data t; MPRINT(GETDATA): set dum B12Y12 B24Y24 B25Y25 B35Y35; MPRINT(GETDATA): run; NOTE: There were 0 observations read from the data set WORK.DUM. NOTE: There were 1 observations read from the data set WORK.B12Y12. NOTE: There were 1 observations read from the data set WORK.B24Y24. NOTE: There were 1 observations read from the data set WORK.B25Y25. NOTE: There were 1 observations read from the data set WORK.B35Y35. NOTE: The data set WORK.T has 4 observations and 24 variables. NOTE: DATA statement used (Total process time): real time 0.06 seconds cpu time 0.06 seconds MPRINT(GETDATA): proc transpose data=t out=tl; MPRINT(GETDATA): var f1-f24; MPRINT(GETDATA): run; NOTE: There were 4 observations read from the data set WORK.T. NOTE: The data set WORK.TL has 24 observations and 6 variables. NOTE: PROCEDURE TRANSPOSE used (Total process time): real time 0.15 seconds cpu time 0.03 seconds MPRINT(GETDATA): proc sql; MPRINT(GETDATA): create table ds001 as select id, date, var2, col1 as t , col2 as val1 format=best., col3 as val2 format=best., col4 as val3 format=best. from id, A10C10, A11B11, tl; NOTE: The execution of this query involves performing one or more Cartesian product joins that can not be optimized. NOTE: Table WORK.DS001 created, with 24 rows and 7 columns. MPRINT(GETDATA): drop table id, A10C10, A11B11, dum, B12Y12, B24Y24, B25Y25, B35Y35, tl, t; NOTE: Table WORK.ID has been dropped. NOTE: Table WORK.A10C10 has been dropped. NOTE: Table WORK.A11B11 has been dropped. NOTE: Table WORK.DUM has been dropped. NOTE: Table WORK.B12Y12 has been dropped. NOTE: Table WORK.B24Y24 has been dropped. NOTE: Table WORK.B25Y25 has been dropped. NOTE: Table WORK.B35Y35 has been dropped. NOTE: Table WORK.TL has been dropped. NOTE: Table WORK.T has been dropped. MPRINT(GETDATA): quit; NOTE: PROCEDURE SQL used (Total process time): real time 0.24 seconds cpu time 0.10 seconds 116 117 /* ... repeat for all worksheets. give all output datasets names starting with ds */
... View more