About Recep

Recep · ‎03-08-2023

Hello all, We recently changed our PCs in my organization and now I'm having trouble connecting to our SQL server which was not an issue before the change. Before I used to use to create the libname as follow: libname bctr odbc datasrc=SPAPPBCTS001 schema=bctr;run; This code now gives me the following error: ERROR: CLI error trying to establish connection: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified ERROR: Error in the LIBNAME statement. Based on a quick Google search I found the following code to set up the initial connection: Libname BCTR ODBC NoPrompt="Driver=SQL Server; Server=10.251.185.25; Database=EDW; schema=bctr"; (I changed the parameters to fit into my environment). Even though the code above creates the libname BCTR it does not make a connection to the server hence the libname is empty. I would appreciate any suggestion. Thanks a lot in advance! Recep PS: I already have the SQL server driver file (SQLSRV32.DLL) in my new machine.

Recep · ‎09-15-2021

Thanks a lot Dave! Then I'm assuming that the p-value (0.5548 in this example) will tell if the two cities are statistically significantly different from each other (or more technically, in this example, we have no reason to reject the null hypothesis which assumes there is no difference between two cities).

Recep · ‎09-14-2021

Hi Reeza, Thanks a lot for your response but as I mentioned in my question I do not have any sort of denominator information. The example I provided was fictitious. You can assume instead of number of accidents those are the number of meteorites that fell into each city from the sky and I want to know if one city has more meteorites fallen than the other one. Cheers....

Recep · ‎09-14-2021

Hello, I'm trying to figure out what test would be appropriate to compare two independent samples for count data: data test; input year city1 city2; datalines; 2016 220 130 2017 140 180 2018 120 202 2019 140 134 2020 135 166 ; I don't have any denominators for the cities by year (for instance the frequencies in the city1 and city2 represent number of traffic accidents for each year). If I want to test if the number of traffic accidents differ by the cities what test I can use? Thanks a lot in advance!

Recep · ‎05-21-2021

Thanks @ballardw ! Your solution seems like creating static precalculated ranges in the previous data step. I tried to calculate the color responses I want in a previous data step (please see the example below) yet I'm not getting exactly what I need (though I fully acknowledge that I did not replicate your data step in your proposed solution). Note the if/then statement in the second data step. Basically I was hoping that, based on the if/then statement, QC and AB in panel "1&2" would be colored green (because cupper<obsmean) and QC in panel "3" would be colored red (because clower>obsmean). data test1; input level $ obsmean site $ cpred clower cupper; datalines; 1&2 11.2716763 AB 11.2091 10.2363 12.2633 3 9.648187633 AB 6.7446 5.4658 8.2922 1&2 11.2716763 BC 10.953 10.0474 11.9304 3 9.648187633 BC 8.4634 7.2455 9.86 1&2 11.2716763 NB 12.8006 10.4527 15.6237 1&2 11.2716763 ON 12.2879 10.6616 14.1237 1&2 11.2716763 QC 9.1078 8.3792 9.8939 3 9.648187633 QC 13.7365 12.3518 15.2589 ; run; data test2; length color $5.; set test1; if clower>obsmean then color='red'; if cupper<obsmean then color='green'; run; 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 MARKERATTRS=(symbol=squarefilled color=black 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;

Recep · ‎05-21-2021

Hello all, I was wondering if there is any capacity within PROC SGPLOT for traffic lighting (i.e. for instance certain points in a SCATTER plot will be colored red if they fall within a certain range otherwise they will be green, etc.)? I searched this online and could not find out anything solid. I know that PROC REPORT has traffic lighting options but I prefer to stick to PROC SGPLOT as it may take some time for me to figure out how to produce figures with PROC REPORT if that's even possible. If you can direct me to a source if traffic lighting is possible within PROC SGPLOT, I would really appreciate it. Thanks in advance! Recep

Recep · ‎05-13-2021

Hello all, I'm trying to put reference lines into a figure that I would like to produce. The sample data and code below produces two reference lines through the complete x-axis (i.e. starting at y=0 for both reference lines for each block) whereas I want to have one reference line for the "Level1" block that starts at y=0 and ends at the end of the block, and another refence line that starts where the "Level 2" block starts (instead of starting at y=0). Is there any way to accomplish this within the PROC SGPLOT? I know that I can accomplish it if I was using PROC SGPANEL but that procedure creates other issues for me hence I want to stick to PROC SGPLOT. Thanks a lot in advance! data test; input site $ city $ level $ obsmean cpred_final clower_final cupper_final; datalines; AB01 AB Level1 11.2716763 11.36606424 10.1001246 12.77349086 AB02 AB Level1 11.2716763 11.70074585 9.901032398 13.79140514 AB03 AB Level1 11.2716763 10.13968107 8.807718178 11.64910875 BC01 BC Level1 11.2716763 13.98765486 11.41248954 17.03470972 BC02 BC Level1 11.2716763 11.16346301 9.725727975 12.78818917 BC03 BC Level1 11.2716763 10.86537285 8.718797682 13.47623528 BC04 BC Level1 11.2716763 9.144506109 8.013572333 10.41066547 BC05 BC Level1 11.2716763 11.90861324 10.16280247 13.90909326 AB04 AB Level2 9.648187633 5.8868717 3.90289612 8.808718252 AB05 AB Level2 9.648187633 6.094263969 4.292064865 8.604182751 AB06 AB Level2 9.648187633 6.991179045 5.120179622 9.493934609 AB07 AB Level2 9.648187633 7.147464451 5.034721041 10.07672303 AB08 AB Level2 9.648187633 6.522514246 4.807970317 8.787388707 BC06 BC Level2 9.648187633 7.830914636 6.034632868 10.11549577 BC07 BC Level2 9.648187633 8.007776457 6.261879722 10.15813104 BC08 BC Level2 9.648187633 9.2036592 6.975207878 12.06377729 BC09 BC Level2 9.648187633 8.544482107 6.216079509 11.66857708 BC10 BC Level2 9.648187633 8.565949206 6.322877926 11.53859169 ; run; proc sgplot data=test NOAUTOLEGEND; block x=site block=level/filltype=alternate fillattrs=GraphAltBlock altfillattrs=GraphBlock transparency=0.7; scatter x=site y=cpred_final/yerrorupper=cupper_final yerrorlower=clower_final MARKERATTRS=(symbol=squarefilled color=black size=5) TRANSPARENCY=0.3 group=city; xaxis grid label="Site" valuesrotate=vertical; yaxis values=(0 to 20 by 5) grid label="Rate (%)" discreteorder=data; refline obsmean; format cpred_final 4.1; title ' '; run;

