syntax for Two nested case statements

[GN0001]

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

[PaigeMiller]

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

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

[Reeza]

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

[GN0001]

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

[PaigeMiller]

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.

[GN0001]

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

[Reeza]

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.

[GN0001]

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

[Reeza]

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.

[GN0001]

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*/

        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*/

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

        end

end

Thanks for the response.

blueblue

[Reeza]

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

[GN0001]

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

[GN0001]

Yes, I am trying to nest two case statement.

Regards,

blueblue

[Reeza]

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;

[GN0001]

Please give me some time to test it.

Regards,

blueblue