Date:         Mon, 2 Nov 2009 17:56:50 -0500
Reply-To:     Arthur Tabachneck <art297@NETSCAPE.NET>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Arthur Tabachneck <art297@NETSCAPE.NET>
Subject:      Re: last observation of the hour
Comments: To: Mark Terjeson <Mterjeson@RUSSELL.COM>

I vote for Mark's suggested solution:

data result;
    set sample;
    by ID Date Hour;
    flag = last.Hour;
run;

Art
--------
On Mon, 2 Nov 2009 14:38:40 -0800, Terjeson, Mark <Mterjeson@RUSSELL.COM>
wrote:

>Hi Randy,
>
>When you use a BY statement with the
>SET statement you get first. and last.
>flags for the BY variables which contain
>0 and 1.
>
>
>data sample;
>    input ID Date date9. Hour Vara;
>    format Date date9.;
>cards;
>1 01NOV2009 10 13.5
>1 01NOV2009 10 12.5
>1 01NOV2009 10 9.5
>1 01NOV2009 11 7.5
>1 01NOV2009 11 6.5
>1 01NOV2009 11 5.5
>1 02NOV2009 10 113.5
>1 02NOV2009 10 2.5
>1 02NOV2009 10 29.5
>1 02NOV2009 11 17.5
>1 02NOV2009 11 10.5
>1 02NOV2009 11 2.5
>2 01NOV2009 10 13.5
>2 01NOV2009 10 2.5
>2 01NOV2009 10 7.5
>2 01NOV2009 11 1.5
>2 01NOV2009 11 16.5
>2 01NOV2009 11 25.5
>2 02NOV2009 10 103.5
>2 02NOV2009 10 102.5
>2 02NOV2009 10 239.5
>2 02NOV2009 11 177.5
>2 02NOV2009 11 1.5
>2 02NOV2009 11 0.5
>;
>run;
>
>data result;
>    set sample;
>    by ID Date Hour;
>    flag = last.Hour;
>run;
>
>
>
>
>Hope this is helpful.
>
>
>Mark Terjeson
>Investment Business Intelligence
>Investment Management & Research
>Russell Investments
>253-439-2367
>
>
>Russell
>Global Leaders in Multi-Manager Investing
>
>
>
>
>-----Original Message-----
>From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of
>Randy
>Sent: Monday, November 02, 2009 2:21 PM
>To: SAS-L@LISTSERV.UGA.EDU
>Subject: last observation of the hour
>
>Dear All:
>  My data set is as follows:
>
>ID  Date          Hour   Vara
>1   01NOV2009      10     13.5
>1   01NOV2009      10     12.5
>1   01NOV2009      10     9.5
>1   01NOV2009      11     7.5
>1   01NOV2009      11     6.5
>1   01NOV2009      11     5.5
>1   02NOV2009      10     113.5
>1   02NOV2009      10     2.5
>1   02NOV2009      10     29.5
>1   02NOV2009      11     17.5
>1   02NOV2009      11     10.5
>1   02NOV2009      11     2.5
>2   01NOV2009      10     13.5
>2   01NOV2009      10     2.5
>2   01NOV2009      10     7.5
>2   01NOV2009      11     1.5
>2   01NOV2009      11     16.5
>2   01NOV2009      11     25.5
>2   02NOV2009      10     103.5
>2   02NOV2009      10     102.5
>2   02NOV2009      10     239.5
>2   02NOV2009      11     177.5
>2   02NOV2009      11     1.5
>2   02NOV2009      11     0.5
>
>I want to flag the last observation of VArA each hour
>
>ID  Date          Hour   Vara       Flag
>1   01NOV2009      10     13.5       0
>1   01NOV2009      10     12.5       0
>1   01NOV2009      10     9.5        1
>1   01NOV2009      11     7.5        0
>1   01NOV2009      11     6.5        0
>1   01NOV2009      11     5.5        1
>1   02NOV2009      10     113.5      0
>1   02NOV2009      10     2.5        0
>1   02NOV2009      10     29.5       1
>1   02NOV2009      11     17.5       0
>1   02NOV2009      11     10.5       0
>1   02NOV2009      11     2.5        1
>2   01NOV2009      10     13.5       0
>2   01NOV2009      10     2.5        0
>2   01NOV2009      10     7.5        1
>2   01NOV2009      11     1.5        0
>2   01NOV2009      11     16.5       0
>2   01NOV2009      11     25.5       1
>2   02NOV2009      10     103.5      0
>2   02NOV2009      10     102.5      0
>2   02NOV2009      10     239.5      1
>2   02NOV2009      11     177.5      0
>2   02NOV2009      11     1.5        0
>2   02NOV2009      11     0.5        1
>
>Please Help
>        Randy