URGENT HELP PLEASE!!

[Patelbb]

Hi,

I was wondering if someone can help me with this. I've been stuck on this for a while now and need an answer fast as I have an assignment to hand in.

I'm not quite sure how to write SAS code for the following problem: "If the first character of s_cmstdtc is "U", leave the numeric value missing."

Any help will be appreciated! Thank you!!

[kiranv_ · Accepted solution]

use char or substr function 

data class;
set sashelp.class;
if upcase(char(name,1))="A" then new_var = .;
else new_var = 0;
if upcase(substr(name,1,1))="A" then new_var1 = .;
else new_var1 = 0;
run;

[Patelbb]

Thank you!!!

[novinosrin]

@Patelbb While it is perfectly fine to seek urgent help, you could also post better samples of what you have and want rather than a plain sentence leading to some ambiguity where it's a variable operand/constant operand and what and where to assign missing or leave missing as per your words

Anyways, first function is very convenient for you to use rather than char or substr if i understand your requirement

if first(strip(var))='U' then do whatever you want