topic how to retain values per group in SAS Programming

how to retain values per group

HitmonTran — Thu, 06 Jan 2022 04:15:05 GMT

Hi,

I have a dataset with variables:

"group_1" , "group_2", "group_3", "group_4", "value"

I want to create a new variable, "order_seq", which takes the first value from variable "value" and retain that value to the next "group 1"

example data:

group_1	group_2	group_3	group_4	value	order_seq
red			red	100	100
red	dark		dark	50	100
red	dark	shoe	shoe	25	100
blue			blue	88	88
blue	light		light	33	88
blue	light	socks	socks	22	88
green			green	99	99
green	dark		dark	77	99
green	dark	pants	pants	65	99

Re: how to retain values per group

Reeza — Thu, 06 Jan 2022 04:17:18 GMT

data want;
set have;

by group1;
retain order_seq;

if first.group_1 then order_seq = value;

run;

@HitmonTran wrote:

Hi,

I have a dataset with variables:

"group_1" , "group_2", "group_3", "group_4", "value"

I want to create a new variable, "order_seq", which takes the first value from variable "value" and retain that value to the next "group 1"

example data:

group_1 group_2 group_3 group_4 value order_seq

red
red 100 100

red dark dark 50 100

red dark shoe shoe 25 100

blue blue 88 88

blue light light 33 88

blue light socks socks 22 88

green green 99 99

green dark dark 77 99

green dark pants pants 65 99
 

Re: how to retain values per group

andreas_lds — Thu, 06 Jan 2022 05:48:30 GMT

The code provided by @Reeza works fine, if the data is sorted by group1. So you have to either sort it before the data step or add the option "notsorted" (without quotes) to the BY statement. To work as expected, the data needs to be grouped by group1.