"Closest" match in EGuide

Doc_Duke — Mon, 21 Feb 2011 19:24:13 GMT

I know what I want to do, but can't figure out how to do it in the point-and-click part of EGuide.

I have hospital encounters and the all labs done (ever). I want the labs that were done closest to the admission of interest. It is, to me, a simple application of the HAVING operator in SQL, but I cant figure out how to get EGuide to do it. I don't want to create a code template because my students don't know how to write code. "t1" is the demographics+Encounter info and "t2" is the lab set.

EGuide gets me this far:
PROC SQL;
CREATE TABLE WORK.QUERY_FOR_DEMENC AS
SELECT t1.PID,
t2.EID,
t1.Ethnicity,
t1.Gender,
t1.Race,
t1.Age,
t1.EBegin,
t1.EEnd,
t2.LabDate,
t2.LabDateTime
t2.TestCodeDescription,
t2.NumericResult,
t2.'Unit of Measure'n,
t2.AbnormalFlag
FROM DEDUCE.DEMENC t1 LEFT JOIN DEDUCE.LABS t2 ON (t1.PID = t2.PID)
GROUP BY t1.PID, t2.EID, t2.TestCodeDescription ;

I want to add
HAVING t2.LabDateTime = MIN(t2.LabDateTime)
at the end.

Is that functionality there and I just can't see it, or is a "feature" for future development? Any workaround ideas?

Thanks,
Doc

Re: "Closest" match in EGuide

DerekAdams — Tue, 22 Feb 2011 01:59:25 GMT

Hi

You can use the the bottom box, "Filter the summarized data", on the filter tab to create your having clauses

Re: "Closest" match in EGuide

Doc_Duke — Tue, 22 Feb 2011 15:16:18 GMT

Bingo. thanks.

topic "Closest" match in EGuide in SAS Enterprise Guide

"Closest" match in EGuide

Re: "Closest" match in EGuide

Re: "Closest" match in EGuide