BookmarkSubscribeRSS Feed
☑ This topic is solved. Need further help from the community? Please sign in and ask a new question.
Haydo
Obsidian | Level 7

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;

 

1 ACCEPTED SOLUTION

Accepted Solutions
Tom
Super User Tom
Super User

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;

View solution in original post

2 REPLIES 2
PaigeMiller
Diamond | Level 26
Don't output from PROC REPORT to a SAS data set. Output to html table or EXCEL file.
--
Paige Miller
Tom
Super User Tom
Super User

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;

SAS Innovate 2025: Register Now

Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 712 views
  • 2 likes
  • 3 in conversation