About BrunoMueller

BrunoMueller · ‎08-15-2017

Hi Also have a look at the VA Admin Guide http://support.sas.com/documentation/onlinedoc/va/7.3/en/vaag.pdf on page 121 it gives you more information about predefined admin reports and how to switch on the data collection.

BrunoMueller · ‎08-11-2017

Hi Not long ago we had our national day in Switzerland on 1st of August. So here is my contribution of the Swiss flag. All is drawn using the POLYGON statement to get best control. Enjoy. /* * sample to draw the swiss flag * dimension information taken from * * Bundesgesetz über den Schutz des Schweizerwappens und anderer öffentlicher Zeichen * (Wappenschutzgesetz, WSchG) * * https://www.admin.ch/opc/de/official-compilation/2015/3679.pdf * */ data ch_flag; length id $ 16; /* polgon for red square */ id = "redBG"; sideLen = 1; x = 0; y = 0; output; x = 0; y = sideLen; output; x = sideLen; y = sideLen; output; x = sideLen; y = 0; output; /* polygon for whitecross */ id = "whiteCross"; /* * determine the sidelength of inner square * numbers represent the length of the 5 parts * */ b = (sideLen / (6+7+6+7+6)) * 6; /* center point where all the other measures are based */ sideLen_2 = sideLen / 2; /* offset from center point for inner square */ b_2 = b / 2; /* length of the arms */ b_plus_b16 = b + (b *(1/6)); /* just as a check for the ratio */ arm = b + (2 * b_plus_b16); /* * layout of the white cross * 6--7 * ! ! * 4--5 8--9 * ! ! * 3--2 11-10 * ! ! * 1--12 */ /* point 1 */ x = sideLen_2 - b_2; y = sideLen_2 - b_2 - b_plus_b16; output; /* point 2 */ x = sideLen_2 - b_2; y = sideLen_2 - b_2; output; /* point 3 */ x = sideLen_2 - b_2 - b_plus_b16; y = sideLen_2 - b_2; output; /* point 4 */ x = sideLen_2 - b_2 - b_plus_b16; y = sideLen_2 + b_2; output; /* point 5 */ x = sideLen_2 - b_2; y = sideLen_2 + b_2; output; /* point 6 */ x = sideLen_2 - b_2; y = sideLen_2 + b_2 + b_plus_b16; output; /* point 7 */ x = sideLen_2 + b_2; y = sideLen_2 + b_2 + b_plus_b16; output; /* point 8 */ x = sideLen_2 + b_2; y = sideLen_2 + b_2; output; /* point 9 */ x = sideLen_2 + b_2 + b_plus_b16; y = sideLen_2 + b_2; output; /* point 10 */ x = sideLen_2 + b_2 + b_plus_b16; y = sideLen_2 - b_2; output; /* point 11 */ x = sideLen_2 + b_2; y = sideLen_2 - b_2; output; /* point 12 */ x = sideLen_2 + b_2; y = sideLen_2 - b_2 - b_plus_b16; output; run; ods graphics / reset=all; ods graphics / width=800 height=800 noborder ; proc sgplot data=ch_flag aspect=1 pad=0 noborder noautolegend ; styleattrs dataColors=( cxff0000 cxffffff) ; polygon x=x y=y id=id / group=id fill; xaxis display=none offsetmin=0 offsetmax=0; yaxis display=none offsetmin=0 offsetmax=0; run; Here is the result:

BrunoMueller · ‎08-08-2017

See code sample below, you can control this in the DEFINE statement proc report data=sashelp.class; column name age sex; define age / style(header)={background=red}; define sex / style(header)={background=yellow} style(column)={background=grey foreground=blue} ; run;

BrunoMueller · ‎08-04-2017

Hi Change your YAXIS statement like so: yaxis label="Frequency, bins=%scan(&number_of_bins,&j)";

BrunoMueller · ‎07-05-2017

Using this code you can get the Y axis to display in percent, I do not know of a way to display the label at the top of the bar. proc sgplot data=sashelp.class; histogram age / scale=proportion datalabel=percent; yaxis display=(nolabel) valuesformat=percent9.2; run;

BrunoMueller · ‎07-05-2017

The ineffciency comes from reading the same data for each of your if statements. You should code it like this: %macro test; data step; set step; %do i=1 %to &count %by 1; &macro&i; %end; run; %mend; %test In this way the macro will generate all the IF statements in one DATA Step and the data is only red once. Bruno

BrunoMueller · ‎06-29-2017

you test for Wilma whereas your data is wilma

BrunoMueller · ‎06-29-2017

Add the NAME= option to your plot statements, then in the KEYLEGEND statement you can say for which plot statements you would like to have a legend. Sample: proc sgplot data=highlow; highlow y=patient low=low high=high / type=bar group=type name="hl"; text y=patient x=labelPoint text=labelValue / position=center name="txt"; yaxis type=discrete fitpolicy=splitalways; keylegend "hl" / position=top down=1 ; run; The placement might have something to do with space that is available, try to make your graph bigger.

BrunoMueller · ‎06-29-2017

I suggest to use the HIGHLOW plot statement, you have to prepare the data accordingly. See below for an example, that gives you some ideas: data highlow; infile cards dlm="," dsd missover; input patient : $32. low high type $ labelPoint labelValue $ ; cards; patient1 someDate,0,20,hospital,10,20 patient1 someDate,20,40,ward,, patient1 someDate,40,50,hospital,, patient1 someDate,50,52,home,, patient1 someDate,52,55,ward,53.5,abc patient2 01jan2010-25sep2010,0,25,hospital,, patient2 01jan2010-25sep2010,25,45,home,, patient2 01jan2010-25sep2010,45,46,ward,, ; proc sgplot data=highlow; highlow y=patient low=low high=high / type=bar group=type; text y=patient x=labelPoint text=labelValue / position=center; yaxis type=discrete fitpolicy=splitalways; run;

BrunoMueller · ‎06-23-2017

Have a look here http://support.sas.com/kb/38/339.html You need to create the transport file using SAS9.4 32bit version

BrunoMueller · ‎06-23-2017

Yes these are the steps create new custom graph add bar chart, set grouping style to stacked add line chart, set y axis to be on the right save use in the report, set grouping scale accordingly

BrunoMueller · ‎06-23-2017

Bar charts support more than one measure by default. so there is no need to add another measure. The grouping scale "normalize groups to 100%" can be set once you use your custom graph. Should it look like this?

BrunoMueller · ‎06-21-2017

You do need the proper password for: uid: sasadm@saspw pw: <you need to know the password> Otherwise this will never work. Are you using the GUI tool http://yourServer:yourPort/SASBackupManager/BackupManager.jsp or the command line tool sas-backup?

BrunoMueller · ‎06-21-2017

An ad-hoc backup should be run by the "SAS Administrator" account. So that you have access to the credentials.

BrunoMueller · ‎06-21-2017

How about using the the LINK=option. then you have two different strings and it is easier to manage. See sample below. title link="https://communities.sas.com" "Here we go"; proc sgplot data=sashelp.cars; vbar type; run;

Online Status	Offline
Date Last Visited	4 weeks ago