Use RETAIN, please post your sample data using a data step in the future. Instructions on how to provide data in that format is included here.
- Retain to hold values across rows
- LENGTH before SET to have variable in the first column rather than the last column
- WHERE on output to filter out the missing values after the calculations are done. You could do it in another step or you can add a DELETE statement as well.
data have;
infile cards truncover;
informat variable $14.;
input Variable Value ;
cards;
total_fee
mean 100
median 110
flag_customer 1000
unit
mean 10
median 12
;;;;
run;
data clean(where=(not missing(value)));
length variable_Summarized $32.;
set have;
retain Variable_Summarized;
if missing(Value) then Variable_Summarized = variable;
drop variable;
run;
proc print;
run;
@di_niu0 wrote:
Hi All,
I've got a SAS data set like the one below. The second and third rows are the mean and median for the total fee, respectively. Similarly, the last two rows are the mean and median for the unit, respectively. This table is hard to do analysis. I would like to add some indicators to differentiate the two sets of mean and median. Not sure how to do. Thank you in advance.
Variable Value
total_fee
mean 100
median 110
flag_customer 1000
unit
mean 10
median 12
