SAS Support Communities

Ram,   A few amendments marked in red to match your specification:   data x; infile datalines truncover; length sname1 sname2 $7. sname $15.; input sname1 sname2 AGM LL UL ns2 na2; format AGM LL UL f5.1; if sname1 ne '-' then sname = strip(sname1) || ' ' || strip(sname2); datalines; SCOT: Males 233.1 182.9 297.1 13 13 SCOT: Females 241.3 189.1 307.9 12 12 SCOT: NHW 218.4 170.8 279.4 11 11 SCOT: NHB 294.1 232.8 371.5 10 10 SCOT: HISP 217.9 167.0 284.3 9 9 SCOT: OTH 226.1 174.2 293.4 8 8 - - . . . 7 7 NNAL: Males 258.0 162.1 410.7 6 6 NNAL: Females 360.5 226.7 573.3 5 5 NNAL: NHW 334.9 214.9 522.0 4 4 NNAL: NHB 258.5 157.0 425.5 3 3 NNAL: HISP 324.1 202.9 517.8 2 2 NNAL: OTH 308.3 189.9 500.6 1 1 ; run; options missing = ' '; title 'Adjusted Geometric Means with 95% Confidence Intervals'; proc sgplot data=x noautolegend nocycleattrs; refline 150 600 / axis=x; highlow y=ns2 low=ll high=ul / type=bar intervalbarwidth=.05in nooutline fillattrs=graphdata1 (color=Green); scatter y=ns2 x=agm / markerattrs=graphdata2 (symbol=circlefilled size=15 color=black); yaxistable sname / y=ns2 position=left location=outside nolabel valuejustify=left pad=(right=0px) labelattrs=(weight=bold) valueattrs = (weight=bold) ; yaxistable agm LL UL / y=nS2 position=right location=inside labelhalign=center labelattrs=(weight=bold) valueattrs = (weight=bold) pad=(left=20px right=10px); yaxis display=none offsetmin=0.1 offsetmax=0.05 values=(1 to 13); run; Does that work for you now?................Phil   PS. BTW you don't use na2 anywhere in this program! ... View more

Ram,   Sometimes in life "size matters", but in ODS Graphics "order matters"!   The following code has been updated to: split sname into 2 parts, so that your input statement reads the data you expect reorder scatter after highlow, so the scatter is plotted after highlow (and on top of it!) data x; length sname1 sname2 $7. sname $15.; input sname1 sname2 AGM LL UL ns2 na2; format AGM LL UL f5.1; sname = strip(sname1) || ' ' || strip(sname2); datalines; SCOT: Males 233.1 182.9 297.1 12 12 SCOT: Females 241.3 189.1 307.9 11 11 SCOT: NHW 218.4 170.8 279.4 10 10 SCOT: NHB 294.1 232.8 371.5 9 9 SCOT: HISP 217.9 167.0 284.3 8 8 SCOT: OTH 226.1 174.2 293.4 7 7 NNAL: Males 258.0 162.1 410.7 6 6 NNAL: Females 360.5 226.7 573.3 5 5 NNAL: NHW 334.9 214.9 522.0 4 4 NNAL: NHB 258.5 157.0 425.5 3 3 NNAL: HISP 324.1 202.9 517.8 2 2 NNAL: OTH 308.3 189.9 500.6 1 1 ; run; title 'Adjusted Geometric Means with 95% Confidence Intervals'; proc sgplot data=x noautolegend nocycleattrs; refline 150 600 / axis=x; highlow y=ns2 low=ll high=ul / type=bar intervalbarwidth=.05in nooutline fillattrs=graphdata1 (color=Green); scatter y=ns2 x=agm / markerattrs=graphdata2 (symbol=circlefilled size=15 color=black); yaxistable sname / y=ns2 position=left location=outside nolabel valuejustify=left pad=(right=0px) labelattrs=(weight=bold); yaxistable agm LL UL / y=nS2 position=right location=inside labelhalign=center labelattrs=(weight=bold) pad=(left=20px right=10px); yaxis display=none offsetmin=0.1 offsetmax=0.05 values=(1 to 12); run; Enjoy!................Phil   PS. Look for "Philip R Holland" on Amazon - you may enjoy that too!   ... View more

@Cynthia_sas wrote: Starting with SAS 9.3, you can use:     ods pdf file='xxx.pdf' gtitle gfootnote;   Cynthia,   Can we use GTITLE and GFOOTNOTE with ODS LISTING, as I'd like to be able to force titles and footnotes into free-standing PNG files too?   ...........Phil   ... View more

Please can the drinks be served in tea cups to maintain the "speakeasy" theme? ... View more

Lainie, I'm hoping to be at the Online Community meetup again this year. Lots of things happened in 2015, and there could be a few surprises! Don't miss the Tweetup on the Monday evening with the folks from Metacoda. Probably the best place to be to kickstart your SASGF networking too! ............Phil ... View more

Anna, If you count my short presentation (probably only 1 slide, but a bit more talking) about the SAS Professional Forum group on LinkedIn at the Online Communities Linkup, I'll be presenting 4 times in Dallas.  While I'm at the Online Communities Linkup I may talk a bit about the sasCommunity group on LinkedIn too, as I've just joined the group management team there.  I will be talking to Lainie Hoverstad about this during SASGF anyway. In case you're interested in seeing me talk about something other than LinkedIn, my 3 other presentations will be: Converting Annotate to ODS Graphics. Is It Possible? [Room 147 at 3pm on Monday] How Do You Use Look-up Tables? [Room 146 at 4pm on Monday] SAS® Enterprise Guide or SAS® Studio: Which is Best for You? [Ballroom C3 at 9am on Wednesday] I've only missed one SAS Global Forum, since it changed from being called SUGI, and each year I meet up with old friends from previous SASGFs and then make new friends too.  I like the idea of the SAS Photo Booth, so you will see me there! My only regret this year is that I'll miss the #SASGF15 #Tweetup, because my flight from the UK lands too late on Saturday evening. Looking forward to meeting everyone in Dallas....................Phil ... View more

dcampb, As Peter has mentioned, there are not many SAS file conversions that I can't cope with.  See http://www.hollandnumerics.com for my contact details, if you are interested. .......Phil Holland ... View more

Tim, I'm also getting an odd error message when I try to use a tagset with an associated package: ERROR: Unknown BOOL attribute: QUIET. .............Phil ... View more

Tim, I think I understand the FILE= parameter now, but how do you send XML into a zipped file that is not in the zip archive base folder, eg. META-INF/manifest.xml? I can write to files in the default folder which are cleared after writing to the zip file, but I need to create another file in a different folder inside the zip archive file.  Do you need to specify it in DEFINE PACKAGE? .........Phil PS. I'm struggling to find any documentation for TAGSET and PACKAGE together! ... View more

Tim, I searched for htmltags.tpl on support.sas.com, and also looked in my SAS 9.4 installation, but couldn't find this template.  Do you have a link to where I can download it, or should I just wait for my 9.4M1 download and installation to complete first? .........Phil ... View more