topic Re: How to get a first occurrence in a query in SAS Enterprise Guide

How to get a first occurrence in a query

deleted_user — Mon, 14 May 2007 18:50:24 GMT

In a sotred process being coded in EG, is there a way, in a query, to obtain the first occurrence of a data field? Something like the following pseudocode....

Create table suchandsuch;
first requestedfield
fieldb
fieldc
first fieldd
quit;
run;

In short, say I have 10 occurrences of a record (no, not duplicates) for Joe Schmoe, but I only want to gather info for the first occurrence. I know how to do this in MS Access queries, but haven't seen anything about it for stored processes.

Thanks in advance!!

Re: How to get a first occurrence in a query

Victor — Tue, 15 May 2007 13:46:21 GMT

Hello

I will try to answer as match as i understand the question:

You have a task in the data menu called "Sort the data". You wil sort the data by the name for example and the "Options" folder, in the "double record" you will indicate "Keep only the first record for each group"

You can also use, if you want to, the PROC SQL with GROUP BY option.

NB: I translate phrases from french because i have the french version of Guide. So may be the indications will not be exactly the same.

Regards

Re: How to get a first occurrence in a query

deleted_user — Wed, 16 May 2007 15:45:17 GMT

Thank you, Victor,

I will use your most welcome suggestions.