What is SAS EG equivalent method to create a Case statement?

[ralizadeh]

I am not asking how to right a code. I am asking how to use Tasks in SAS EG to create such a statement.

I have an 'age' column and would like to group them into '<18', 'between 18 and 65', and '65+'.

Thank you in advance.

[AhmedAl_Attar]

Hi @ralizadeh 

You may want to look at this SAS Blog Entry : Creating a SAS format from a data set

Additional Info can be found here: SAS Enterprise Guide - Custom Tasks

One way of Binning values is using Formats.

Hope this helps

[AhmedAl_Attar]

@ralizadeh 

I just checked my EG 7.15 & 8.1 -- Under the Data Tasks, you should be able to find

- Create Format...

- Create Format from Data Set...

[ChrisHemedinger · Accepted solution]

You can use the Query Builder tool and "Recode" a column. In Query Builder, select Computed Columns, then New->Recode Column.

Through point and click selections, this will build a CASE statement.

[ralizadeh]

Thank you @ChrisHemedinger. You SAS guys here are awesome! 😀

[Reeza]

Via a Query - Computed Columns>New>Recode a Variable

https://support.sas.com/publishing/pubcat/chaps/61625.pdf

[ralizadeh]

Thanks @Reeza for sharing the document.