BookmarkSubscribeRSS Feed
hjjijkkl
Pyrite | Level 9

I have a big data with 100+ variables and I want to keep records depending on the "Incident" variable. For example, I want to keep records only were the incident variable during (week0) is not missing "test and/or "date" variable. But, If the incident variable is missing "test" and "date" values during (week0) then I want to replace (or keep)  the "1_week0" value in place of the week0. Please look the table below as an example and the outcome.

ID

Incident

test

date

Result

1

Week0

34

2/2/2021

90

1

1_week0

40

3/4/2021

56

2

Week0

.

.

100

2

1_week0

84

5/12/2021

34

2

Week1

50

5/23/2021

67

3

Week0

43

3/8/2021

98

3

1_week0

10

4/21/2021

80

3

Week1

23

5/1/2021

45

4

week0

.

.

76

4

1_week0

64

3/7/2021

78

This is how I would want the outcome to look like 

ID

Incident

test

date

Result

1

Week0

34

2/2/2021

90

2

1_week0

84

5/12/2021

34

3

Week0

43

3/8/2021

98

4

1_week0

64

3/7/2021

78

2 REPLIES 2
PaigeMiller
Diamond | Level 26

Please provide a portion of your data in a usable form, according to these instructions: https://blogs.sas.com/content/sastraining/2016/03/11/jedi-sas-tricks-data-to-data-step-macro/

--
Paige Miller
Reeza
Super User
data want;
set have;
where not missing(test);
by ID;
if first.ID;
run;

Ready to join fellow brilliant minds for the SAS Hackathon?

Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.

Register today!
Mastering the WHERE Clause in PROC SQL

SAS' Charu Shankar shares her PROC SQL expertise by showing you how to master the WHERE clause using real winter weather data.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 2 replies
  • 602 views
  • 0 likes
  • 3 in conversation