The SAS Output Delivery System and reporting techniques

proc transpose /proc report

Reply
N/A
Posts: 0

proc transpose /proc report

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
N/A
Posts: 0

Re: proc transpose /proc report

You can't use the IDLABEL statement without a previous ID statement.
Ask a Question
Discussion stats
  • 1 reply
  • 122 views
  • 0 likes
  • 1 in conversation