When using proc transpose, does the idlabel statement only work if the id statement is used?
For example (this does work):
PROC TRANSPOSE DATA=test_in
OUT=test_out
BY RecRegion TransMCP;
VAR Households;
ID effect_date;
IDLABEL EFF_DT;
run;
quit;
And this doesn't:
PROC TRANSPOSE DATA=test_in
OUT=test_out
BY RecRegion TransMCP;
VAR Households;
/* ID effect_date;*/
IDLABEL EFF_DT;
run;
quit;
I really want my columns called COL1 COL2 COL3, but want a string of data that is in eff_dt to be the label. Unless you can tell me how to use proc report column statement without "known" column names.
Thanks!
Lisa