Data Problem

Reply
New Contributor
Posts: 3

Data Problem

I have a dataset in which there a 3 columns.

A       B       C

1       .          1

1       .          2    

1       .          3

1       0            

2       .          1

2        .          2

2        0        

3         .          1

3         .          2

3        0         

So question is like this when B=0 then we have to carry forward  the values of C.

for example:

A       B       C    

1       .          1   

1       .          2   

1       .          3   

1       0         1

1       0         2         

1       0         3


This type of output I want. Can anyone please help me ??pro


Esteemed Advisor
Posts: 5,198

Re: Data Problem

Please avoid duplicate postings.

Data never sleeps
Grand Advisor
Posts: 9,576

Re: Data Problem

Code: Program

data have;
input A   B   C;
cards;
1 . 1
1 . 2 
1 . 3
1 0 .
2 . 1
2 . 2
2 0 .
3 . 1
3 . 2
3 0 .
;
run;
proc sql;
create table want as
select a.*,b.c
  from (select distinct A,B from have) as a,
   (select distinct A,C from have where C is not missing) as b
   where a.A=b.A
   order by a.a,a.b,b.c;
quit;
Ask a Question
Discussion stats
  • 2 replies
  • 164 views
  • 0 likes
  • 3 in conversation