Proc report retain column names when outputting to a dataset

[Haydo]

I have the following code which will give me a dataset called "CCB_Data_2", however the column headers are called _C2_ all the way to _C118_ .

The columns will change based on weekly data, so if I manually rename _C2_ to _C118_, while correct this week, it will not be correct next week and so on.

Is there a way where the column names will remain that same as the original names?

proc report data=WORK.CCB_Data_1 out=Work.CCB_Data_2;
column Date_REF REF_Count,KEY_NAME_Key_VALUE;
define Date_REF / group;
define REF_Count / "" analysis sum;
define KEY_NAME_Key_VALUE/ "" across;

run;

[PaigeMiller]

Don't output from PROC REPORT to a SAS data set. Output to html table or EXCEL file.

[Tom · Accepted solution]

PROC REPORT is for making a REPORT.

If you want to make a DATASET then use PROC TRANSPOSE.

proc transpose data=CCB_Data_1 out=CCB_Data_2(drop=_name_);
  by Date_REF;
  var REF_Count ;
  id KEY_NAME_Key_VALUE ;
run;