You can achieve it by following way; DATA bdata; INPUT FCC Name $ 5-17 Payment $ ID $ Section $ Ratio $; obsid=_N_; DATALINES; 1 Los Vegas, NV $1672.85 AI1 K087 33.6% 2 Columbus, OH $2345.70 BI3 S171 31.6% 3 Rochester, NY $8124.30 AI7 D171 30.7% 4 Dayton, OH $6259.00 AI4 Y345 28.2% 5 San Jose, CA $5150.30 vI7 D871 25.1% 6 Dallas, TX $9250.00 KI4 X355 23.2% 7 Los Vegas, NV $1672.85 AI1 K087 33.6% 8 Columbus, OH $2345.70 BI3 S171 31.6% 9 Rochester, NY $8124.30 AI7 D171 30.7% 10 Dayton, OH $6259.00 AI4 Y345 28.2% 11 San Jose, CA $5150.30 vI7 D871 25.1% 12 Dallas, TX $9250.00 KI4 X355 23.2% 13 Los Vegas, NV $1672.85 AI1 K087 33.6% 14 Columbus, OH $2345.70 BI3 S171 31.6% 15 Rochester, NY $8124.30 AI7 D171 30.7% 16 Dayton, OH $6259.00 AI4 Y345 28.2% 17 San Jose, CA $5150.30 vI7 D871 25.1% 18 Dallas, TX $9250.00 KI4 X355 23.2% 19 Los Vegas, NV $1672.85 AI1 K087 33.6% 20 Columbus, OH $2345.70 BI3 S171 31.6% 21 Rochester, NY $8124.30 AI7 D171 30.7% 22 Dayton, OH $6259.00 AI4 Y345 28.2% 23 San Jose, CA $5150.30 vI7 D871 25.1% 24 Dallas, TX $9250.00 KI4 X355 23.2% 25 Los Vegas, NV $1672.85 AI1 K087 33.6% 26 Columbus, OH $2345.70 BI3 S171 31.6% 27 Rochester, NY $8124.30 AI7 D171 30.7% 28 Dayton, OH $6259.00 AI4 Y345 28.2% 29 San Jose, CA $5150.30 vI7 D871 25.1% 30 Dallas, TX $9250.00 KI4 X355 23.2% 31 Los Vegas, NV $1672.85 AI1 K087 33.6% 32 Columbus, OH $2345.70 BI3 S171 31.6% 33 Rochester, NY $8124.30 AI7 D171 30.7% 34 Dayton, OH $6259.00 AI4 Y345 28.2% 35 San Jose, CA $5150.30 vI7 D871 25.1% 36 Dallas, TX $9250.00 KI4 X355 23.2% 37 Los Vegas, NV $1672.85 AI1 K087 33.6% 38 Columbus, OH $2345.70 BI3 S171 31.6% 39 Rochester, NY $8124.30 AI7 D171 30.7% 40 Dayton, OH $6259.00 AI4 Y345 28.2% 41 San Jose, CA $5150.30 vI7 D871 25.1% 42 Dallas, TX $9250.00 KI4 X355 23.2% 43 Los Vegas, NV $1672.85 AI1 K087 33.6% 44 Columbus, OH $2345.70 BI3 S171 31.6% 45 Rochester, NY $8124.30 AI7 D171 30.7% 46 Dayton, OH $6259.00 AI4 Y345 28.2% 47 San Jose, CA $5150.30 vI7 D871 25.1% 48 Dallas, TX $9250.00 KI4 X355 23.2% 49 Los Vegas, NV $1672.85 AI1 K087 33.6% 50 Columbus, OH $2345.70 BI3 S171 31.6% 51 Rochester, NY $8124.30 AI7 D171 30.7% 52 Dayton, OH $6259.00 AI4 Y345 28.2% 53 San Jose, CA $5150.30 vI7 D871 25.1% 54 Dallas, TX $9250.00 KI4 X355 23.2% 55 Los Vegas, NV $1672.85 AI1 K087 33.6% 56 Columbus, OH $2345.70 BI3 S171 31.6% 57 Rochester, NY $8124.30 AI7 D171 30.7% 58 Dayton, OH $6259.00 AI4 Y345 28.2% 59 San Jose, CA $5150.30 vI7 D871 25.1% 60 Dallas, TX $9250.00 KI4 X355 23.2% 61 Los Vegas, NV $1672.85 AI1 K087 33.6% 62 Columbus, OH $2345.70 BI3 S171 31.6% 63 Rochester, NY $8124.30 AI7 D171 30.7% 64 Dayton, OH $6259.00 AI4 Y345 28.2% 65 San Jose, CA $5150.30 vI7 D871 25.1% 66 Dallas, TX $9250.00 KI4 X355 23.2% 67 Los Vegas, NV $1672.85 AI1 K087 33.6% 68 Columbus, OH $2345.70 BI3 S171 31.6% 69 Rochester, NY $8124.30 AI7 D171 30.7% 70 Dayton, OH $6259.00 AI4 Y345 28.2% 71 San Jose, CA $5150.30 vI7 D871 25.1% 72 Dallas, TX $9250.00 KI4 X355 23.2% 73 Los Vegas, NV $1672.85 AI1 K087 33.6% 74 Columbus, OH $2345.70 BI3 S171 31.6% 75 Rochester, NY $8124.30 AI7 D171 30.7% 76 Dayton, OH $6259.00 AI4 Y345 28.2% 77 San Jose, CA $5150.30 vI7 D871 25.1% 78 Dallas, TX $9250.00 KI4 X355 23.2% 79 Los Vegas, NV $1672.85 AI1 K087 33.6% 80 Columbus, OH $2345.70 BI3 S171 31.6% 81 Rochester, NY $8124.30 AI7 D171 30.7% 82 Dayton, OH $6259.00 AI4 Y345 28.2% 83 San Jose, CA $5150.30 vI7 D871 25.1% 84 Dallas, TX $9250.00 KI4 X355 23.2% 85 Los Vegas, NV $1672.85 AI1 K087 33.6% 86 Columbus, OH $2345.70 BI3 S171 31.6% 87 Rochester, NY $8124.30 AI7 D171 30.7% 88 Dayton, OH $6259.00 AI4 Y345 28.2% 89 San Jose, CA $5150.30 vI7 D871 25.1% 90 Dallas, TX $9250.00 KI4 X355 23.2% 91 Los Vegas, NV $1672.85 AI1 K087 33.6% 92 Columbus, OH $2345.70 BI3 S171 31.6% 93 Rochester, NY $8124.30 AI7 D171 30.7% 94 Dayton, OH $6259.00 AI4 Y345 28.2% 95 San Jose, CA $5150.30 vI7 D871 25.1% 96 Dallas, TX $9250.00 KI4 X355 23.2% 97 Los Vegas, NV $1672.85 AI1 K087 33.6% 98 Columbus, OH $2345.70 BI3 S171 31.6% 99 Rochester, NY $8124.30 AI7 D171 30.7% 100 Dayton, OH $6259.00 AI4 Y345 28.2% 101 San Jose, CA $5150.30 vI7 D871 25.1% 102 Dallas, TX $9250.00 KI4 X355 23.2% 103 Los Vegas, NV $1672.85 AI1 K087 33.6% 104 Columbus, OH $2345.70 BI3 S171 31.6% 105 Rochester, NY $8124.30 AI7 D171 30.7% 106 Dayton, OH $6259.00 AI4 Y345 28.2% 107 San Jose, CA $5150.30 vI7 D871 25.1% 108 Dallas, TX $9250.00 KI4 X355 23.2% 109 Los Vegas, NV $1672.85 AI1 K087 33.6% 110 Columbus, OH $2345.70 BI3 S171 31.6% 111 Rochester, NY $8124.30 AI7 D171 30.7% 112 Dayton, OH $6259.00 AI4 Y345 28.2% 113 San Jose, CA $5150.30 vI7 D871 25.1% 114 Dallas, TX $9250.00 KI4 X355 23.2% 115 Los Vegas, NV $1672.85 AI1 K087 33.6% 116 Columbus, OH $2345.70 BI3 S171 31.6% 117 Rochester, NY $8124.30 AI7 D171 30.7% 118 Dayton, OH $6259.00 AI4 Y345 28.2% 119 San Jose, CA $5150.30 vI7 D871 25.1% 120 Dallas, TX $9250.00 KI4 X355 23.2% ; RUN; OPTIONS PAPERSIZE=A4 ORIENTATION=LANDSCAPE; ODS PDF FILE='E:\fccdata.pdf'; ODS LAYOUT GRIDDED COLUMNS=3 COLUMN_GUTTER=0.13in STYLE={BACKGROUND=lightgray}; ODS REGION STYLE={BACKGROUND=lightblue}; PROC REPORT DATA=bdata; COLUMNS(FCC Name Payment ID Section Ratio); WHERE obsid GT 0 AND obsid LE 40; RUN; ODS REGION STYLE={BACKGROUND=lightblue}; PROC REPORT DATA=bdata; COLUMNS(FCC Name Payment ID Section Ratio); WHERE obsid GT 40 AND obsid LE 80; RUN; ODS REGION STYLE={BACKGROUND=lightblue}; PROC REPORT DATA=bdata; COLUMNS(FCC Name Payment ID Section Ratio); WHERE obsid GT 80 AND obsid LE 120; RUN; ODS LAYOUT END; ODS PDF CLOSE;
... View more
