01-09-2013 10:28 AM
I just did a data set option but I don't want the data to be placed on different rows. I have 12 tables that all have 1 row with 4 columns of monetary data. I did the following data step:
data all; set t1 t2 t3 t4 t5 t6 t7 t8 t9 t10 t11 t12;
my all table now has 12 rows and 16 columns. How can I get it to have 1 row and 16 columns? All the columns have different names so I know what value came from where. Should I do a proc transpose or maybe I should just do a proc sql and create a table?
Need further help from the community? Please ask a new question.