DATA Step, Macro, Functions and more

in SAS, letter case really doesn't matter?

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 11
Accepted Solution

in SAS, letter case really doesn't matter?

Hi guys,

 

I just got a question, need your help: letter case in SAS seems making difference, at least in the case of "if...(then)".  Look at this example:

 

data _t_;
input ID Name$ bloodtype$ Weight;
if bloodtype='a'; 
cards;
3 kelly a 120
4 brown A 200
;
run;

 

the result has only 1 line (3 kelly a 120).

 

if I change 'a' to 'A', then I get another line (4 brown A 200).

 

both didn't give me a result of all 2 lines.

 

does this mean, in some cases, letter case matters?

 

thanks,


Accepted Solutions
Solution
‎03-01-2016 01:01 PM
Super User
Posts: 19,782

Re: in SAS, letter case really doesn't matter?

In your code case doesn't matter. 

For variable values then it does matter.

 

This means you can do the following and it won't make a difference:

 

prOC MEAns data=SAShelP.ClasS;
ruN;

But when testing strings and comparison, then a variable value of 'a' is different than 'A'

 

if var1='a' then ...;

 

is different than

 

if var1='A' then..;

 

Solution, when making string comparisons, upcase or lowcase the strings before comparison.

 

if upcase(var1)='A' then..

View solution in original post


All Replies
Solution
‎03-01-2016 01:01 PM
Super User
Posts: 19,782

Re: in SAS, letter case really doesn't matter?

In your code case doesn't matter. 

For variable values then it does matter.

 

This means you can do the following and it won't make a difference:

 

prOC MEAns data=SAShelP.ClasS;
ruN;

But when testing strings and comparison, then a variable value of 'a' is different than 'A'

 

if var1='a' then ...;

 

is different than

 

if var1='A' then..;

 

Solution, when making string comparisons, upcase or lowcase the strings before comparison.

 

if upcase(var1)='A' then..
Occasional Contributor
Posts: 11

Re: in SAS, letter case really doesn't matter?

thank Reeza for quick reply, your answer works. I confused code case and value case. I'm a newbie.
☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 204 views
  • 2 likes
  • 2 in conversation