@yaakov555 wrote: 1,2,3,4,5 Those are the numbers that the counter produces. It does not explain what is being counted. ... View more

yes it worked. thanks and I accepted as the solution. ... View more

case when dr_phone like '(07%)' then 'Mobile' else 'Landline' ... View more

I have update the code to account for the presence of St in the address. data have; Retain Name Address; length Address $ 100; input Name $ _Addr $ 100.; infile datalines dsd dlm=',' truncover; Address=tranwrd(tranwrd(tranwrd(tranwrd(_Addr,'Rd', "Road"),'AVE', "Avenue"),'CL',"Close"),' St '," Street"); drop _Addr; datalines; Samy ,2 Stream St Amy ,2 Stream Rd Mary,1/891 Mason AVE John,821 Stream Road Ivy,67 Tork CL Martin ,5/891 Mason Avenue ; run; The output will be like as shown below. It is what you want.     ... View more

Hi:   Your code needs to take full control of the ODS destination. It looks like you are using the default ODS HTML destination. Most of the demographic reports like this that I see are created for RTF and/or PDF output, not HTML. but in any case, you need full control so that you can control the destination and the style being used. In addition, I used some simple ODS style overrides in the PROC REPORT code to turn off the grid lines. Rather than run your code over and over again, I just made a CSV file for WORK.REP and used that. Changes to your code are highlighted in yellow: All the output is shown below: Cynthia   ... View more

Thanks ODS works ... View more