I'LL BET 10-1 GREG'S A MAINFRAMER - WE ALL TYPE IN CAPS.
DDS DATA EXTRACTION
From: Jack Hamilton [mailto:JackHamilton@FIRSTHEALTH.COM]
Sent: Thursday, January 08, 2004 10:10 AM
Subject: Re: Working with dates
I'm curious why you code in all upper case. There are advantages to all
lower case (easier to type and read) and mixed case (easier to read; can
make keywords, and lexemes in variable names, stand out). But what's
the advantage of all upper case?
Manager, Technical Development
Metrics Department, First Health
West Sacramento, California USA
>>> "Greg Woolridge" <greg.woolridge@TAP.COM> 01/08/2004 6:55 AM >>>
Here is one untested solution.
BY PT BEGIN;
IF FIRST.PT THEN FLAG=0;
IF FLAG=1 THEN DELETE;
IF END='300CT2003'D THEN FLAG=1;
Greg M. Woolridge
Manager, Study Programming
TAP Pharmaceutical Products Inc.
> Subject: Working with
Sent by: "SAS(r)
Please respond to
I have a dataset of begin and end dates of an event, multiple events
person. I've pasted an example of one person's data below (sorted by
begin date). What I need to do for each person is to make the first
with an END date of 10/30/2003 the last observation for that person.
for the person below, the fifth obs would be the last b/c I'd want to
delete the last three obs.
I know there must be an easy way to do this, but for some reason can't
seem to make it work. Any suggestions?
obs begin end
1 04/24/2001 04/28/2001
2 09/09/2001 12/19/2001
3 02/18/2002 03/29/2002
4 04/23/2002 04/27/2002
5 10/10/2002 10/30/2003
6 01/08/2003 01/09/2003
7 02/25/2003 10/30/2003
8 07/14/2003 10/30/2003