Excel sheets through ODS

[Aman4SAS]

Thanks for your great guidance.

We are already working on ur suggested procedure. but in this case task become multi talk and very time consuming.

ODS is very helpful. but i m just missing my chart requirement with time series. i am trying to use VBA to create chart with created time series through ODS.

Thanks again.

If possible just please guide me to increase the height of line in proc report , that will help me to add my summary along with my report.

[Ksharp]

Can you delete that file before run the ods code ?

x 'delete c:\temp\tmp.xls' ;

ods tagsets.excelxp file="c:\temp\tmp.xls"

about increasing the number of column ,try the following option to make more room in a page .

option topmargin=2 leftmargin=2

Xia Keshan

[Aman4SAS]

Thanks, But i m looking for incresing height of line, becaz my lines are long and its been wrap and overlap by next line. {In case of line font size also not working, if i will remove"(*ESC*)S" and i will issue to make first line bold}

My code is below:

proc report data = TableA nowd headline headskip split= "*"

style(report)=[cellspacing=2 borderwidth=1 bordercolor=blue]

style(header)=[color=black

               fontsize =3 textalign=l fontfamily = 'Times New Roman' fontweight=bold]

style(column)=[color=black

               fontfamily='Times New Roman' fontsize=2 just=center]

style(lines)=[color=Black backgroundcolor=grey

              fontstyle=italic fontweight=bold fontsize=1 just =l]

style(summary)=[color=cx3e3d73 backgroundcolor=cxaeadd9

                fontfamily=helvetica fontsize=3 textalign=r];

column ("Heading line" (Area Totalsale Mom sdrates));

DEFINE AREA / "        *         *  LOCATION" style(Header)=[just=center cellwidth=2 in] style(column)=[just=l];

define totalsale/ "Total ads~{super 1}*(Thousands)*&currmon" style(Header)=[just=center cellwidth=1 in]  style(column)=[tagattr='format:#,##0.0'];

define mom/ "M-O-M*Change*&currmon - &prevmon" style(Header)=[just=center cellwidth=1.2 in]  style(column)=[tagattr='format:#,##0.0'];

Define sdrates/"Supply/*Demand Rates~{super 2}*&msta" style(Header)=[just=center cellwidth=1.4 in] style(column)=[tagattr='format:##.00'];

compute Area;

      if Area in ("NORTHEAST","SOUTH","MIDWEST","WEST") and _break_=' ' then

      call define(_row_, "style",

                  "style=[backgroundcolor=yellow

                          fontfamily='Times New Roman'

                          fontweight=bold]");

if Area = "United States" and _break_=' ' then

      call define(_row_, "style",

                  "style=[backgroundcolor=cxaeadd9

                          fontfamily='Times New Roman'

                          fontweight=bold]");

   endcomp;

   compute after ;

line "(*ESC*)S={ textalign= left Font_weight=bold font_size=1 fontfamily='times new roman'}line 1 (*ESC*)S={}";

line "(*ESC*)S={ font_size=1 fontfamily='times new roman'}line 2 (*ESC*)S={}";

line "(*ESC*)S={ font_size=1 fontfamily='times new roman'}Line 3 (*ESC*)S={}";

   endcomp;

   FORMAT totalads 7.1 MOM 7.1 sdrates 7.2;

run;

[Ksharp]

cellheight=  ?

[Aman4SAS]

cellheight , row_height , all i have tried but not working. at the same time fontsize also not working for lines

[Ksharp]

Then post it at  .

• ODS and Base Reporting

Maybe Cynthia could give you right answer .