How to get aligned ?

[yogita_patel]

Hi, 

How can I get the output for values as like compare value. Because of the alignment in value my proc compare report is showing mismatch value. I want output like compare value

can someone help me please?

[Reeza]

Show your code for how you created Base Values, assuming that's the one that you want changed.

[yogita_patel]

data adae_com3;
set adae_com2;
length col2 col3 col7 $25.;
col2 = strip (C1002) ||' '|| strip(put(round(input(C1002,best.)*100/&n02,0.1),perc.));
col3 = strip (C1005) ||' '|| strip(put(round(input(C1005,best.)*100/&n05,0.1),perc.));
col7 = strip (total) ||' '|| strip(put(round(input(total,best.)*100/&nt,0.1),perc.));

run;

[ballardw]

---

@yogita_patel wrote:

data adae_com3;
set adae_com2;
length col2 col3 col7 $25.;
col2 = strip (C1002) ||' '|| strip(put(round(input(C1002,best.)*100/&n02,0.1),perc.));
col3 = strip (C1005) ||' '|| strip(put(round(input(C1005,best.)*100/&n05,0.1),perc.));
col7 = strip (total) ||' '|| strip(put(round(input(total,best.)*100/&nt,0.1),perc.));

run;

---

You are missing some details such as values of macro variables &n02, &n05, &nt, example values for variables C1002, C1005 and Total, the definition for the custom format PERC, and some actual desired results for provided values of C

[Reeza]

Can you share some input data and the perc format?