Recep · ‎05-04-2021

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

Recep · ‎05-03-2021

Thanks @Reeza ! I'm trying to replicate the BLOCK option in the first SGPLOT example with SCATTER in the second example with VBAR. If you run the examples you can see that hospitals are grouped by their "Levels" in the SGPLOT with SCATTER but not with the VBAR.

Recep · ‎05-03-2021

Hello all, Can I use the "BLOCK" option with VBAR statement in PROC SGPLOT? The example below shows that it works with SCATTER but I could not make it work with VBAR? Thanks a lot in advance! Recep DATA test; INPUT Hospital $ age_group $ count level $; CARDS; Hosp1 0-16 0 Level1 Hosp1 17-74 10 Level1 Hosp1 75+ 1 Level1 Hosp2 0-16 14 Level1 Hosp3 0-16 1 Level1 Hosp3 17-74 16 Level1 Hosp4 0-16 1 Level2 Hosp4 17-74 4 Level2 Hosp5 17-74 7 Level2 Hosp6 17-74 80 Level2 Hosp6 75+ 2 Level2 Hosp7 17-74 4 Level3 Hosp8 17-74 9 Level3 Hosp9 17-74 95 Level3 Hosp9 75+ 1 Level3 Hosp10 0-16 1 Level3 Hosp10 17-74 27 Level3 ; RUN; proc sgplot data=test; block x=hospital block=level / filltype=alternate fillattrs=GraphAltBlock altfillattrs=GraphBlock transparency=0.7; scatter x=hospital y=count/ group=age_group grouporder=ascending MARKERATTRS=(symbol=circlefilled size=10) LEGENDLABEL= "Hospitalizations" datalabel datalabelpos=top; xaxis display=all fitpolicy=rotate grid; yaxis offsetmin=0.02 grid; title ' '; run; proc sgplot data=test; block x=hospital block=level / filltype=alternate fillattrs=GraphAltBlock altfillattrs=GraphBlock transparency=0.7; vbar hospital / response=count group=age_group stat=sum datalabel datalabelattrs=(weight=bold) nooutline barwidth=0.5; xaxis display=(nolabel); yaxis grid label='Number of hospitalizations'; title ' '; run;

Recep · ‎05-03-2021

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

Recep · ‎05-03-2021

Hello all, I was wondering if it's possible to change the color of the markers within PROC SGPLOT when you have multiple groups as in the example below. Thank you very much in advance! Recep DATA test; INPUT Hospital $ age_group $ count; CARDS; Hosp1 0-16 0 Hosp1 17-74 10 Hosp1 75+ 1 Hosp2 0-16 14 Hosp3 0-16 1 Hosp3 17-74 16 Hosp4 0-16 1 Hosp4 17-74 4 Hosp5 17-74 7 Hosp6 17-74 80 Hosp6 75+ 2 Hosp7 17-74 4 Hosp8 17-74 9 Hosp9 17-74 95 Hosp9 75+ 1 Hosp10 0-16 1 Hosp10 17-74 27 ; RUN; proc sgplot data=test; scatter x=hospital y=count/ group=age_group grouporder=ascending MARKERATTRS=(symbol=circlefilled size=10) LEGENDLABEL= "Hospitalizations" datalabel datalabelpos=top; xaxis display=all fitpolicy=rotate grid; yaxis offsetmin=0.02 grid; title ' '; run;

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 "

Recep · ‎02-26-2021

Thanks @SteveDenham ! I'll treat them as "not" statistically significantly different. I'm also puzzled by the median test results by NPAR1WAY and I asked about it to the SAS technical support. Though, as with my original post above, I made a typo when I was writing down the p-values of two tests by NPAR1WAY. They should read as 0.2012 for the Wilcoxon Two-Sample test and 0.0175 (not 0.175) for the Median Two-Sample test. I'll wait to hear back from SAS and post their reply here.

Recep · ‎02-25-2021

@SteveDenham , I'm not very familiar with PROC RELIABILITY but @FreelanceReinh is right about the medians. The PROC MEANS below shows that they are 8 and 9 for "No" and "Yes", respectively. proc sort data=los;by treatment; proc means data=los median; by treatment; var length_of_stay; weight freq; run; Hospital length of stay is knows for its notorious right skewed distribution. For that reason we are not comparing means between two groups but the medians. I wonder if the distribution plays a role when comparing medians because I was under the impression that quantiles are taking into account when comparing medians.

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

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: PROC SGPLOT - changing the marker colors

PROC SGPLOT - changing the marker colors

Re: Median difference test

Re: Median difference test

Re: Median difference test