topic Using output for IF Statement in SAS Programming

Using output for IF Statement

DavidLie — Mon, 17 May 2021 12:44:47 GMT

Hi all,

I have a question about using an output result for IF statement.

For example, I have a following data about size of a product.

My plan is to:

Use PROC Univariate to obtain the quartiles.
Categorise the data into three, based on results from Step 1.
- Group 1 if it's below Q1 (25th percentile)
- Group 2 if it's within Q1 and Q3
- Group 3 if it's above Q3
Repeat for different products

As I have 32 products, I would like to know if it can be done in a loop or something. Thanks in advance.

Best,
David

Have

Size
0.5
0.5
1
1
1
2
1
1
1
2
1
1
1
1
1

Want

Size	Group
0.5	1
0.5	1
1	2
1	2
1	2
2	3
1	2
1	2
1	2
2	3
1	2
1	2
1	2
1	2
1	2

Re: Using output for IF Statement

PaigeMiller — Mon, 17 May 2021 13:05:38 GMT

Use PROC RANK with GROUPS=4. This will place each value into one of 4 groups by quartiles, numbered as 0 through 3. If you want to have the group 25 percentile to 75 percentile, you can combine groups 1 and 2 from PROC RANK. No looping is needed, PROC RANK supports the use of a BY statement, so you can run PROC RANK once on all 32 products.

Example: https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.4/proc/p12aek9f6xhl1zn1puuuot19wqi7.htm

Re: Using output for IF Statement

DavidLie — Mon, 17 May 2021 13:10:05 GMT

Thanks 🙂 It works.