proc transpose /proc report

[deleted_user]

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

[deleted_user]

You can't use the IDLABEL statement without a previous ID statement.