topic Re: Indicating change in a variable across a year in SAS Programming

Indicating change in a variable across a year

ChuksManuel — Sat, 17 Jun 2023 13:50:22 GMT

Hi programmers,

I have a variable assessed in two points (longitudinal data): 2019 survey, FS (coded as 0,1). 2020 survey, FS (coded as 0,1).

I want to create a change variable such that;

An observation with 0 in 2019 who is still 0 in 2020= variable A

An observation with 0 in 2019 who becomes 1 in 2020=variable B

An observation with 1 in 2019 who becomes 0 in 2020= variable C

An observation with 1 in 2019 who is still 1 in 2020=variable D

Is there a way I can code this? Do I need to create a flag variable in both years?

Kurt_Bremser — Sat, 17 Jun 2023 14:48:22 GMT

Please post a example for your data in a DATA step with DATALINES, so structure and content become more clear.

ChuksManuel — Sat, 17 Jun 2023 14:55:08 GMT

Figured it out. Thanks