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 save with the early bird rate—just $795!
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.