proc transpose /proc report

deleted_user — Thu, 26 Jun 2008 12:36:32 GMT

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

Re: proc transpose /proc report

deleted_user — Thu, 26 Jun 2008 20:04:37 GMT

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

topic Re: proc transpose /proc report in ODS and Base Reporting

proc transpose /proc report

Re: proc transpose /proc report