Thank you so much con tester...
QUOTE=Con-Tester;153059]I’m going to assume that your first column (“PID”, “patient”, “room”) is called “VarName”, that the remaining eight columns are called “X1”, “X2”, … “X8” and that all the columns are text variables, not numeric. They are in a SAS dataset called “Test”. The following code should produce the desired result in a new dataset called “Test_T”:
Code:
proc transpose data = Test out = Test_T (drop = _NAME_);
id VarName;
var X1 X2 X3 X4 X5 X6 X7 X8; /* NOTE: Could also use "var X1-X8;" */
run;
[/QUOTE]