SAS code Question!
in [SAS]
|
Prev: software engineering
Next: font question
From: Fernández RodrÃguez, on 6 Nov 2009 09:47 Yeah! The code look like this: Proc sql noprint; Select distinct SAS_L.posts From Google Where google.posts=SAS_L.posts; Quit; Daniel -----Mensaje original----- De: SAS(r) Discussion [mailto:SAS-L(a)LISTSERV.UGA.EDU] En nombre de Arthur Tabachneck Enviado el: divendres, 6 / novembre / 2009 15:45 Para: SAS-L(a)LISTSERV.UGA.EDU Asunto: Re: SAS code Question! Gerhard, I don't think this was a double post but, rather, one of the effects of the delayed appearance of Google posts. Art ------- On Fri, 6 Nov 2009 09:40:36 -0500, Gerhard Hellriegel <gerhard.hellriegel(a)T-ONLINE.DE> wrote: >there are already several answers to that. Please follow the original >thread and do not post the same thing twice! > >Gerhard > > > > >On Thu, 5 Nov 2009 17:40:58 -0800, tianrui sun <tianruisun(a)GMAIL.COM> >wrote: > >>Hello , Anyone can help? >> >>I have a question about one sas coding problem. Currently, have a data >>with 4 attributes, year, type, C and rate. I want to use PROC SQL to >>find out the smallest 2 rate in type group for each year. >> >>For instance, there have a data set like this. >>year type, C, rate. >>1998 A ms 10 >>1998 A mt 30 >>1998 B ml 40 >>1998 B mu 50 >>1998 B mu 60 >>1998 C ms 70 >>1998 C md 80 >>1997 A md 500 >>1997 A md 600 >>1997 A sp 700 >>1997 B sf 800 >>1997 B sd 100 >>1997 C sc 200 >>1997 D sf 300 >>1997 D sr 400 >> >> >>in 1998 type A I want the smallest 2 rate rows also in 1998 type B I >>want the smallest 2 rate rows also in 1997 type A I want the smallest >>2 rate as well. >> >>the result like below: >>Year type C rate >>1998 A ms 10 >>1998 A mf 20 >>1998 B ml 40 >>1998 B mu 50 >>1998 C ms 70 >>1998 C md 80 >>1997 A md 500 >>1997 A md 600 >>1997 B sf 100 >>1997 B sd 800 >>1997 C sc 200 >>1997 D sf 300 >>1997 D sr 400 >> >>How can I do it in SAS code? |