About _LB

_LB · ‎09-20-2011

Sanjay- I am using 9.2 ver 3 and for now I will keep as is! Thanks again for all your help! Lawrence

_LB · ‎09-20-2011

That is what I ended up doing. Of course I found something called legend item that could be an image perhaps? The number of options is both a blessing and a curse! Lawrence

_LB · ‎09-20-2011

Sanjay- Thanks for the guidance. No code is needed. Have a great Tuesday! ~Lawrence

_LB · ‎09-19-2011

Sanjay- OK I have made a lot of progress as you can see below from the code that you gave me. There are two finishing touches that I am trying to make but I cannot find the answers anywhere online. 1) I am attempting to shift the order of the Occupational titles so that RN's come first. However, no matter if I switch the order in the data set or set the RN's first in the proc template statement does the order change. 2) AS you see below I managed to make red circles around the yellow by adding a second scatterplot code accordingly. scatterplot x=date y=P /skin=modern markerattrs=(symbol=circlefilled size=30 color=yellow) name="Overall" legendlabel="Overall"; scatterplot x=date y=P /skin=modern markerattrs=(symbol=circle size=31 color=red) ; However, I can't mimic it in the legend. I attempted to use endcolor but that does not work. Full code follows below-Any advice greatly appreciated. Thanks, Lawrence proc template; define statgraph BarLineMulti; begingraph; entrytitle halign=left TEXTATTRS=(color=blue size=16pt) "14L" ; layout overlay / xaxisopts=(display=(line ticks tickvalues )) cycleattrs=true yaxisopts=(LABEL=('COMPLIANCE RATE') griddisplay=on linearopts=(tickvaluesequence=(start=0 end=1 increment=.1))) ; barchart x=date y=RNG / skin=modern FILLATTRS =(color=STPK) discreteoffset=-0.1 barwidth=0.2 name="RN" legendlabel="RN"; barchart x=date y=MDG /skin=modern FILLATTRS =(color=LIPGR) discreteoffset=-0.3 barwidth=0.2 NAME="MD/NP/PA (Provider)" legendlabel="MD/NP/PA (Provider)"; barchart x=date y=RTG /skin=modern FILLATTRS =(color=BIBG) discreteoffset= 0.1 barwidth=0.2 name="RT" legendlabel="RT"; barchart x=date y=OTHERS /skin=modern FILLATTRS =(color=BIO) discreteoffset= 0.3 barwidth=0.2 name='OTHERS'; seriesplot x=date y=p / lineattrs=graphdatadefault(thickness=3 color=red) ; ReferenceLine y=.85 / clip=true Lineattrs=( Pattern=solid thickness=4 color=blue) name="IAP GOAL 85%" legendlabel="IAP GOAL 85%"; scatterplot x=date y=P /skin=modern markerattrs=(symbol=circlefilled size=30 color=yellow endcolor=red) name="Overall" legendlabel="Overall"; *scatterplot x=date y=P /skin=modern markerattrs=(symbol=circle size=31 color=red) ; scatterplot x=date y=P / markercharacter=p discreteoffset= -0.1 markercharacterattrs=(color=red weight=bold); discretelegend "MD/NP/PA (Provider)" "RN" "RT" 'OTHERS' "Overall" "IAP GOAL 85%" / title="Occupational Titles:" location=outside halign=right valign=bottom; endlayout; endgraph; end; run;

_LB · ‎09-14-2011

Rob & Sanjay- Thank you both for your very helpful answers! Different approaches that help immensely for different purposes. I will go back Rob and take a look at the last example. Best, Lawrence

_LB · ‎09-13-2011

Robert, OK so I am stuck as I get errors including the anno statement as I am attempting to "group". Some of the data looks accordingly: ROLE fixdate comply compliance 01) RN Sep-10 0.592 0.493007 02) MD/NP/PA (Provider) Sep-10 0.691176 0.493007 OTHERS Sep-10 0.215054 0.493007 01) RN Oct-10 0.724638 0.567901 02) MD/NP/PA (Provider) Oct-10 0.465517 0.567901 03) Respiratory Therapist (RT) Oct-10 1 0.567901 OTHERS Oct-10 0.411765 0.567901 01) RN Nov-10 0.611765 0.568182 02) MD/NP/PA (Provider) Nov-10 0.555556 0.568182 OTHERS Nov-10 0.509091 0.568182 Where the compliance value is the overall value for the month (fixdate). The anno statement is: data anno; length function color $ 8 text $ 10; retain xsys ysys '2' when 'a'; set totals2 end=last; by fixdate; if _n_ = 1 then function='move'; else function='draw'; xsys='2'; ysys='2'; x=fixdate; y=compliance; size=2;color='yellow'; output; function='symbol'; xsys='2'; ysys='2'; x=fixdate; y=compliance; text='dot'; size=8; color='yellow'; output; run; So I am attempting to group by using a BY statement per what I am reading online. Then I go back to the proc gchart statement: /* Generate the graph */ proc gchart data=total3; vbar ROLE/ subgroup=ROLE group=fixdate anno=anno sumvar=comply legend=legend1 space=0 gspace=1 maxis=axis1 raxis=axis2 gaxis=axis3; run; quit; Where I run into a problem. I will attempt to reverse engineer the examples. Thanks again. Lawrence

