pull min days

[Ranjeeta]

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 

[PaigeMiller · Accepted solution]

---

@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)?

[Ranjeeta]

it is days toservdate

[PaigeMiller]

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;