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

Just want to know why the report created using code below could not display label names without _? Anyone can help? Thanks.

 


PROC PRINT DATA=MYDATA
BY BRANCH_CODE BRANCH_NAME;
ID BRANCH_CODE BRANCH_NAME;
SUM BRANCH_PROFIT;
LABEL BRANCH_CODE="BRANCH CODE";
LABEL BRANCH_NAME="BRANCH NAME";
LABEL BRANCH_PROFIT="BRANCH PROFIT";
FORMAT BRANCH_PROFIT DOLLAR16.2;
RUN;

1 ACCEPTED SOLUTION

Accepted Solutions
Cynthia_sas
Diamond | Level 26
Hi:
Please read the PROC PRINT documentation, when you have a LABEL statement in your code, you need to tell PROC PRINT to USE the LABEL with the LABEL option in your PROC PRINT statement:
proc print data=mydata label;
or
proc print data=mydata split='_';

Either the LABEL or the SPLIT option tells PROC PRINT to use the LABEL for the data.

cynthia

View solution in original post

1 REPLY 1
Cynthia_sas
Diamond | Level 26
Hi:
Please read the PROC PRINT documentation, when you have a LABEL statement in your code, you need to tell PROC PRINT to USE the LABEL with the LABEL option in your PROC PRINT statement:
proc print data=mydata label;
or
proc print data=mydata split='_';

Either the LABEL or the SPLIT option tells PROC PRINT to use the LABEL for the data.

cynthia

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

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
  • 1 reply
  • 11737 views
  • 0 likes
  • 2 in conversation