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;
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
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.