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;
It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.
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.