About Recep

Sajid01 · ‎03-12-2023

@Recep On the new desktops odbc connection to sql server need to be created. The libname statements will work once that is done. Has this been done? @ocasaenva You need to configure sasenv_local. In both the above cases the best person to approach is your local SAS Administrator. They are aware of the local environment and can resolve the issue.

ketan_korde · ‎10-18-2022

Can you please explain what is happening in table want? Thank You.

StatDave · ‎09-15-2021

Yes, that's correct.

ballardw · ‎05-21-2021

If you want to use an "if/then" assignment then you make that variable a group variable in a scatter plot. Then you use either a styleattrs statement to override the color assignments or create a Dattrmap data set to set colors, markers, size, line types based on the values of the group variable. To see what a default style difference would make try this: proc sgpanel data=test2; panelby level/columns=2 novarname sort=data onepanel; rowaxis values=(0 to 15 by 5) offsetmin=.05 offsetmax=.05 grid label=" "; colaxis offsetmin=.2 offsetmax=.2 grid label=" "; scatter x=site y=cpred/yerrorupper=cupper yerrorlower=clower group=color /*<= this tells SAS to use levels of the variable color to change attributes*/ MARKERATTRS=( size=10) TRANSPARENCY=0.3 DATALABEL=cpred DATALABELPOS=right DATALABELATTRS=(color=black weight=bold size=5) colorresponse=cpred; refline obsmean; format cpred 4.1; title ' '; run;

ballardw · ‎05-13-2021

Since you apparently are trying to limit the line in the graph area you might consider adding the data points for the start and end points into the data set and add a VECTOR plot to connect the points. You'll likely want to use some options to display the resulting line segments as desired.

Recep · ‎05-04-2021

Thanks @BrunoMueller ! Simply changing the VBAR statement to VBARBASIC helped what I wanted to do. Best, Recep

ballardw · ‎05-03-2021

@Recep wrote: Thank you very much! styleattrs datacontrastcolors= (red green blue gold); option did exactly what I needed. I also realized that if VBAR statement is used in the PROC SGPLOT, instead of "datacontrastcolors=(...)", "datacolors=(...)" will do the trick. Best, Recep Part of the fun is finding out which color set goes with which display.

Recep · ‎02-26-2021

Thanks a lot! I think this explains the difference between two contradicting results: The ranked values of length of stay within each group are very similar to each other hence the insignificant Wilcoxon Rank Sum Test (i.e. Wilcoxon Mann-Whitney) results yet the medians are different enough to have a statistically significant different Median Two-Sample Test results. This shows that one should be very careful interpreting the test results! Though I still wonder what's the use of "Median Two-Sample" test? By the way I said above that I would post here SAS's response and here it is: "Hi Recep, You can find the formulas in the documentation here, if you would like to review them. Most people use the Wilcoxon rank sum test to compare the medians of two groups of data, however you may need to consult with a statistician regarding your particular analysis and input data. Sincerely, XXX SAS Technical Support "

SAS_Rob · ‎02-01-2021

If you want to combine the results from the Wilcoxon test then you will need to include BY _IMPUTATION_ in your NPAR1WAY code as was already mentioned. But you will also not be able to use MIANALYZE to combine the nonparametric test but instead will need to combine the actual Chi-Square test statistics that are generated by the Wilcoxon test. Dr. Paul Allison has a MACRO on his website called %COMBCHI that does this correctly. https://www.sas.upenn.edu/~allison/combchi.sas

StatDave · ‎01-19-2021

If you use the link I provided to the macro's documentation, you will see that the b_px values are the names the macro uses to refer to the model parameter estimates. So, the numerator expression, logistic(b_p1), computes the probability that big=1 by applying the inverse logit to the b_p1 parameter which is the intercept. Similarly for the denominator expression. The function, logistic(x), applies the inverse of the logit, 1/(1+exp(-x)).

Recep · ‎11-23-2020

Thanks a lot! I was so stuck on including an additional VBAR or GROUP= statement that I did not even think about GROUPDISPLAY! Really appreciate your help!!!

Recep · ‎08-31-2020

Thanks a lot for this Dan! I'll definitely try it. I was hoping to find a straight option but it seems like there is no one within the SGPLOT. Recep

Watts · ‎07-15-2020

You're welcome. Glad this helps.

Recep · ‎01-24-2020

Thanks a lot for all the responses! I'll look into them today and post what I find based on the recommendations. Please follow it.

Recep · ‎12-06-2019

Thanks a lot for very prompt and accurate response!

Online Status	Offline
Date Last Visited	‎03-05-2024 04:16 AM

ODBC connection for SQL

Re: Comparing two independent samples for count data

Re: Comparing two independent samples for count data

Comparing two independent samples for count data

Re: PROC SGPLOT traffic lighting

PROC SGPLOT traffic lighting

PROC SGPLOT REFLINE statement for multiple reference lines

Re: PROC SGPLOT BLOCK options

Re: PROC SGPLOT BLOCK options

PROC SGPLOT BLOCK options

Re: Comparing a row in a dataset with the next row

Re: Comparing two independent samples for count data

Re: Comparing two independent samples for count data

Re: Comparing two independent samples for count data

Re: PROC SGPLOT traffic lighting

Re: Median difference test

Re: Converting character field to date field

Re: ODBC connection for SQL

Re: How to find the second highest value in given data?

Re: Comparing two independent samples for count data

Re: PROC SGPLOT traffic lighting

Re: PROC SGPLOT REFLINE statement for multiple reference lines

Re: PROC SGPLOT BLOCK options

Re: PROC SGPLOT - changing the marker colors

Re: Median difference test

Re: Mean difference test for multiple imputed dataset

Re: How to calculate relative risks after PROC MIANALYZE step

Re: Three dimensional data bar charts

Re: PROC SGPLOT DATALABELS

Re: PROC FREQ plots

Re: Looking up a specific value in a SAS dataset

Re: Pooled Odds Ratio