| Date: | Tue, 25 Nov 2008 15:32:09 -0500 |
|---|
| Reply-To: | Akshaya Nathilvar <akshaya.nathilvar@GMAIL.COM> |
|---|
| Sender: | "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU> |
|---|
| From: | Akshaya Nathilvar <akshaya.nathilvar@GMAIL.COM> |
|---|
| Subject: | Re: SAS question |
|---|
|
| In-Reply-To: | <fa56d93d-69c3-44ff-a3ff-96660640e14f@g38g2000yqd.googlegroups.com> |
|---|
| Content-Type: | text/plain; charset=ISO-8859-1 |
|---|
Proc sql feedback;
select *
from have
group by id, start_dt
having count(*)>1
order by id,prod,start_dt;
Quit;
Akshaya
On Tue, Nov 25, 2008 at 3:06 PM, <pprabhudesai@gmail.com> wrote:
> I have data as follows:
>
> Data one;
> input id prod event start_dt mmddyy10.;
> cards;
> 12 XYZ LL 10/11/2008
> 12 LMN RT 11/02/2008
> 12 XYZ PL 11/02/2008
> 15 ABC RT 09/12/2008
> 15 ABC PL 09/18/2008
> 16 LMN LL 11/04/2008
> 16 XYZ LL 11/04/2008
> 16 ABC RT 11/04/2008
>
>
> I want to find which ID have on the same day 2 or more events with
> same prod or with different prod:
>
> So my output from the above example should look like:
>
> id prod event start dt
>
> 12 LMN RT 11/02/2008
> 12 XYZ PL 11/02/2008
> 16 LMN LL 11/04/2008
> 16 XYZ LL 11/04/2008
> 16 ABC RT 11/04/2008
>
> I would appreciate any help in this.
>
|
