|Date: ||Fri, 14 Mar 2003 20:11:31 GMT|
|Reply-To: ||Matthew C Roberts <roberts.628@OSU.OMITTHIS.EDU>|
|Sender: ||"SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>|
|From: ||Matthew C Roberts <roberts.628@OSU.OMITTHIS.EDU>|
|Organization: ||Ohio State University|
|Subject: ||Re: Converting Daily to Weekly data|
Very nice, Biff.
On 14 Mar 2003 08:55:18 -0800, Biff@Canlett.com (Biff Canlett) wrote:
>Create two new fields.
>THEWEEK derived from function INTNX will define which week it is by
>presenting one artificial date for each week.
>RANK will define your preference for the specific day of week. For
>RANK, use the function WEEKDAY in a select statement to manually
>assign the rank.
>After these assignments are completed in a data step, sort the data by
>THEWEEK RANK, then SET by THEWEEK RANK in a data step and use IF
>FIRST.RANK to select the records to keep.