I have just run this step in SAS.
Proc transpose data=diags out=dx;
My question is once the file is created I can look at it and see how many diag columns were generated. I was just wondering if there was code to give me the results or to combine the next these two steps without manual intervention. The number of columns will vary relative to the data.
My next step is: (assuming 10 columns were generated)
Set dx rename=col1-col10=dx10-dx10 drop=_name_ _label_);