LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (November 1999, week 3)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Fri, 19 Nov 1999 14:56:45 -0600
Reply-To:     "Lambert, Bob" <Bob_Lambert@AFCC.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Lambert, Bob" <Bob_Lambert@AFCC.COM>
Subject:      FW: Re[2]: Simple problem - but urgent...
Content-Type: multipart/alternative;


I guess it should have been obvious.  It was to Ian Whitlock (and probably
to a bunch of others).


Thanx Ian.


BL
> -----Original Message-----
> From: WHITLOI1@westat.com [SMTP:WHITLOI1@westat.com]
> Sent: Friday, November 19, 1999 11:38 AM
> To:   Lambert, Bob
> Subject:      Re[2]: Simple problem - but urgent...
>
> Bob,
>
> Small point.  But
>
>      else newvar = newvar ;
>
> can never be needed, with or without a RETAIN statement.
>
> Ian Whitlock <whitloi1@westat.com>
>
> ____________________Reply Separator____________________
> Subject:    Re: Simple problem - but urgent...
> Author: "Lambert; Bob" <Bob_Lambert@AFCC.COM>
> Date:       11/19/1999 11:48 AM
>
>         Perhaps a minor point, but the "else newvar=newvar;" line is not
> needed because of the retain statement.
>
> e.g.:
>
> data squirrel;
> input NUMVAR;
> lines;
> 5
> 10
> .
> .
> 15
> 14
> .
> 12
> run;
>
> data mouse;
>   set squirrel;
>     retain NEWVAR;
>    if NUMVAR then NEWVAR=NUMVAR;
> run;
>
> proc print data=mouse;
> run;
>
> > -----Original Message-----
> > From: diltilia@MY-DEJA.COM [SMTP:diltilia@MY-DEJA.COM]
> > Sent: Friday, November 19, 1999 8:57 AM
> > To:   SAS-L@LISTSERV.UGA.EDU
> > Subject:      Re: Simple problem - but urgent...
> >
> > Drazen,
> >
> > Try this:
> > data x;
> >  set x;
> > retain newvar ;
> >  if numvar ne . then newvar=numvar;
> >  else newvar=newvar;
> > run;
> >
> > OUTPUT:
> >                                     OBS    NUMVAR    NEWVAR
> >
> >                                       1        5         5
> >                                       2       10        10
> >                                       3        .        10
> >                                       4        .        10
> >                                       5       15        15
> >                                       6       14        14
> >                                       7        .        14
> >                                       8       12        12
> >
> >
> > In article <813iso$1d5$1@as102.tel.hr>,
> >   "Drazen Orescanin" <drazen.orescanin@kaptol.hr> wrote:
> > > Dear friends
> > >
> > > I have a table like this:
> > >
> > > OBS    NUMVAR
> > > 1            5
> > > 2            10
> > > 3            .
> > > 4            .
> > > 5            15
> > > 6            14
> > > 7            .
> > > 8            12
> > >
> > > I want to have a table like this:
> > >
> > > OBS    NUMVAR
> > > 1            5
> > > 2            10
> > > 3            10
> > > 4            10
> > > 5            15
> > > 6            14
> > > 7            14
> > > 8            12
> > >
> > > In other words, I want to retain the value of  NUMVAR only if NUMVAR
> > is
> > > missing. Is there any simple solution to this problem?
> > >
> > > Thanks
> > >
> > > Drazen from Croatia
> > >
> > > --
> > > I'm in favor of love as long as it doesn't happen when football is on
> > > television...
> > >
> > >
> >
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
>
> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
> <HTML>
> <HEAD>
> <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
> <META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2448.0">
> <TITLE>RE: Simple problem - but urgent...</TITLE>
> </HEAD>
> <BODY>
> <UL>
> <P><FONT SIZE=2 FACE="Arial">Perhaps a minor point, but the
> &quot;</FONT><FONT
> SIZE=2 FACE="Arial">else newvar=newvar;&quot; line is not needed because
> of the
> retain statement.</FONT>
> </P>
> </UL>
> <P><FONT SIZE=2 FACE="Arial">e.g.:</FONT>
> </P>
>
> <P><FONT SIZE=2 FACE="Sasfont">data squirrel;</FONT>
> <BR><FONT SIZE=2 FACE="Sasfont">input NUMVAR;</FONT>
> <BR><FONT SIZE=2 FACE="Sasfont">lines;</FONT>
> <BR><FONT SIZE=2 FACE="Sasfont">5</FONT>
> <BR><FONT SIZE=2 FACE="Sasfont">10</FONT>
> <BR><FONT SIZE=2 FACE="Sasfont">.</FONT>
> <BR><FONT SIZE=2 FACE="Sasfont">.</FONT>
> <BR><FONT SIZE=2 FACE="Sasfont">15</FONT>
> <BR><FONT SIZE=2 FACE="Sasfont">14</FONT>
> <BR><FONT SIZE=2 FACE="Sasfont">.</FONT>
> <BR><FONT SIZE=2 FACE="Sasfont">12</FONT>
> <BR><FONT SIZE=2 FACE="Sasfont">run;</FONT>
> </P>
>
> <P><FONT SIZE=2 FACE="Sasfont">data mouse;</FONT>
> <BR><FONT SIZE=2 FACE="Sasfont">&nbsp; set squirrel;</FONT>
> <BR><FONT SIZE=2 FACE="Sasfont">&nbsp;&nbsp;&nbsp; retain NEWVAR;</FONT>
> <BR><FONT SIZE=2 FACE="Sasfont">&nbsp;&nbsp; if NUMVAR then
> NEWVAR=NUMVAR;</FONT>
> <BR><FONT SIZE=2 FACE="Sasfont">run;</FONT>
> </P>
>
> <P><FONT SIZE=2 FACE="Sasfont">proc print data=mouse;</FONT>
> <BR><FONT SIZE=2 FACE="Sasfont">run;</FONT>
> </P>
> <UL>
> <P><FONT SIZE=1 FACE="Arial">-----Original Message-----</FONT>
> <BR><B><FONT SIZE=1 FACE="Arial">From:&nbsp;&nbsp;</FONT></B> <FONT SIZE=1
> FACE="Arial">diltilia@MY-DEJA.COM [SMTP:diltilia@MY-DEJA.COM]</FONT>
> <BR><B><FONT SIZE=1 FACE="Arial">Sent:&nbsp;&nbsp;</FONT></B> <FONT SIZE=1
> FACE="Arial">Friday, November 19, 1999 8:57 AM</FONT>
> <BR><B><FONT SIZE=1 FACE="Arial">To:&nbsp;&nbsp;&nbsp;&nbsp;</FONT></B>
> <FONT
> SIZE=1 FACE="Arial">SAS-L@LISTSERV.UGA.EDU</FONT>
> <BR><B><FONT SIZE=1
> FACE="Arial">Subject:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</FONT></B>
> <FONT
> SIZE=1 FACE="Arial">Re: Simple problem - but urgent...</FONT>
> </P>
>
> <P><FONT SIZE=2 FACE="Arial">Drazen,</FONT>
> </P>
>
> <P><FONT SIZE=2 FACE="Arial">Try this:</FONT>
> <BR><FONT SIZE=2 FACE="Arial">data x;</FONT>
> <BR><FONT SIZE=2 FACE="Arial">&nbsp;set x;</FONT>
> <BR><FONT SIZE=2 FACE="Arial">retain newvar ;</FONT>
> <BR><FONT SIZE=2 FACE="Arial">&nbsp;if numvar ne . then
> newvar=numvar;</FONT>
> <BR><FONT SIZE=2 FACE="Arial">&nbsp;else newvar=newvar;</FONT>
> <BR><FONT SIZE=2 FACE="Arial">run;</FONT>
> </P>
>
> <P><FONT SIZE=2 FACE="Arial">OUTPUT:</FONT>
> <BR><FONT SIZE=2
> FACE="Arial">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&
> nbsp;&
> nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb
> sp;&nb
> sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
> OBS&nbsp;&nbsp;&nbsp; NUMVAR&nbsp;&nbsp;&nbsp; NEWVAR</FONT>
> </P>
>
> <P><FONT SIZE=2
> FACE="Arial">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&
> nbsp;&
> nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb
> sp;&nb
> sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp
> ;
> 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
> 5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5</FONT>
> <BR><FONT SIZE=2
> FACE="Arial">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&
> nbsp;&
> nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb
> sp;&nb
> sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp
> ;
> 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
> 10&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10</FONT>
> <BR><FONT SIZE=2
> FACE="Arial">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&
> nbsp;&
> nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb
> sp;&nb
> sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp
> ;
> 3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
> .&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10</FONT>
> <BR><FONT SIZE=2
> FACE="Arial">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&
> nbsp;&
> nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb
> sp;&nb
> sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp
> ;
> 4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
> .&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10</FONT>
> <BR><FONT SIZE=2
> FACE="Arial">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&
> nbsp;&
> nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb
> sp;&nb
> sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp
> ;
> 5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
> 15&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 15</FONT>
> <BR><FONT SIZE=2
> FACE="Arial">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&
> nbsp;&
> nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb
> sp;&nb
> sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp
> ;
> 6&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
> 14&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 14</FONT>
> <BR><FONT SIZE=2
> FACE="Arial">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&
> nbsp;&
> nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb
> sp;&nb
> sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp
> ;
> 7&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
> .&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 14</FONT>
> <BR><FONT SIZE=2
> FACE="Arial">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&
> nbsp;&
> nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb
> sp;&nb
> sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp
> ;
> 8&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
> 12&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 12</FONT>
> </P>
> <BR>
>
> <P><FONT SIZE=2 FACE="Arial">In article
> &lt;813iso$1d5$1@as102.tel.hr&gt;,</FONT>
> <BR><FONT SIZE=2 FACE="Arial">&nbsp; &quot;Drazen Orescanin&quot;
> &lt;drazen.orescanin@kaptol.hr&gt; wrote:</FONT>
> <BR><FONT SIZE=2 FACE="Arial">&gt; Dear friends</FONT>
> <BR><FONT SIZE=2 FACE="Arial">&gt;</FONT>
> <BR><FONT SIZE=2 FACE="Arial">&gt; I have a table like this:</FONT>
> <BR><FONT SIZE=2 FACE="Arial">&gt;</FONT>
> <BR><FONT SIZE=2 FACE="Arial">&gt; OBS&nbsp;&nbsp;&nbsp; NUMVAR</FONT>
> <BR><FONT SIZE=2 FACE="Arial">&gt;
> 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
> 5</FONT>
> <BR><FONT SIZE=2 FACE="Arial">&gt;
> 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
> 10</FONT>
> <BR><FONT SIZE=2 FACE="Arial">&gt;
> 3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
> .</FONT>
> <BR><FONT SIZE=2 FACE="Arial">&gt;
> 4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
> .</FONT>
> <BR><FONT SIZE=2 FACE="Arial">&gt;
> 5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
> 15</FONT>
> <BR><FONT SIZE=2 FACE="Arial">&gt;
> 6&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
> 14</FONT>
> <BR><FONT SIZE=2 FACE="Arial">&gt;
> 7&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
> .</FONT>
> <BR><FONT SIZE=2 FACE="Arial">&gt;
> 8&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
> 12</FONT>
> <BR><FONT SIZE=2 FACE="Arial">&gt;</FONT>
> <BR><FONT SIZE=2 FACE="Arial">&gt; I want to have a table like
> this:</FONT>
> <BR><FONT SIZE=2 FACE="Arial">&gt;</FONT>
> <BR><FONT SIZE=2 FACE="Arial">&gt; OBS&nbsp;&nbsp;&nbsp; NUMVAR</FONT>
> <BR><FONT SIZE=2 FACE="Arial">&gt;
> 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
> 5</FONT>
> <BR><FONT SIZE=2 FACE="Arial">&gt;
> 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
> 10</FONT>
> <BR><FONT SIZE=2 FACE="Arial">&gt;
> 3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
> 10</FONT>
> <BR><FONT SIZE=2 FACE="Arial">&gt;
> 4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
> 10</FONT>
> <BR><FONT SIZE=2 FACE="Arial">&gt;
> 5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
> 15</FONT>
> <BR><FONT SIZE=2 FACE="Arial">&gt;
> 6&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
> 14</FONT>
> <BR><FONT SIZE=2 FACE="Arial">&gt;
> 7&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
> 14</FONT>
> <BR><FONT SIZE=2 FACE="Arial">&gt;
> 8&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
> 12</FONT>
> <BR><FONT SIZE=2 FACE="Arial">&gt;</FONT>
> <BR><FONT SIZE=2 FACE="Arial">&gt; In other words, I want to retain the
> value
> of&nbsp; NUMVAR only if NUMVAR</FONT>
> <BR><FONT SIZE=2 FACE="Arial">is</FONT>
> <BR><FONT SIZE=2 FACE="Arial">&gt; missing. Is there any simple solution
> to this
> problem?</FONT>
> <BR><FONT SIZE=2 FACE="Arial">&gt;</FONT>
> <BR><FONT SIZE=2 FACE="Arial">&gt; Thanks</FONT>
> <BR><FONT SIZE=2 FACE="Arial">&gt;</FONT>
> <BR><FONT SIZE=2 FACE="Arial">&gt; Drazen from Croatia</FONT>
> <BR><FONT SIZE=2 FACE="Arial">&gt;</FONT>
> <BR><FONT SIZE=2 FACE="Arial">&gt; --</FONT>
> <BR><FONT SIZE=2 FACE="Arial">&gt; I'm in favor of love as long as it
> doesn't
> happen when football is on</FONT>
> <BR><FONT SIZE=2 FACE="Arial">&gt; television...</FONT>
> <BR><FONT SIZE=2 FACE="Arial">&gt;</FONT>
> <BR><FONT SIZE=2 FACE="Arial">&gt;</FONT>
> </P>
> <BR>
>
> <P><FONT SIZE=2 FACE="Arial">Sent via Deja.com</FONT><U> <FONT
> COLOR="#0000FF"
> SIZE=2 FACE="Arial"><A HREF="http://www.deja.com/"
> TARGET="_blank">http://www.deja.com/</A></FONT></U>
> <BR><FONT SIZE=2 FACE="Arial">Before you buy.</FONT>
> </P>
> </UL>
> </BODY>
> </HTML>



[text/html]
Back to: Top of message | Previous page | Main SAS-L page
listserv.uga.edu
Enterprise Information Technology Services
The University of Georgia
listhelp@uga.edu