topic Re: Regarding If and then statement in SAS Data Science

Regarding If and then statement

anilgvdbm — Sat, 13 Sep 2014 13:17:51 GMT

Dear Friends,

when i run the belowed code

data want.BMI_women;

set have.BMI_women;

if Women_BMI le 16.00 then bmi="Severe thinness";

else if Women_BMI le 16.99 then bmi="Moderate thinness";

else if Women_BMI le 18.49 then bmi="Mild thinness";

else if Women_BMI le 24.99 then bmi="Normal range";

else if Women_BMI le 29.99 then bmi="Overweight";

else if Women_BMI le 34.99 then bmi="Obese class I";

else if Women_BMI le 39.99 then bmi="Obese class II";

else if Women_BMI ge 40.00 then bmi="Obese class III";run;

i am getting an error message like this

384 data nfhs_3.BMI_women;

385 set nfhs_3.BMI_women;

386 length bmi $20;

387 if Women_BMI le 16.00 then bmi="Severe thinness";

388 else if Women_BMI le 16.99 then bmi="Moderate thinness";

389 else if Women_BMI le 18.49 then bmi="Mild thinness";

ERROR: The name bmi is not a valid SAS name.

390 else if Women_BMI le 24.99 then bmi="Normal range";

ERROR: The name bmi is not a valid SAS name.

391 else if Women_BMI le 29.99 then bmi="Overweight";

392 else if Women_BMI le 34.99 then bmi="Obese class I";

393 else if Women_BMI le 39.99 then bmi="Obese class II";

394 else if Women_BMI ge 40.00 then bmi="Obese class III";

395 run;

i tried a lot for this but i didnt get the solution please help me out in this.

Thanks

Anil

Re: Regarding If and then statement

mohamed_zaki — Sat, 13 Sep 2014 14:12:44 GMT

I have tried your code and it work for me with no error

data BMI_women;

input Women_BMI ;

datalines;

20.22

34.33

-22.5

;

data BMI_women_new;

set BMI_women;

length bmi $25;

if Women_BMI le 16.00 then bmi="Severe thinness";

else if Women_BMI le 16.99 then bmi="Moderate thinness";

else if Women_BMI le 18.49 then bmi="Mild thinness";

else if Women_BMI le 24.99 then bmi="Normal range";

else if Women_BMI le 29.99 then bmi="Overweight";

else if Women_BMI le 34.99 then bmi="Obese class I";

else if Women_BMI le 39.99 then bmi="Obese class II";

else if Women_BMI ge 40.00 then bmi="Obese class III";

run;

try run the code above and see if you will get the same error

Re: Regarding If and then statement

Reeza — Sat, 13 Sep 2014 16:58:55 GMT

The code you've shown and the log don't match...the first references want.bmi_women and the log references nfhi_s.bmi_women.

You're writing the data back to the same data set which can cause errors, try writing it to a new data set.

Re: Regarding If and then statement

Tom — Sat, 13 Sep 2014 20:12:54 GMT

The only thing that I think that would produce a log like that would be if there are strange characters in your file so that what looks like "bmi" in the program either includes some hidden character or they are not actually the characters B, M and I.

For example if you type program code into WORD it might convert your quotes and hyphens to some other character that it thinks looks better. If you then try to run the program in SAS it will be confused by these non standard characters.

Re: Regarding If and then statement

anilgvdbm — Wed, 17 Sep 2014 04:56:15 GMT

Hi Tom and Reeza ,

Thanks for comenting even i changed the dataset name and variables names but still i am getting same error. I am totaly confused about this i wrote this type of codes earlier also. Bur i am not able to find out the error. Please clarify me where i habe done mistake? this code i have to apply for many files i mean i habe to apply macros here.

Waiting for your answers

Thanks a lot

Anil

Re: Regarding If and then statement

Tom — Wed, 17 Sep 2014 05:00:26 GMT

Can you paste in the actual characters from the SAS log?

Re: Regarding If and then statement

anilgvdbm — Wed, 17 Sep 2014 05:36:22 GMT

27 data nfhs_3.want;

28 set nfhs_3.BMI_women;

29 if Women_BMI le 16.00 then bmi="Severe thinness";

30 else if Women_BMI le 16.99 then bmi="Moderate thinness";

31 else if Women_BMI le 18.49 then bmi="Mild thinness";

ERROR: The name bmi is not a valid SAS name.

32 else if Women_BMI le 24.99 then bmi="Normal range";

ERROR: The name bmi is not a valid SAS name.

33 else if Women_BMI le 29.99 then bmi="Overweight";

34 else if Women_BMI le 34.99 then bmi="Obese class I";

35 else if Women_BMI le 39.99 then bmi="Obese class II";

36 else if Women_BMI ge 40.00 then bmi="Obese class III";

37 run;

NOTE: The SAS System stopped processing this step because of errors.

WARNING: The data set NFHS_3.WANT may be incomplete. When this step was stopped there were 0

observations and 119 variables.

NOTE: DATA statement used (Total process time):

real time 0.37 seconds

cpu time 0.00 seconds

Re: Regarding If and then statement

mohamed_zaki — Wed, 17 Sep 2014 06:17:22 GMT

When you run your code with other data sets (Any random created data set). Does you get the same Error?

