topic Deleting records by id based on condition in SAS Programming

Deleting records by id based on condition

ddavies — Thu, 13 Feb 2020 17:58:04 GMT

I tried searching a few different things about deleting records but must not have been clear on what I was wanting to do because I couldn't find what I was looking for.

I have a data set that has client id, assessment, date, and scores by question

assessment either has a value of first or last

For each client_id they either have a first OR a first and a last

I want my final dataset to only include clients who had both a first and a last assessment.

HAVE and WANT example data attached.

Thanks!

Re: Deleting records by id based on condition

utrocketeng — Thu, 13 Feb 2020 18:05:29 GMT

PROC SQL;

CREATE TABLE work.WANT AS

SELECT b.*

FROM

(SELECT client_id FROM work.HAVE WHERE assessment = 'LAST') a

INNER JOIN work.HAVE b on a.client_ID = b.client_ID

;

QUIT;

Re: Deleting records by id based on condition

ddavies — Thu, 13 Feb 2020 18:16:52 GMT

Thanks so much!

Re: Deleting records by id based on condition

utrocketeng — Thu, 13 Feb 2020 18:17:10 GMT

glad to help out!