There is a easy way to avoid this truncation.. you can use this code.. proc format; value $test (default=50) "*99"="*skipped"; run; (In default= option you can specify length for the fomat) ... View more

Thank you...its working... one more thing.. if the value of apr or may or jun in %ach is less then 50%, i want to blink that values... is it possible??? ... View more

Hi.. please find the bellow data and code.... data test; input source $    group$    Apr11    May11    Jun11    Jul11; cards; Stock    North    1500    2500    3500    4500 Stock    South    1500    2500    3500    4500 Stock    East    1500    2500    3500    4500 Stock    West    1500    2500    3500    4500 Target    North    1500    2500    3500    4500 Target    South    1500    2500    3500    4500 Target    East    1500    2500    3500    4500 Target    West    1500    2500    3500    4500 Ach    North    1000    1000    1000    1000 Ach    South    700        700        700        700 Ach    East    850        850        850        850 Ach    West    925        925        925        925 %Ach    North    0.666667    0.4    0.285714    0.222222 %Ach    South    0.466667    0.28    0.2    0.155556 %Ach    East    0.566667    0.34    0.242857    0.188889 %Ach    West    0.616667    0.37    0.264286    0.205556 ; run; ods html body="C:\Users\sanjeev\Desktop\file.html"; proc report data=test; column source group apr11 may11 jun11 jul11; define source/group; define gropu/group; define apr11/analysis; define may11/analysis; define jun11/analysis; define jul11/analysis; compute apr11; if source="%ach" then do; call define(_col_,'format','percent10.2'); end; endcomp; compute may11; if source="%ach" then do; call define(_col_,'format','percent10.2'); end; endcomp; compute jun11; if source="%ach" then do; call define(_col_,'format','percent10.2'); end; endcomp; compute jul11; if source="%ach" then do; call define(_col_,'format','percent10.2'); end; endcomp; run; ods html close; ... View more

Thank you.... one more question... This is the file i impored from excel sheet..                                         east        100                                                       150                                                       165                                         west        230                                                       430                                                       230 i want to make this data like this...                                         east        100                                         east        150                                         east        165                                         west        230                                         west        430                                        west         230 slove this.... ... View more

its working... but if i want 3rd state in each zone???? what should i do???? ... View more

Thank  you art297 for quick reply.. i found another way.. proc contents data=sashelp.class out=class1(keep=name); run; proc sql; select name into:names separated by '' from class1; quit; data final; retain &names; set sashelp.class; run; ... View more