topic Re: Tip for sas code in SAS Programming

Tip for sas code

Lordy — Mon, 23 Jan 2017 21:30:23 GMT

I have a dataset with the following columns: dates, client name, jail record, jail facility name

I need to query the data in base sas as follow:

If a client has a jail record and there is a previous jail record within 30 days where the jail facility was different then i want to code it as an event for each client.

Any ideas how to do that please!

Re: Tip for sas code

Astounding — Mon, 23 Jan 2017 22:24:31 GMT

Here's a reasonable approach:

proc sort data=have;

by client date;

run;

data want;

set have;

by client;

days_lapsed = dif(date);

prior_facility = lag(facility);

if first.client=0 and days_lapsed < 30 and facility = prior_facility then event='Y';

drop days_lapsed prior_facility;

run;

This assumes that your date variable is actually a SAS date, not a character string.

Re: Tip for sas code

Kurt_Bremser — Mon, 23 Jan 2017 22:25:03 GMT

Sort by client name and date. Then you can use the lag() function to compare variables with values from the preceding observation.

Re: Tip for sas code

ballardw — Mon, 23 Jan 2017 22:39:23 GMT

Do you have some id such as SSN? Note that people involved in jail often have a good reason to hide their real identity and multiple arrests and/or convictions and a simple name match is likely to be insufficient. Also is Rob Smith the same as Robert Smith or Bob Smith?

Re: Tip for sas code

Lordy — Tue, 24 Jan 2017 19:28:51 GMT

Thanks - I will use this approach.