BookmarkSubscribeRSS Feed
Aman4SAS
Obsidian | Level 7

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
Super User

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
Obsidian | Level 7

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
Super User

cellheight=  ?

Aman4SAS
Obsidian | Level 7

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

Ksharp
Super User

Then post it at  .

Maybe Cynthia could give you right answer .

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 20 replies
  • 2464 views
  • 7 likes
  • 4 in conversation