topic copy column values to next row? in SAS Procedures

copy column values to next row?

sassharp — Sat, 02 Apr 2016 02:30:38 GMT

ID Regionnumber satisfy code zipregion

1 2

2 2 Y 1 6

3 1 N 2 6

4 1

5 3 Y 1 6

6 3 Y 6

7 3

8 3

9 4 Y 2 6

10 0 N 6

11 5 Y 1 6

12 6 Y 2 6

13 7 N 1 6

14 0 1 6

Q) If Regionnumber is same for two ids, then need to copy populated ID row column values to not populated ID column values?

If there is only unique Regionnumber or Regionnumber value is 0 ignore those rows. No need to change any column values.

Thanks in advance.

Re: copy column values to next row?

Ksharp — Sat, 02 Apr 2016 02:59:28 GMT

You'd better post the output you need too.




data have;
input ID  Regionnumber   satisfy $ code zipregion;
cards;
1        2 . . .
2        2                     Y        1       6
3        1                      N        2       6
4        1      . . .                                    
5        3                      Y        1       6
6        3                      Y         .         6
7        3          . . .
8        3         . . .
9        4                      Y         2       6
10      0                      N           .       6
11       5                      Y          1      6
12       6                      Y          2      6
13       7                      N          1      6
14       0                       .            1      6
;
run;
data want;
n=0;
 do until(last.Regionnumber);
  set have;
  by Regionnumber  notsorted;
  n+1;
  if not missing(satisfy) then _satisfy=satisfy;
  if not missing(code) then _code=code;
  if not missing(zipregion) then _zipregion=zipregion;
 end;
 _Regionnumber =Regionnumber  ;
 do until(last.Regionnumber);
  set have;
  by Regionnumber  notsorted;
  if n gt 1 and _Regionnumber ne 0 then do;
   satisfy=_satisfy;
   code=_code;
   zipregion=_zipregion;
   output;
  end;
  else output;
 end;
 drop _: n;
run;

Re: copy column values to next row?

sassharp — Mon, 04 Apr 2016 15:50:52 GMT

Output needed

ID Regionnumber satisfy code zipregion

1 2 Y 1 6

2 2 Y 1 6

3 1 N 2 6

4 1 N 2 6

5 3 Y 1 6

6 3 Y 1 6

7 3 Y 1 6

8 3 Y 1 6

9 4 Y 2 6

10 0 N 6

11 5 Y 1 6

12 6 Y 2 6

13 7 N 1 6

14 0 1 6

Re: copy column values to next row?

sassharp — Mon, 04 Apr 2016 16:55:58 GMT

If there are no duplicates for regionnumber(that means leave unique regionnumber without any column value changes) or regionnumber is 0 no changes to column values.

if regionnumber exists more than once need to copy all column values of regionnumber populated ones with not populated regionnumber.