_LB · ‎09-13-2011

Thanks Robert. I was wondering about that as I ran into some issues on missing "groups". I get: NOTE: PROBLEM IN OBSERVATION 1 - CANNOT HAVE MISSING GROUP VALUE IF GROUPS ARE PRESENT I wish I could do simple...that does not happen here as you can proably understand. I find another example that I could set the size of the text. IS there also a way to insert a value? Thanks for your help thus far. It helps. Lawrence

_LB · ‎09-13-2011

Hello all! I must certainly say that I like the new discussion forum capabilities! At any rate, here goes my questions- The chart to the left is produced by Excel. The one on the right is produced by SAS. Question 1) The Excel graph It has a 2 tone schematic that gives some "depth". I am attempting to mimick that in the graph to the right. Question 2) How I can incorporate a line graph that would be similar to the the one below that puts the numbers in red in a big yellow bubble. The code is below. Fairly simple. I took it from one of the SAS websites. Any suggestions greatly appreciated. This is what management wants so I must oblige. Titles, legends, and ref lines are no problem for me. goptions reset=all cback=white border htitle=12pt htext=10pt; /* Define the title */ title1 " Compliance"; /* Define the axis characteristics */ axis1 value=none label=none; axis2 label=(angle=90 "Compliance"); axis3 label=none; /* Define the legend options */ legend1 frame; /* Generate the graph */ proc gchart data=L14; vbar ROLE/ subgroup=ROLE group=fixdate sumvar=comply legend=legend1 space=0 gspace=1 maxis=axis1 raxis=axis2 gaxis=axis3; run; quit; Thank you. Lawrence

_LB · ‎09-08-2011

Art, In the case, the data set isn't that big but duly noted on larger data sets in the future. Thank you. Lawrence

_LB · ‎09-08-2011

Hobbes- I had to modify the query a tiny bit for the outcome but it works! Thank you! Lawrence

_LB · ‎09-07-2011

To Art & Reeza- Thanks for your helpful answers. @Reeza-I am well acquainted with proc means but was looking for an answer in SQL, which I believe there is none that is suitable at the moment. Proc Means it is! Lawrence

_LB · ‎09-07-2011

Hello all, Is there a easy way to get totals by sub-group and a total overall in the same column? So that for example in the code below- proc sql; create table numbers as select A.MRSA_CLASS, put(sum(com)/count(*), percent10.) as compliance,put(sum(TEST)/count(*), percent10.) as TESTED, from MRSA_ADM_ARR as a group by A.MRSA_CLASS; quit; I will get CLASS Compliance Tested A 75% 90% B 55% 65% ... .. .. Z 80% 90% What I would like is the above but also a grand total at the bottom without necessarily doing the code twice, one with grouping, one without. Thank you again for your time. Best, Lawrence

_LB · ‎09-02-2011

Thanks Hobbes! Worked beautifully!

_LB · ‎09-02-2011

Hello all, I have, what I think is a simple of piece of code that I am asking for a simple date subsititution during a case statement. In essence, if the main date (DISCHDT) field is blank it goes to another table (DISCHARGE_DATE_ACTUAL) and retrieves from there. If that is blank, then I want today's date- Code is: CASE WHEN A.DischDt NE . THEN A.DischDt WHEN A.DischDt=. THEN DATEPART(DIS.DISCHARGE_DATE_ACTUAL) ELSE TODAY() end as discharge format MMDDYY10. The problem is that it will not substitute today's date when both fields are blank. I have tried different variations to no effect. Any help grateful. Thanks & have a great labor day. ~LB

_LB · ‎08-29-2011

Very elegant, Thank you!

Online Status	Offline
Date Last Visited	‎09-01-2015 07:11 AM

proc shewhart, coverlay functionality in ods, and headers

vref, ods, termplate language

vref, ods, termplate language

proc shewhart, coverlay functionality in ods, and headers

proc shewhart, coverlay functionality in ods, and headers

proc shewhart, coverlay functionality in ods, and headers

proc shewhart, coverlay functionality in ods, and headers

PROC SQL & DELETE

PROC SQL & DELETE

PROC SQL & DELETE

vbar graphs (that are not stacked) in sgplot

Re: How to read data from the SharePoint

proc gchart, vbar, fill/3d options + line chart

proc gchart, vbar, fill/3d options + line chart

proc gchart, vbar, fill/3d options + line chart

proc gchart, vbar, fill/3d options + line chart

proc gchart, vbar, fill/3d options + line chart

proc gchart, vbar, fill/3d options + line chart

proc gchart, vbar, fill/3d options + line chart

proc gchart, vbar, fill/3d options + line chart

PROC SQL, group by & total

PROC SQL, group by & total

PROC SQL, group by & total

PROC SQL, group by & total

proc sql, case statement w/ today() date substitution

proc sql, case statement w/ today() date substitution

retain statement