Please correct me if I miss something because just right now the example is a typical example showing how graph can make the user mad.
In the example two formats are used; one is assigned to the variable using the format statement ; the other one is set using the option tickvalueformat.
My original thought was that tickvalueformat would have priority over the variable format to set the tickvalues and that the variable format would be used to set the order of the bars.
However, in this example, we can see that the tick values are coming from the format assigned to the variable, but the format width is coming from the format given in the tickvalueformat option. As the default format label with of the sex format is 6, tick values are truncated.
proc format;
value $sex 'M'='Male'
'F'='Female';
value $sexnum 'M'='1-Male'
'F'='2-Female';
run;
proc sgplot data=sashelp.class noborder;
vbarbasic sex;
xaxis discreteorder=formatted tickvalueformat=$sex.;
format sex $sexnum.;
run;
proc sgplot data=sashelp.class noborder;
vbarbasic sex;
xaxis discreteorder=formatted tickvalueformat=$sex20.;
format sex $sexnum.;
run;
... View more
Hi, I just had a request a Waterfall plot from my internal client that he wants to use solid colors for the first five groups but 2 groups with color and pattern. I tried to use Discrete Attribute Map data but I don't think fillpattern variable is available although I am not getting any SAS error message. If fillpattern works in the data, that will be great. Then, I tried styleattrs statement with datafillpatterns option. The main problem is that there is no option "not to put any pattern". For the good old SAS/Graph, pattern statement had two options as 'E' and 'S' but the 15 values for datafillpatterns do not include any null value. I tried datafillpatterns=(' ' ' ' ' ' X1 X1 R1 L1) but I got syntax error. Is there any way to indicate "blank" value to datafillpatterns option? I know one more method would be proc template but I haven't tried yet. Any idea? Thank you in advance. Raymond
... View more
Proc export giving additional quotes to the quoted char values.and if u use data step for that it is giving a space or . To numeric values which is not required . Needs to change nothing.now it is , , but want ,, no space no .for missing numeric value.
... View more
Can someone please explain difference between bquote and str in sas with a working example.I am aware of theoretical difference between them.
But ,I want to understand with example which shows why str can't be used in place of bquote
... View more
I have a data file describing users (ID), time periode a service is in use (FromYrMon-ToYrMon) and hours of services (hours). There are two problems. First, the time periods partly overlap. There are also some gaps between the time periods but that is probably correct. Second, the hours of services are not consistently coded in the sense that the same time period (or parts of it) may have differences in hours. The file I want, includes for each ID, one observation per month, the maximum of hours for that month and 0 for months where there are gaps between time periods. I guess the solution will be something like 1) transposing, 2) fill in gaps and 3) pick the highest number of hours for each month.
data have;
input ID FromYrMon YYMMN6 ToYrMon YYMMN6. Hours comma4.2;
datalines;
1 201701 201711 0.75
1 201704 201711 1.20 1 201801 201802 4.00 2 201710 201802 2.00 ; Data want; ID YYMon Hours 1 201701 0.75 1 201702 0.75 1 201703 0.75 1 201704 1.20 1 201705 1.20 1 201706 1.20 1 201707 1.20 1 201708 1.20 1 201709 1.20 1 201710 1.20 1 201711 1.20 1 201712 0.00 (NB) 1 201801 4.00 1 201802 4.00 2 201701 0.00 2 201702 0.00 2 201703 0.00 2 201704 0.00 2 201705 0.00 2 201706 0.00 2 201707 0.00 2 201708 0.00 2 201709 0.00 2 201710 2.00 2 201711 2.00 2 201712 2.00 2 201801 2.00 2 201802 2.00
... View more