Date: Tue, 2 Sep 2008 16:12:31 +0200
Reply-To: yom <yomsas@GMAIL.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: yom <yomsas@GMAIL.COM>
Subject: Re: Create a new variable
In-Reply-To: <200809012235.m81AlQYP005459@malibu.cc.uga.edu>
Content-Type: text/plain; charset=ISO-8859-1
Thank you very much for your help. It is working very well !
Yom
2008/9/2, Arthur Tabachneck <art297@netscape.net>:
>
> Howard,
>
> Very nice! As I have never used the notsorted option, I had to look it
> up. While perusing the docs for what notsorted does, I also noticed
> another option I have never used: groupformat.
>
> I wonder how often it could be used to simplify solutions.
>
> Art
> -------
> On Mon, 1 Sep 2008 17:50:43 -0400, Howard Schreier <hs AT dc-sug DOT org>
> <schreier.junk.mail@GMAIL.COM> wrote:
>
> >On Mon, 1 Sep 2008 09:10:19 -0400, Arthur Tabachneck <art297@NETSCAPE.NET
> >
> >wrote:
> >
> >>Yom,
> >>
> >>You have one additional record in your example desired output but, if
> that
> >>was just an oversight, the following might accomplish the task:
> >>
> >>data want;
> >> set have;
> >> retain changed last_var2;
> >> by var0;
> >> if first.var0 then do;
> >> var3=1;
> >> changed=0;
> >> last_var2=var2;
> >> end;
> >> else if not(changed) then do;
> >> if var2 eq last_var2 then var3=1;
> >> else do;
> >> changed=1;
> >> var3=0;
> >> end;
> >> end;
> >> else var3=0;
> >>run;
> >>proc print data=want;
> >>run;
> >>
> >>HTH,
> >>Art
> >
> >Or
> >
> > data want;
> > set have;
> > by var0 var2 notsorted;
> > retain var3;
> > if first.var0 then var3 = 1;
> > else if first.var2 then var3 = 0;
> > run;
> >
> >>---------
> >>On Mon, 1 Sep 2008 10:27:55 +0200, yom <yomsas@GMAIL.COM> wrote:
> >>
> >>>Dear all,
> >>>
> >>>I would like to create a new variable in a table according some
> >>conditions.
> >>>The table is sorted by var0 and var1.
> >>>For each new first value of var0, i give the value 1 to the variable
> var3.
> >>>If var2 keep its first value many times, we have var3 = 1 for each one.
> >>And
> >>>as soon as var2 has a new value, we have var3 = 0 for the other
> >>observations
> >>>for which var0 has the same value.
> >>>
> >>>With the example below, for the first observation for wich var0 = 1, we
> >>can
> >>>see that var2=4. Since this value occurs three times in a row, we have
> >>>var3=1 for the three first observations and var3=0 for the others (even
> if
> >>>var2=4 at the seventh observation).
> >>>And, i do the same for the first observation for wich var0 = 2.
> >>>
> >>>It is not easy to explain. I hope that the example below will be useful.
> >>>
> >>>var0 var1 var2
> >>> 1 2 4
> >>> 1 3 4
> >>> 1 4 4
> >>> 1 5 1
> >>> 1 6 6
> >>> 1 7 4
> >>> 1 8 7
> >>> 2 1 3
> >>> 2 2 3
> >>> 2 3 2
> >>> 2 4 9
> >>> 2 5 8
> >>> 2 6 3
> >>> 2 7 2
> >>> 3 3 7
> >>> 3 4 7
> >>> 3 5 7
> >>> 3 6 3
> >>> 3 7 1
> >>> 3 8 7
> >>> 3 9 7
> >>>
> >>>I would like to create the variable var3 according to :
> >>>
> >>>var0 var1 var2 var3
> >>> 1 2 4 1
> >>> 1 3 4 1
> >>> 1 4 4 1
> >>> 1 5 1 0
> >>> 1 6 6 0
> >>> 1 7 4 0
> >>> 1 8 7 0
> >>> 2 1 3 1
> >>> 2 2 3 1
> >>> 2 3 2 0
> >>> 2 4 9 0
> >>> 2 5 8 0
> >>> 2 6 3 0
> >>> 2 7 2 0
> >>> 3 3 7 1
> >>> 3 4 7 1
> >>> 3 5 7 1
> >>> 3 6 3 0
> >>> 3 7 1 0
> >>> 3 8 7 0
> >>> 3 9 7 0
> >>> 3 10 2 0
> >>>
> >>>
> >>>Thank you very much in advance for your answers.
> >>>
> >>>Yom
>
| 
