fill the values based on the ID

[Smitha9]

Hi,

I have a dataset A

ID      date

1      12/13/2022

1            .       

1      12/13/2022

1             .

2       03/26/1978

2             .

2             .

3        07/29/1980

4        10/02/1982

4                 .

I want the dataset B to fill the Date based on the ID's

Example:

ID      date

1      12/13/2022

1      12/13/2022       

1      12/13/2022

1      12/13/2022

2       03/26/1978

2       03/26/1978

2       03/26/1978      

3       07/29/1980

4       10/02/1982

4       10/02/1982        

data b; set a;

could you let me know how to do this in SAS?

thanks in advance

[Tom]

If you only want to carry forward the dates (not try to move them backwards in the file) then try to UPDATE statement.

data want;
  update have(obs=0) have ;
  by id; 
  output;
run;

[mkeintz]

If there is no variation of DATE within each id, then:

data have;
  input ID      date :mmddyy10.;
  format date date9.;
datalines;
1      12/13/2022
1            .       
1      12/13/2022
1             .
2       03/26/1978
2             .
2             .
3        07/29/1980
4        10/02/1982
4                 .
run;

data want;
  merge have (keep=id date where=(date^=.)) have (drop=date)  ;
  by id;
run;