Thank you so much it's working. ... View more

Hi Tom, Thanks for your response, I tried with above logic to my code. But it's not reducing the width in output column. Here i am creating the XLS file through ODS in that output file Column width showing large size .i want to reduce that column width I have mentioned same code in below.could you please check once? proc report data=sashelp.cars nowd nocenter split="*" spacing=0 ; column Drivetrain msrp; define Drivetrain / display; define MSRP / display right style=[width=1 in] "Local Indian Security Value*inc. Accrued Interest" format=comma22.2 style={tagattr='format: #,##0.00'}; run; ... View more

Hi mate, There is no issue when you run code and it's generate the output,but when you create XLS files through ODS in that output file column width showing as large..i want reduce column width in output report ... View more

Thank for your response. When I applied the login as you suggested it's working fine. But when I applied into my code it's not showing as expected. I have attached sample code below which i used in my report . could please check once ? proc report data=sashelp.cars nowd nocenter split="*" spacing=0 ; column Drivetrain msrp; define Drivetrain / display; define MSRP / display right style (column)= [cellwidth=1.5 in] "Local Indian Security Value*inc. Accrued Interest" format=comma22.2 style={tagattr='format: #,##0.00'}; run; ... View more

If I use ERRORABEND in open code .. automatically sas session will close ..but i need to stop code with out closing session ... View more

Hi, Thank you for reaching out !! I am using Windows 10, and SAS version 9.4 . It's the first time I am using SAS in that system. ... View more