|
While you've said you want an index, it sounds like a simple macro might
be easier. Does the following accomplish what you want to do?
data have;
informat Beg yymmdd8.;
informat End yymmdd8.;
format Beg date9.;
format End date9.;
input ID Beg End;
cards;
10007 19570301 19840718
10008 19570301 20070214
10009 19580604 19760630
10020 19570301 20081231
;
%macro listyear (Beg,End);
%do year=&Beg. %to &End.;
title "List for Year=&year.";
proc print data=have
(where=(year(Beg)<=&year.<=year(end)));
run;
%end;
%mend listyear;
%listyear(1957,2008)
Art
----------
On Sun, 17 Jan 2010 12:06:23 -0500, SAS user <sasuser4@GOOGLEMAIL.COM>
wrote:
>Thank you for the reply.
>
>What I want to do is to be able to create a list of observations for each
>year based on beg and end dates. So for example for id 10020 I want to
>have an indicator/variable to designate that this observation is included
>in an index in 1957, 1958....and 2008. I 'm looking for the most efficient
>way to accomplish this considering that each observation is likely to be
>in an index for many years and at the end I would like to have a list of
>observations included in the index for each year.
>
>
>
>
>On Sun, 17 Jan 2010 11:24:45 -0500, Arthur Tabachneck
><art297@NETSCAPE.NET> wrote:
>
>>In order to answer your question the list probably needs more information
>>about what you are trying to do. If it is simply to select based on Beg
>>and End, you might already have the variables you need. E.g.:
>>
>>data have;
>> informat Beg yymmdd8.;
>> informat End yymmdd8.;
>> format Beg date9.;
>> format End date9.;
>> input ID Beg End;
>> cards;
>>10007 19570301 19840718
>>10008 19570301 20070214
>>10009 19580604 19760630
>>10020 19570301 20081231
>>;
>>
>>data want;
>> set have (where=(Beg<='01MAR1957'd<=End));
>>run;
>>
>>HTH,
>>Art
>>--------
>>On Sun, 17 Jan 2010 08:28:47 -0500, SAS user <sasuser4@GOOGLEMAIL.COM>
>>wrote:
>>
>>>Hello
>>>
>>>Below is a sample of my data
>>>
>>>ID Beg End
>>>10007 19570301 19840718
>>>10008 19570301 20070214
>>>10009 19580604 19760630
>>>10020 19570301 20081231
>>>
>>>The objective is to create a dataset which will allow me to identify the
>>>IDs which were included in the dataset as identified by the end
variable.
>>>
>>>For example for ID 10020 I want to have a variable that will enable me
to
>>>identify that this ID was in the dataset in 1957, 1958, 1959.... till
>>>12/2008.
>>>
>>>Any suggestions would be most welcome.
>>>
>>>Thanks!
|
