| Date: | Mon, 23 Jun 2003 13:21:59 -0400 |
|---|
| Reply-To: | "Cacialli, Doug" <Doug_Cacialli@URMC.ROCHESTER.EDU> |
|---|
| Sender: | "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU> |
|---|
| From: | "Cacialli, Doug" <Doug_Cacialli@URMC.ROCHESTER.EDU> |
|---|
| Subject: | Re: first and last |
|---|
|
| Content-Type: | text/plain |
|---|
Try something like this (untested):
DATA DAT1;
SET DAT;
BY COLDATE;
FORMAT VAR1 VAR2 MMDDYY10.;
IF (FIRST.COLDATE = 1)
THEN VAR1 = COLDATE;
IF (LAST.COLDATE = 1)
THEN VAR2 = COLDATE;
PUT COLDATE VAR1 VAR2;
RUN;
-----Original Message-----
From: miranda [mailto:mixiao@UCLA.EDU]
Sent: Monday, June 23, 2003 1:05 PM
To: SAS-L@LISTSERV.UGA.EDU
Subject: first and last
Hi All,
I have a simple data step like below, I'd like report the
first.coldate and
last.coldate, I'm a little bit confusion here why the put statement
give me the result like this?
119 data dat1;
120 set dat;
121 by coldate;
122 format var1 var2 mmddyy10.;
123 var1=first.coldate;
124 var2=last.coldate;
125 put coldate var1 var2;
126 run;
04/24/2002 01/02/1960 01/02/1960
05/10/2002 01/02/1960 01/02/1960
05/17/2002 01/02/1960 01/01/1960
05/17/2002 01/01/1960 01/02/1960
05/29/2002 01/02/1960 01/02/1960
06/05/2002 01/02/1960 01/02/1960
How could I get var1=04/24/2002
var2=06/05/2002 ?
Thanks.
| 