Waiting for your answer...

Re: Regarding If and then statement

anilgvdbm — Wed, 17 Sep 2014 06:22:49 GMT

Hi Mohamed,

No i tried with other dataset i am not getting error even in the above codes when i will give run up to "moderate thinness" it will run. But i am getting only 3rd and 4th line of the codes is getting error.

Thanks

Anil

Re: Regarding If and then statement

mohamed_zaki — Wed, 17 Sep 2014 06:44:17 GMT

Do you mean that with your current data set if your code is as following

data nfhs_3.want;

set nfhs_3.BMI_women;

if Women_BMI le 16.00 then bmi="Severe thinness";

else if Women_BMI le 16.99 then bmi="Moderate thinness";

run;

without the rest of the if-then conditions, your program complete successfully (with out error, i mean).

Waiting for your answer...

Re: Regarding If and then statement

damanaulakh88 — Wed, 17 Sep 2014 06:48:31 GMT

HI Anil,

The following error message might appear when you open a SAS data set with Base SAS that was created with SAS Enterprise Guide:

The problem occurs because the VALIDVARNAME=ANY system option is the default in SAS Enterprise Guide, but VALIDVARNAME=V7 is the default in Base SAS. This means that variable names containing special characters such as the hyphen character or other characters can be created with SAS Enterprise Guide.

To overcome the problem, specify the following OPTIONS statement when you open these data sets with Base SAS:

options validvarname=any;

Thanks,

Daman

Re: Regarding If and then statement

Reeza — Wed, 17 Sep 2014 10:03:00 GMT

post a proc contents from your input data set.

Re: Regarding If and then statement

anilgvdbm — Wed, 17 Sep 2014 10:10:25 GMT

Hi Daman,

its working but its creating 2 variables with the same name half of the values are in one variable and half of the values in another variable. i attache screen shot for you.

Thanks and Regards,

Anil

Re: Regarding If and then statement

jakarman — Wed, 17 Sep 2014 10:44:32 GMT

Weel there must by a some weird character there. We cannot see it, but having two variables is telling there is a difference.

Re: Regarding If and then statement

damanaulakh88 — Wed, 17 Sep 2014 10:46:43 GMT

Where are the screen shots?

Re: Regarding If and then statement

anilgvdbm — Wed, 17 Sep 2014 10:57:41 GMT

see in the screen shot the last 2 variables BMI_Status and BMI_status... so don't know why it has repeated 2 time with gaps.

Re: Regarding If and then statement

jakarman — Wed, 17 Sep 2014 11:15:10 GMT

You have proved the variables are different. That is why you got the error and it did help to with using validvarname=all.
The source code does have different names caused by a weird combination we do not see. Obviously you are using SAS-pc DMS V9 with a latin1 characterset.

This should not cause any issues of this kind. We cannot replay the error of copy/paste source code. Either you typed it or it did a correction.
The screenshot is hardly to see how the letters of the variables are. That is the interesting part is there something to see on the spelling of the variable.

Re: Regarding If and then statement

Keith — Wed, 17 Sep 2014 11:44:30 GMT

Have you tried a different method to create your variable? Storing the values in PROC FORMAT is generally better practice in these situations. Try the code below, I'd be surprised if this causes the same error.

proc format;

value bmi_fmt

low-16 = 'Severe thinness'

16-<17 = 'Moderate thinness'

17-<18.5 = 'Mild thinness'

18.5-<25 = 'Normal range'

25-<30 = 'Overweight'

30-<35 = 'Obese class I'

35-<40 = 'Obese class II'

40-high = 'Obese class III';

run;

data nfhs_3.want;

set nfhs_3.BMI_women;

bmi = put(women_bmi, bmi_fmt.);

run;

Re: Regarding If and then statement

Reeza — Wed, 17 Sep 2014 13:55:59 GMT

That view displays the variables labels not the variable names. post the output of a proc contents On your input and output datasets.

Re: Regarding If and then statement

Tom — Wed, 17 Sep 2014 14:10:47 GMT

So there is nothing in the code that you have pasted that could generate the error you posted. But perhaps the code you are running does not really look like what you posted. Try copying your code and modifying as I have done below and see if you still get the error messages. If that makes the error message go away then perhaps the error messages are not about your code but are about your input data set.

3754 data want;

3755 * set nfhs_3.BMI_women;

3756 if Women_BMI le 16.00 then bmi="Severe thinness";

3757 else if Women_BMI le 16.99 then bmi="Moderate thinness";

3758 else if Women_BMI le 18.49 then bmi="Mild thinness";

3759 else if Women_BMI le 24.99 then bmi="Normal range";

3760 else if Women_BMI le 29.99 then bmi="Overweight";

3761 else if Women_BMI le 34.99 then bmi="Obese class I";

3762 else if Women_BMI le 39.99 then bmi="Obese class II";

3763 else if Women_BMI ge 40.00 then bmi="Obese class III";

3764 run;

NOTE: Variable Women_BMI is uninitialized.

NOTE: The data set WORK.WANT has 1 observations and 2 variables.

- Can you re-type the program?

- Can you read the program as data and check the characters.

data _null_;

infile 'mycode.sas' ;

input;

list;

run;