Date:         Fri, 11 Apr 2008 23:20:15 -0400
Reply-To:     Arthur Tabachneck <art297@NETSCAPE.NET>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Arthur Tabachneck <art297@NETSCAPE.NET>
Subject:      Re: Constructing Variable

Randy,

Are you only looking to do something like:

data have;
  input ID $   Date $  VarA        Var2;
  cards;
A    Jan1            500           5.5
A    Jan2            500           6.75
A    Jan3            500           2.49
B    Jan1            750           11
B    Jan2            750           12.75
B    Jan3            750           13
;

data want;
  set have;
  by id;
  retain first_var2;
  if first.id then first_var2=var2;
  var3=varA*first_var2;
run;

proc print data=want;
run;

HTH,
Art
-----------
On Fri, 11 Apr 2008 21:59:11 -0400, Randy <randistan69@HOTMAIL.COM> wrote:

>Dear All:
>  Here is my Data
>
>ID   Date           VarA         Var2
>A    Jan1            500           5.5
>A    Jan2            500           6.75
>A    Jan3            500           2.49
>B    Jan1            750           11
>B    Jan2            750           12.75
>B    Jan3            750           13
>
>I want to construct Var3 which is equal to VarA*the first value for each
>ID of Var2.  So for Jan 1 ID A Var3 = 500*5.5.  So my completed data looks
>like this
>
>ID   Date           VarA         Var2          Var3
>A    Jan1            500           5.5          2750
>A    Jan2            500           6.75         2750
>A    Jan3            500           2.49         2750
>B    Jan1            750           11           8250
>B    Jan2            750           12.75        8250
>B    Jan3            750           13           8250
>
>     Please Help
>                            Randy