topic Re: syntax for Two nested case statements in SAS Programming

syntax for Two nested case statements

GN0001 — Wed, 07 Jul 2021 17:50:05 GMT

Hello team,
I want to write two nested case statements:

case1
field1 > field2 and field2> field3 and field3 >field4 then
case1
case2
case3

case2 field1 < field2 and field2< field3 and field3 <field4 then
case1
case2
case3

What would be the syntax? Or is this doable?

Regards,

Blue blue

Re: syntax for Two nested case statements

PaigeMiller — Wed, 07 Jul 2021 18:49:55 GMT

I don't really understand what you are trying to do.

Can you explain in words? Can you give a small example?

Re: syntax for Two nested case statements

Reeza — Wed, 07 Jul 2021 19:24:33 GMT

You're trying to check if the fields are sorted in order of ascending or descending?

Re: syntax for Two nested case statements

GN0001 — Wed, 07 Jul 2021 20:08:48 GMT

How can I check?
So would that be;
If field1 > field2 then
When case ….then,,,
When case….then…
End as ‘this’

Else

When case.,,,then….
When case….then.,.

End as ‘that’

End if

Regards.
Blueblue

Re: syntax for Two nested case statements

PaigeMiller — Wed, 07 Jul 2021 20:19:15 GMT

If field1 > field2 then
When case ….then,,,
When case….then…
End as ‘this’

Else

When case.,,,then….
When case….then.,.

End as ‘that’

End if

I still don't understand the question.

Re: syntax for Two nested case statements

Reeza — Wed, 07 Jul 2021 20:25:44 GMT

Your title and code/comments do not align. Are you trying to nest your CASE statements? It would be better if you explained what you were trying to do.

Re: syntax for Two nested case statements

GN0001 — Wed, 07 Jul 2021 20:34:32 GMT

Hello all,

yes, I need to nest my case statement within another case statement of within an if else statement:

but I have to say if the sort is like field1 > field 2, then

else somethingelse

end;

But within each part of if else we have case statements.

I hope this makes sense.

Thanks,

blueblue

Re: syntax for Two nested case statements

Reeza — Wed, 07 Jul 2021 20:36:58 GMT

Unfortunately this still doesn't make sense, especially since CASE statements are a SQL concept and IF/ELSE is a data step so not sure how you would nest those? Typically a CASE statement is the IF/ELSE from a data step.

I think it's time you illustrate your problem with some example data.

Re: syntax for Two nested case statements

GN0001 — Wed, 07 Jul 2021 20:47:58 GMT

Reeza,

Thanks for the response.

This is the sketch of what I have in mind.

case

When (field1>field2 and field2>field3) Then

case

when this then than /*this is nested within the first case*/

end

When (field1<field2 and field2<field3) Then

case

when this then than /*this is nested within the first case*/

end

Thanks for the response.

blueblue

Re: syntax for Two nested case statements

Reeza — Wed, 07 Jul 2021 20:50:29 GMT

It's structured correctly then, so what is the issue? Did your code like that not work?

Re: syntax for Two nested case statements

Reeza — Wed, 07 Jul 2021 20:54:20 GMT

Entirely useless example:

proc sql;
create table example as
select *, case when age <14 then (case when sex = 'F' then "FEMALE" else "MALE" end) 
               when age >=14 then (case when sex = 'F' then "Female" else "Male" end) end as gender
from sashelp.class;
quit;

Re: syntax for Two nested case statements

GN0001 — Mon, 12 Jul 2021 03:32:54 GMT

Hello,

Please refer to this:

You're trying to check if the fields are sorted in order of ascending or descending?

Yes, I am trying to see how I need to write it.

Regards,

blue blue

Re: syntax for Two nested case statements

GN0001 — Mon, 12 Jul 2021 03:33:50 GMT

Yes, I am trying to nest two case statement.

Regards,

blueblue

Re: syntax for Two nested case statements

GN0001 — Mon, 12 Jul 2021 03:34:41 GMT

I am working on it to see who to write. I am thinking about the logic.
Thanks,
blueblue

Re: syntax for Two nested case statements

GN0001 — Mon, 12 Jul 2021 03:35:37 GMT

Please give me some time to test it.

Regards,

blueblue

Re: syntax for Two nested case statements

GN0001 — Mon, 12 Jul 2021 03:36:48 GMT

why useless!!?

I already have a screenshot of it.

Regards,

blueblue