topic Re: if statement in SAS Programming

if statement

radhikaa4 — Fri, 13 Dec 2019 17:22:43 GMT

Currently I have this table below:

Basically if status and status1 are not blank then I want the final site_status = "Recruiting"

if status1 is blank then i want the final status to be site_status = "Not recruiting"

and I want to delete all the duplicates

i can get the if statement to work but i do not want to create more additional datasets. want to delete in one step

PaigeMiller — Fri, 13 Dec 2019 17:28:24 GMT

Duplicates? I don't see any.

Reeza — Fri, 13 Dec 2019 17:29:41 GMT

Show what you have as input, what you want as output and what you've tried please. Its the fastest way to get an answer.