topic Re: if then conditional syntax errors in SAS Programming

if then conditional syntax errors

NinaWestern — Sat, 30 May 2020 02:29:36 GMT

This should be fairly simple.

Trying to create a new variable for two groups separately.

For group a:

if diagn =0 or 1, then comorb=0;

if diagn >=2 then comorb=1;

For group b:

if diagn =0 then comorb=0;

if diagn >=1 then comorb=1;

The syntax for group2 works fine.

Here is my syntax for group1:

data x;

set x;

if group='a' then do;

if diagn =0 or diagn=1 then comorb=0;

else if diagn >=2 then comorb=1;

end;

This syntax does not calculate the comorb variable at all.

Any ideas on what might be wrong and how to correct it?

Thank you!

Re: if then conditional syntax errors

biopharma — Sat, 30 May 2020 02:43:59 GMT

Can you create a sample dataset with what you HAVE? Then present another dataset with what you WANT. Look how some posters have done this in a datastep and show.

If I were to take a wild guess, this condition is not met as specified.
if group='a' then do;

Try specifying this as
if upcase(group)="A" then do;

Re: if then conditional syntax errors

Shmuel — Sat, 30 May 2020 02:44:53 GMT

You haven't posted neither the log nor sample of your imput,

so it is impossible to know what is the mistake.

Is there a variable named GROUP in your input dataset ?

Re: if then conditional syntax errors

NinaWestern — Sat, 30 May 2020 02:52:30 GMT

Yes, there is a variable named "group", with a and b as its values.

The log has no errors.

Re: if then conditional syntax errors

Kurt_Bremser — Sat, 30 May 2020 03:53:59 GMT

Please post the whole log of your data step.