topic Re: Data Problem in SAS Programming

Data Problem

RahulBandgar — Mon, 24 Aug 2015 12:14:35 GMT

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

Re: Data Problem

LinusH — Mon, 24 Aug 2015 12:32:44 GMT

Please avoid duplicate postings.

Re: Data Problem

Ksharp — Mon, 24 Aug 2015 13:53:19 GMT

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;