cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Eva
‎03-22-2021
  • 159 Posts
  • 10 Likes Given
  • 0 Solutions
  • 11 Likes Received
About
SAS Certified Base Programmer for SAS 9 ; STPs ; Web Applications with SAS ; SAS/GRAPH

vbar size with title in pdf

by Quartz | Level 8 in Graphics Programming
‎05-30-2012 07:39 AM
‎05-30-2012 07:39 AM
Dear all, I create pdf output with a graph, a vbar. As soon as I set titles, der vertical size of the graph gets very small - too small - it doesn't use all of the paper I have. Here's my code (I use SAS 9.2 with UNIX in the SAS portal): options orientation=landscape papersize=a3; ods pdf body=_webout style=sasweb notoc uniform; [this is where I would put the title - code see below] goptions device=sasprtc ftext="helvetica" cback=white colors=(CX113388,CX426BB2,CX819CCC,CXB3C4DC); proc gchart data=work.mygraph;      vbar field1 / group=field2 freq=field3 patternid=midpoint frec discrete raxis=axis1 maxis=axis2 gaxis=axis3;      axis1 label=(h=10 angle=90 color=black 'My label') minor=none;      axis2 label=none;      axis3 label=none; run; quit; If I don't use a title the graph is ok in size (yet vsize nor ypixels help in enlarging it vertically). Now when I use title where I indicated in the code above (or within the proc step - effect it the same) the graph gets smaller. And it even gets smaller when I user more titles: title "My heading"; title2 "some remarks"; title3 "blabla"; ... title9 "text"; I then have the title on the top of the page followed by much white space and then a small strip of vbar graph followed by much white space. Can anybody help? Best wishes Eva ... View more

Re: ods pdf startpage=no; and graph

by Quartz | Level 8 in Graphics Programming
‎05-30-2012 08:05 AM
‎05-30-2012 08:05 AM
Dear all, I solved the problem now by not using ods pdf text=""; but instead title ""; Now the text and the graph are shown on the same page. pdf and graph is always a bit tricky. I use SAS 9.2 on UNIX with the SAS portal. Best wishes Eva ... View more

check whether an index is used in a data step

by Quartz | Level 8 in SAS Programming
‎03-29-2012 05:53 AM
‎03-29-2012 05:53 AM
I have a where statement in the data step like in this example: data work.myfile;      set report.xyfile;      where a = 100; run; ... View more

new data set with metadata of an existing data set?

by Onyx | Level 15 in SAS Programming
‎02-01-2012 07:22 AM
‎02-01-2012 07:22 AM
If using Datastep, you could also try: data have; name='Eva1';      sex='F1';      age='991';      height=1231;      weight=8881; run; data want; if 0 then set have; name='Eva';       sex='F';       age='99';       height=123;       weight=888;       run; Regards, Haikuo ... View more

proc report: total for computed variable

by Diamond | Level 26 in SAS Procedures
‎02-01-2012 10:55 AM
‎02-01-2012 10:55 AM
Hi,    If you know that the values in HIDDENFIELD will ALWAYS be the same, then you could use the MEAN statistic to generate the total you want without creating the MYFIELD column.   But, since you are hiding the values anyway, why not just change HIDDENFIELD in a DATA step program (or create a new variable) using FIRST. processing so you only keep the first value, then your sum will work correctly? (if you define your variable as SUM, not DISPLAY). cynthia ... View more

proc report: aggregate a computed column

by Quartz | Level 8 in SAS Procedures
‎02-01-2012 03:48 AM
‎02-01-2012 03:48 AM
Dear Haikuo, thanx for the answer and the general rule that report items cannot be retained but temporary variables. That's a godd rule to keep in mind. So when I run the example I see that the temporary variable temp1 was initialized with 0. I then thought about initializing it with another value and this is what works: compute before;      temp1 = 100; endcomp; Best wishes, Eva ... View more

Grouped Bar Graph

by Meteorite | Level 14 in Graphics Programming
‎08-25-2011 01:19 PM
‎08-25-2011 01:19 PM
When you say "grouped bar chart", I assume you're talking about bars with several different-colored segments stacked on top of each other?  Using traditional SAS/Graph, proc gbarline might do what you're wanting (assuming you have a fairly recent version, such as 9.2m3).  Or, if gbarline doesn't provide what you're needing, you could annotate a line on top of a proc gchart bar chart. Here are some various examples you might find useful: http://support.sas.com/kb/33/171.html http://robslink.com/SAS/democd30/new_92_sas.htm#gbarline and a few more fancy examples... http://robslink.com/SAS/democd36/oil_blinged.htm http://robslink.com/SAS/democd36/oil_blinged_info.htm http://robslink.com/SAS/democd33/subprime.htm http://robslink.com/SAS/democd33/subprime_info.htm http://robslink.com/SAS/democd31/shoebar.htm http://robslink.com/SAS/democd31/shoebar_info.htm ... View more

