Adding extra years for each observation

[nazmul]

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.

[Reeza · Accepted solution]

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.

---

[nazmul]

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. -##

[nazmul]

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. -##

[Reeza]

1. There's no attachment

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

[nazmul]

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