Using upcase function in SAS programming?

Question

Very new to SAS programming 0.0 I am trying to change the title "Listing of Data Set Health" to all uppercase and what I am doing isn't working. PLS HELP.

proc format;
value $Gender
'M'='Male'
'F'='Female'
other= 'Unknown'; * Handle Missing Values;
run;
data health;
infile '/folders/myfolders/health.txt' pad;
input @1 Subj $3.
@4 Gender $1.
@5 (Age HR) (2.)
@9 (SBP DBP Chol) (3.);



if Chol gt 200 then do;
Stoke_Risk = 'High';
LDL_Group = 'Bad';
end;

if Age le 21 then Age_Group = 1;
else if Age le 59 then Age_Group = 2;
else if Age ge 60 then Age_Group = 3;

format Gender $Gender.; *this line could be under data or proc
print;

Current_Year = year(today()); *current year based on today and year function;
Short_Gender = lowcase(Gender); *lower case function for string;
ABP = mean(SBP, DBP); *mean of blood pressure;

run;

title "Listing of Data Set Health";
proc print data=health;
ID Subj;
run;

SAS proc variable names seem to be case insensitive. It may repeat the first used case format (upper, lower, mixed) during your session. Try logging out, then logging in and re-define the proc variable using all caps. ("SAS is not case-sensitive. You can use capital or lowercase letters in your SAS variables." https://campusguides.lib.utah.edu/c.php?g=160854&p=2455181 ) — Jennifer Yoon, Aug 04 '20 at 21:28

score 0 · Answer 1 · answered Aug 04 '20 at 21:24

The title statement is a global statement that is used in open code. If you would like it to always be upper-case, you will want to type your title directly in upper-case:

title "LISTING OF DATA SET HEALTH";

If you want to be able to have it always be in upper-case no matter what you type, you will need to delve into the SAS Macro Facility and macro functions. This is a more advanced aspect of SAS that you will get into later.

The %upcase() macro function can be used in open code to convert any text to upper-case.

title "%upcase(listing of data set health)";

Note that this function differs from upcase(), which you will use in the data step. Functions starting with % are special macro functions.

score 0 · Answer 2 · answered Aug 05 '20 at 12:55

0

You can explicitly change it to uppercase in the title statement:

title "LISTING OF DATA SET HEALTH";

If you want to change the title dynamically, you could write a macro like:

%let title = "Listing of Data Set Health";
title "%upcase(&title.)";

answered Aug 05 '20 at 12:55

user2813606

797
2
13
37

score -1 · Answer 3 · edited Jul 31 '23 at 08:58

-1

This will work:

Title %upcase("Listing of Data Set Health");

edited Jul 31 '23 at 08:58

Tyler2P

2,324
26
22
31

answered Jul 24 '23 at 07:13

Shashank Sahu

1
1

Using upcase function in SAS programming?

3 Answers3