Hi,   Can some one help me to dsiplay report like below .   I am looking for Regular Page Number , BY variable page number on same line (left,,right)   Page number : 1       Byvariable:State:MN : Page No :1 Page number : 2       Byvariable:State:MN : Page No :2 Page number : 3       Byvariable:State:MN : Page No : 3 ====================   Page number : 4       Byvariable:State:OH : Page No :1 Page number : 5       Byvariable:State:OH : Page No :2 Page number : 6       Byvariable:State:OH : Page No : 3   Thanks ... View more

could one of you please help me on the below ? Input is on left side and output is on rigth side !!   proc report iam trying but it is not working when it is on blank rows (col4).   Intput                output                 Name  Age col1 col2 col3 col4 col5   Name  Age col1 col2 col3 col4 col5   ABC 25 bus1 cat1 dog1   pig1   ABC 25 bus1 cat1 dog1   pig1       bus1 cat1 dog1   pig2               pig2       bus1 cat1 dog1   pig3               pig3       bus1   dog1   pig4               pig4       bus1       pig5               pig5   DEF 25 bus1 cat1 dog1 frog1 pig1   DEF 25 bus1 cat1 dog1 frog1 pig1       bus1 cat1 dog1 frog2 pig2             frog2 pig2       bus1 cat1 dog1   pig3               pig3       bus1   dog1   pig4               pig4       bus1       pig5               pig5 ... View more

Hi, Can some one help me to dsiplay report like below .   I am looking for Page Number , Title and datestamp on same line (left,center,right)     ... View more

I am trying to combine two columns and add a enter or next line the values , can you help me ?   data test; x="himom"; y="hidad"; ; run; data want; set test ; length D $50 ; d = catx('0D0A'x,x,y); run; proc print data=want;run;   Result i want :   newcolumn ----------- himom hidad ... View more

How to get rid off equal symbol in proc report output header ? data test; input id name $20.; cards; 101 abc 102 def 103 gth 104 nmj ; run; proc report data=test headline nowindows ;by id; columns id name; run;       ... View more

Can some one help me to get below ouput ?   left side iam expecting  right side is the input   trying to shift cells up and keep id multiple rows when multiple cells                                  Input                output             id col1 col2 col3 col4       id col1 col2 col3 col4   1 abc             1 abc abc2 abc3     1   abc2 abc3         2 abz xyz hjds     2 abz             3 wer sdsf ere rtr   2   xyz hjds         3     erew fgt   3 wer     rtr       4 erer bgng tyt rgrgr   3     ere fgt               rtr   3   sdsf erew rgrgr                   4 erer bgng tyt rtr                 ... View more