topic Re: URGENT HELP PLEASE!! in New SAS User

URGENT HELP PLEASE!!

Patelbb — Sat, 01 Dec 2018 17:09:37 GMT

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!!

Re: URGENT HELP PLEASE!!

kiranv_ — Sat, 01 Dec 2018 17:39:48 GMT

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;

Re: URGENT HELP PLEASE!!

novinosrin — Sat, 01 Dec 2018 17:53:50 GMT

@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

Re: URGENT HELP PLEASE!!

Patelbb — Sat, 01 Dec 2018 18:48:07 GMT

Thank you!!!