topic Re: Sas proc report in SAS Programming

Sas proc report

ganeshsas764 — Fri, 23 Dec 2022 13:19:14 GMT

Hi Team,
I developed a proc report code generate the report through ODS ,but am facing column width issue for few variable which are have larger label name (I used split option but no use). Could you please help how to reduce the column width with out changing the label name.

Proc report data=sashelp.class split='*';
Col name sex age;
Define name/display;;
Define sex/display ;
Define age/display width=5 format=5. 'Indian socity*Boys and girls*age details as per certificate*;
Run;

Re: Sas proc report

Tom — Fri, 23 Dec 2022 13:53:00 GMT

Are you generating plain old text output? If so then make the width value longer so it does not have to chop words in half.

Or are you generating ODS output ("fancy" output)? If so then use STYLE= option to set the column width.

Example with both:

proc report data=sashelp.class split='*';
  col name sex age;
  define name/display;;
  define sex/display ;
  define age/display width=20 format=5. style=[width=1 in]
    'Indian society*Boys and girls*age details as per certificate'
  ;
run;

                      Indian socity
            S        Boys and girls
            e    age details as per
  Name      x           certificate
  Alfred    M                    14
  Alice     F                    13
  Barbara   F                    13
  Carol     F                    14
  Henry     M                    14
  James     M                    12
  Jane      F                    12
  Janet     F                    15
  Jeffrey   M                    13
  John      M                    12
  Joyce     F                    11
  Judy      F                    14
  Louise    F                    12
  Mary      F                    15
  Philip    M                    16
  Robert    M                    12
  Ronald    M                    15
  Thomas    M                    11
  William   M                    15

Re: Sas proc report

tarheel13 — Sat, 24 Dec 2022 17:26:23 GMT

How wide do you want it to be? I added code to make it 1.5 inches.

Proc report data=sashelp.class split='*';
Col name sex age;
Define name/display;;
Define sex/display ;
Define age/display style(column)=[cellwidth=1.5in] format=5. 'Indian socity*Boys and girls*age details as per certificate*;
Run;

Re: Sas proc report

ganeshsas764 — Tue, 27 Dec 2022 07:54:20 GMT

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;

Re: Sas proc report

xxformat_com — Tue, 27 Dec 2022 11:04:23 GMT

Hi,

I don't have any issue when running your code on my computer.

Is there any message in the log? Can you share a picture of the result you get?

Have you tried to split the statement into several lines? It could be that the width of your screen editor is too short.

Make sure ls=max too.

Best Regards,

Re: Sas proc report

ganeshsas764 — Tue, 27 Dec 2022 11:09:29 GMT

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

Re: Sas proc report

ganeshsas764 — Tue, 27 Dec 2022 11:17:59 GMT

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;

Re: Sas proc report

xxformat_com — Tue, 27 Dec 2022 12:08:54 GMT

Use a single style= option in your define statement.


ods excel file="&xxproject/reporting/test.xlsx";* options(flow='table');
proc report data=sashelp.cars nowd split="*"; 
column Drivetrain msrp;
define Drivetrain / display;
define MSRP / display "Local Indian Security Value*inc. Accrued Interest" 
                      style (column)=[cellwidth=.5in 
                                      textalign=right 
                                      tagattr='format: #,##0.00'] 
                      format=comma10.2;
run;
ods excel close;

Re: Sas proc report

ganeshsas764 — Tue, 03 Jan 2023 07:16:05 GMT

Thank you so much it's working.