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;
... View more