BookmarkSubscribeRSS Feed
Whitlea
Obsidian | Level 7

Sas 9.4

I am trying to have my variable labels show up in my titles instead of my variable names.  Labels are listed in data step.  title statement  is in proc report. 

Thanks!

1 REPLY 1
PaigeMiller
Diamond | Level 26

Your command

 

title1 justify=center "Idaho Adults Who Used Marijuana by &var, 2015";

specifically tells SAS to use the variable name &var.

 

 

You probably want to extract the label from the variable using the VLABEL function in a data step prior to PROC REPORT, and then assign that label to a macro variable. (Or, extract the label from the DICTIONARY table and then assign it to a macro variable).

 

UNTESTED CODE

data _null_;
set work.brfss15; call symputx('label',vlabel(&var)); run; title1 justify=center "Idaho Adults Who Used Marijuana by &label, 2015";

 

--
Paige Miller

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

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
  • 2747 views
  • 0 likes
  • 2 in conversation