topic Re: Adding extra years for each observation in SAS Programming

Adding extra years for each observation

nazmul — Fri, 12 May 2017 02:13:02 GMT

Hi,

I want to add year 12/31/1971 and 12/31/1986 to each ID. Can anyone please help me to do it. I have attached an excel file with sample data. I will be grateful if anyone can help me.

Re: Adding extra years for each observation

Reeza — Fri, 12 May 2017 02:31:08 GMT

Use BY groups again and LAST with explicit OUTPUT.

data want; 
set have;
by id;

output;

if last.id then do;
    date='01Jan2017'd; output;
    date='02Jan2017'd; output;
end;

run;

@nazmul wrote:

Hi,

I want to add year 12/31/1971 and 12/31/1986 to each ID. Can anyone please help me to do it. I have attached an excel file with sample data. I will be grateful if anyone can help me.

Re: Adding extra years for each observation

nazmul — Fri, 12 May 2017 03:28:28 GMT

Thank you very much for your reply. Your code adds two additional years:
1976 and 2017 after each observation but it also copies the other variables
associated with last reported year of each observation in the missing year.
I want the two additional year and all the variables associated with the
year missing (.). Could you please modify your code to do it? I have added
an excel file with my original data and expected SAS output.

##- Please type your reply above this line. Simple formatting, no
attachments. -##

Re: Adding extra years for each observation

nazmul — Fri, 12 May 2017 03:28:29 GMT

Re: Adding extra years for each observation

Reeza — Fri, 12 May 2017 03:57:57 GMT

1. There's no attachment

2. Set the values to missing manually or use call missing() in the do condition.

Re: Adding extra years for each observation

nazmul — Fri, 12 May 2017 05:07:35 GMT

Thank you. I set other variable as missing with if function.