Hi Guys;
Here I am trying to get upcase data and low case data
data low_upper;
input name $ city $ 15.;
cards;
ravi mumbai
SIRISHA HYDEABAD
vinay delhi
GANESH BANGALURU
;
run;
data low;
set low_upper;
if name upcase(name) then output;
run;
data low_upper;
input name $ city $ 15.;
cards;
ravi mumbai
SIRISHA HYDEABAD
vinay delhi
GANESH BANGALURU
;
run;
data low;
set low_upper;
if name = lowcase(name) then output;
run;
data upper;
set low_upper;
if name = upcase(name) then output;
run;
What does this log tell you:
83 data low;
84 set low_upper;
85 if name upcase(name) then output;
______
22
ERROR 22-322: Syntaxfehler, erwartet wird eines der folgenden: !, !!, &, (, *, **, +, -, /, ;, <, <=, <>, =, >, ><, >=, AND, EQ,
GE, GT, LE, LT, MAX, MIN, NE, NG, NL, OR, [, ^=, {, |, ||, ~=.
86 run;
and what would you do to fix it?
After ~400 posts here, this is trivial for you to fix.
data low_upper;
input name $ city $ 15.;
cards;
ravi mumbai
SIRISHA HYDEABAD
vinay delhi
GANESH BANGALURU
;
run;
data low ;
set low_upper;
if prxmatch('/[A-Z]/',name) then delete;
run;
data upper ;
set low_upper;
if prxmatch('/[a-z]/',name) then delete;
run;
data low_upper;
input name $ city $ 15.;
cards;
ravi mumbai
SIRISHA HYDEABAD
vinay delhi
GANESH BANGALURU
;
run;
data low;
set low_upper;
if name = lowcase(name) then output;
run;
data upper;
set low_upper;
if name = upcase(name) then output;
run;
April 27 – 30 | Gaylord Texan | Grapevine, Texas
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!
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.
Ready to level-up your skills? Choose your own adventure.