topic Re: What is SAS EG equivalent method to create a Case statement? in SAS Enterprise Guide

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

ralizadeh — Tue, 02 May 2023 15:54:43 GMT

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 — Tue, 02 May 2023 16:39:52 GMT

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

One way of Binning values is using Formats.

Hope this helps

AhmedAl_Attar — Tue, 02 May 2023 16:44:01 GMT

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 — Tue, 02 May 2023 16:48:13 GMT

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.

Reeza — Tue, 02 May 2023 16:50:16 GMT

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

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

ralizadeh — Tue, 02 May 2023 18:03:46 GMT

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

ralizadeh — Tue, 02 May 2023 18:05:23 GMT

Thanks @Reeza for sharing the document.