topic fill the values based on the ID in New SAS User

fill the values based on the ID

Smitha9 — Fri, 16 Dec 2022 19:16:33 GMT

Hi,

I have a dataset A

ID date

1 12/13/2022

1 .

1 12/13/2022

1 .

2 03/26/1978

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

2 03/26/1978

3 07/29/1980

4 10/02/1982

data b; set a;

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

thanks in advance

Re: fill the values based on the ID

Tom — Fri, 16 Dec 2022 19:21:59 GMT

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;

Re: fill the values based on the ID

mkeintz — Fri, 16 Dec 2022 19:50:49 GMT

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;