Desktop productivity for business analysts and programmers

How to get a first occurrence in a query

Reply
N/A
Posts: 0

How to get a first occurrence in a query

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!!
Contributor
Posts: 36

Re: How to get a first occurrence in a query

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
N/A
Posts: 0

Re: How to get a first occurrence in a query

Thank you, Victor,

I will use your most welcome suggestions.
Ask a Question
Discussion stats
  • 2 replies
  • 287 views
  • 0 likes
  • 2 in conversation