HTML multiselect values in SAS

by Pyrite | Level 9 in ODS and Base Reporting
‎06-28-2011 07:02 AM
‎06-28-2011 07:02 AM
I don't know if it will help you but we did it in an other way: %macro mvexist(mvarname); %global &mvarname wherestring; proc sql noprint; select count(*) into :mvcntval from sashelp.vmacro where name = "%upcase(&mvarname)"; quit; %if &mvcntval = 0 %then %let &mvarname=; %else %do; proc sql noprint; select count(*) into :mvcntval from sashelp.vmacro where name = "%upcase(&mvarname.0)"; quit; %if &mvcntval = 1 %then %do i = 1 %to &&&mvarname.0;     %if &i > 1 %then %let &mvarname = &&&mvarname&&&mvarname&i;   %if &i < &&&mvarname.0 %then %let &mvarname = &&&mvarname,; %end; %end; %mend; %mvexist(&sel_entity); where Entity in ("%sysfunc(tranwrd(%bquote(&sel_entity),%bquote(,),%bquote(",")))"); ... View more

Re: ods tagsets.msoffice2k and image in cell of proc report

by Quartz | Level 8 in ODS and Base Reporting
‎05-09-2011 07:07 AM
‎05-09-2011 07:07 AM
Dear all, I gave the problem to SAS tech support and the answer was: this does not work for ods tagset excel. The suggestion was to highlight the cell in green red or yellow and write a fitting text into it. I think that's a good alternative. Best regards Eva ... View more

Re: ODS PDF graph legend on next page

by Quartz | Level 8 in ODS and Base Reporting
‎03-21-2011 04:17 AM
‎03-21-2011 04:17 AM
Dear Bill, amazingly it still is 🙂 But thanx for the link. This in an interesting example and may help me in other situations! Eva Message was edited by: Eva ... View more

Re: inline style in excel output? ODS tagset

by Quartz | Level 8 in ODS and Base Reporting
‎01-31-2011 02:22 AM
‎01-31-2011 02:22 AM
Dear Cynthia, Unfortunately, there is no tagset that has everything so the programmer has to choose which fits best. The problem with the excelxp tagset was not only the font size -1 but that it didn't display anything I did with the inline style (no bold font no line break e.g.). When I use the msoffice2k tagset I don't have the options sheet_name and frozen_headers. When I use the msoffice2k_x tagset I can't use any line break. I had e.g. two title statements. Which resulted in a code with . As SAS didn't use I got the error in excel that the didn't have a closing tag. So no tagset with everything. But now I have a selection and try to choose the best tagset for my needs. Thanx a lot for the idscussion! Eva Message was edited by: Eva ... View more

Re: proc report: How to color the row I created w the compute & line s...

by Quartz | Level 8 in SAS Procedures
‎11-23-2010 05:01 AM
‎11-23-2010 05:01 AM
Dear Cynthia, thanx a lot fpr your great answer - as usual a great inspiration for accumulating knowledge 🙂 Best regards Eva ... View more

Re: proc report: split data (not header)

by Quartz | Level 8 in SAS Procedures
‎11-22-2010 07:02 AM
‎11-22-2010 07:02 AM
Dear Cynthia, thanx a lot. I wouldn't have found it without the hint to escapechar. It's amazing how much you can do with it! Best regards, Eva ... View more

Re: Drill Down in PDF

by Diamond | Level 26 in ODS and Base Reporting
‎03-02-2010 10:31 AM
‎03-02-2010 10:31 AM
Hi: You may want to work with Tech Support on this question. As far as I know, the only way to use URL= with PDF is to 1) link to an entirely separate PDF document or HTML page 2) link to an internal pointer in the same document. When you use &LT;FORM&GT; tags in HTML, you are generally executing a program (or a script) which accepts the hidden parameter values as part of the HTTP stream and then the web server performs the form action. I did not think that you could invoke an HTML <FORM> from within a PDF document in order to make the equivalent of a form action happen. So, this is why I think you have a question for Tech Support. cynthia ... View more

Re: gchart g100 percent and PDF

by Quartz | Level 8 in Graphics Programming
‎03-02-2010 10:22 AM
‎03-02-2010 10:22 AM
Dear Robert Allison, from tho look of it it could be that the bars are too narrow. I tried applying width but it didn't work until I used options papersize=a3; as well. There was simply not enough room for the graph. Seem like most pdf problems are solved with width and the like... Eva ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎03-22-2021 10:11 AM
Likes given to
Likes from
Quick links