topic pull min days in SAS Programming

pull min days

Ranjeeta — Fri, 06 Mar 2020 19:33:28 GMT

Proc sql;
Create table pts60D1 as
Select * , Min(days_to_servdate) as HC_first
From pts60D 
Group by key_enc
Having min(days_to_servdate)
;quit;

I have one question how would I add a condition to select the min date after ignoring the negative values

Re: pull min days

PaigeMiller — Fri, 06 Mar 2020 19:42:25 GMT

@Ranjeeta wrote:

I have one question how would I add a condition to select the min date after ignoring the negative values

I don't see a variable named date.

Where would the negative values be (what variable)?

Re: pull min days

Ranjeeta — Fri, 06 Mar 2020 19:43:30 GMT

it is days toservdate

Re: pull min days

PaigeMiller — Fri, 06 Mar 2020 19:48:57 GMT

Proc sql;
Create table pts60D1 as
Select * , Min(days_to_servdate) as HC_first
From pts60D(where=(days_to_servdate>=0))
Group by key_enc
Having days_to_servdate=min(days_to_servdate)
;quit;