About pkfamily

pkfamily · ‎01-13-2017

Thanks! Doesn't solve my original question but sure does solve my overall problem. Haha... linking back to your own article I see. How ingenious of you. The code below adds the number of observations next to each group. Oh and if you were like me and the graph failed to output due to the maximum allotted space for JAVA, you can increase the space by editing the SAS config file. More specifically, changing -xmx128m and -xms128m to a higher number. ods output sgplot=sgplotdata; proc sgplot data=testplot; hbox time/category=grp; run; data sdata; set sgplotdata; where BOX_TIME_X_GRP_SORTORDER_Inte__Y ne . and BOX_TIME_X_GRP_SORTORDER_Inte_ST = 'N'; rename BOX_TIME_X_GRP_SORTORDER_Inte_ST=stat BOX_TIME_X_GRP_SORTORDER_Inte__Y=value BOX_TIME_X_GRP_SORTORDER_Inte__X=cat; keep BOX_TIME_X_GRP_SORTORDER_Inte_ST BOX_TIME_X_GRP_SORTORDER_Inte__Y BOX_TIME_X_GRP_SORTORDER_Inte__X; run; data merged; set testplot sdata; run; proc sgplot data=merged; hbox time/category=grp; yaxistable value/y=cat class=stat; run;

pkfamily · ‎01-12-2017

Please offer me your assistance O' great internet SAS lords. My ultimate goal is to annotate the number of observations by group on a box plot. However, I am stuck for I can not even get a simple annotation to appear on my plot! My code is below along with the outputted plot. data testplot; do i=1 to 10; grp=i; time=5; output; end; run; data test_anno; length function $8; retain xsys ysys "2" hsys "3" function "label" size 1; x=5; y=5; text="testing";output; run; proc boxplot data=testplot; plot time*grp/horizontal annotate=test_anno; run;

pkfamily · ‎01-06-2017

Wow that's crazy. I didn't realize you could change variable names to literal ones. I would also like to add that variable names are still limited to 32 characters which would also limit the title length using the above method.

pkfamily · ‎01-06-2017

I sincerely hope this question has not been posted already since I do hate wasting the time of others. With that said, how do I change the Main Title in the fit plot produced by PROC GLM. For example, in the plot below, how do I change "Fit Plot for mpg" to lets say "Fit plot for Miles per Gallon". As far as I know, changing the label for the variable will not do this.

pkfamily · ‎12-20-2016

Sounds good! That gives me a idea of what keyboard macros can do!

pkfamily · ‎12-20-2016

THIS IS AWESOME!! Thank you so much. The abbreviations will be incredibily helpful and fun. What do you mean by generate keyboard macro code to insert characters though? Can you provide a small example for me?

pkfamily · ‎12-20-2016

Thanks for the response!

pkfamily · ‎12-20-2016

Thank you so much! Yes, just simply indenting the code. Sorry, the answer was so obvious. How would you store the code for later recall though?

pkfamily · ‎12-20-2016

Hello all! Is there a way to tab a selected block of code? For Example, I want this: Data temp; do i =1 to 10; if i=2;then j=5; else if i =3 then j=1; else j=3; end;run; to be this in one keyboard command after selecting the code: Data temp; do i =1 to 10; if i=2;then j=5; else if i =3 then j=1; else j=3; end;run; Thank you! And sorry if this question has already been posted. And if you know the answer, can you also tell me how to go backwards? -Victor

pkfamily · ‎12-05-2016

Okie Dokie! Thanks for your answer! I will continue contributing until my next anticipated boost in rank.

pkfamily · ‎12-05-2016

Thanks for your input! I'm just curious how far the rabbit hole goes. Also surprised that a list is not posted somewhere.

pkfamily · ‎12-02-2016

Regarding this very website, does anyone have a list for the different ranks and what pre-requesites are necessary to reach them? For example, I am currently "Occasional Contributor" and was wondering what the next rank would be. This is obviously a very low priority question haha. Thanks and Happy Holidays, -Victor

pkfamily · ‎12-02-2016

What an elegant answer! However, the proc sql portion is a bit confusing for me. I will have to put aside some time to truly understand the code. Thank you for your answer. -Victor

pkfamily · ‎11-23-2016

Adding a space in ''='Missing' did the trick! This is bit disconcerting, since I have always been using '' and not ' ' when denoting missing values for character variables.... Thanks again though!

pkfamily · ‎11-23-2016

Thank you! And I do appreciate the long answer. However, I do have a tiny qualm. When setting the format as: proc format;value $racef '10'='White' ''='Missing' other = 'Other';run; I still get: Frequency Missing = 9 WHITE: 66 100.00 66 100.00 Under your explanation, why would 'Other' still be assigned a value of missing?

Online Status	Offline
Date Last Visited	‎02-20-2019 01:46 PM

Re: Why are the transformations for restricted cubic splines the same ...

Why are the transformations for restricted cubic splines the same rega...

Re: ODS EXCEL: Removing Borders when Outputting LOG

Re: SGPLOT: How do I remove the auto title from by line statement

ODS EXCEL: Removing Borders when Outputting LOG

Proc surveyreg giving different results when switching the order of st...

Re: Proc GAM: Using Weights

Proc GAM: Using Weights

Re: Multiple Pairwise T-test Comparisons against a reference group

Multiple Pairwise T-test Comparisons against a reference group

Re: Why are the transformations for restricted cubic splines the same ...

Re: ODS EXCEL: Removing Borders when Outputting LOG

Re: Generate template SAS code with comments

SGPLOT: How do I remove the auto title from by line statement

Re: SGPLOT: How do I remove the auto title from by line statement

Proc surveyreg giving different results when switching the order of st...

Re: Multiple Pairwise T-test Comparisons against a reference group

Re: What are the ranks for communities.sas.com and how many posts do y...

What are the ranks for communities.sas.com and how many posts do you n...

Re: Simple Annotation on Proc Boxplot

Simple Annotation on Proc Boxplot

Re: Changing Main Title for Fit Plot in Proc GLM

Changing Main Title for Fit Plot in Proc GLM

Re: SAS 9.4 Tab Shortcut

Re: SAS 9.4 Tab Shortcut

Re: SAS 9.4 Tab Shortcut

Re: SAS 9.4 Tab Shortcut

SAS 9.4 Tab Shortcut

Re: What are the ranks for communities.sas.com and how many posts do y...

Re: What are the ranks for communities.sas.com and how many posts do y...

What are the ranks for communities.sas.com and how many posts do you n...

Re: Proc transpose

Re: Proc Freq showing up as Missing when Format is Specified as "Other...

Re: Proc Freq showing up as Missing when Format is Specified as "Other...