About einstein

einstein · ‎01-22-2018

I have the addresses (address line, city state, zip) for individuals in 3 states (DC,MD,VA) and trying to create a map that will show the 3 states together and plot each individual so that I can see where most of them are coming from. Is there some code someone can share with me or point me to the right resources to do this? Thanks!

einstein · ‎09-14-2017

Got it! It worked! Thank you so much!

einstein · ‎09-14-2017

Since your ratings have a finite range [1-10], you should consider using non parametric tests such as the Kruskal-Wallis test available with option Wilcoxon in proc npar1way. I just tried this and I think it worked! Assuming I am understanding this correct, this is letting me compare if the values within the age groupings for rating_1 and rating_2 are statistically significant from each other. Thanks! proc npar1way wilcoxon correct=no data=tables; class age; var rating_1 rating_2; exact wilcoxon; format age age. ; run; This one below I'm not quite sure how to implement - would you happen to have some sample code to do this? If rating 1 and rating 2 have been measured on the same individual, you should consider testing rating 1 - rating 2 against zero with one of the location tests available in proc univariate such as the Wilcoxon signed rank test. Thanks!

einstein · ‎09-14-2017

Then consider looking at an ANOVA I don't want to be dense, but if I use ANOVA, is this the correct way to get I what I need? Be able to compare rating_1 vs. rating_2 for each age grouping? proc anova; class rating_1 rating_2; model age=rating_1 rating_2 rating_1*rating_2; means rating_1 rating_2 /t tukey sidak; means rating_1*rating_2 /t tukey sidak; format age age. ; run;

einstein · ‎09-13-2017

Yes, I have the original data that is computing these means.

einstein · ‎09-13-2017

I have the average of two rating catgories among 3 age groups. Is there a way to test if the means in Rating 1 are statistically different among the three age groups (is 9.03 statistically different from 9.45 and 8.75)? And if there is also a way to test if the mean for rating 1 is statistically different from the mean for rating 2? Thanks! Rating 1 (1-10) Rating 2(1-10) Age 18 – 34 9.03 8.66 35 – 54 9.45 7.56 55+ 8.75 6.65

einstein · ‎08-18-2017

These extra lines below didn't work when I added it in: GUESSINGROWS=32767; MIXED=YES; USEDATE=YES; SCANTIME=YES; So I did what others suggested - i converted the CSV and then modified the data step created by proc import. That fixed my problem! Took a little more effort, but at least the data is right! thanks everyone!

einstein · ‎08-18-2017

I'm trying to import several excel sheets with similar but not exact layouts, but I noticed when I use proc import, it keeps converting my date of birth (DOB) variable into a character field. Is there a way to specify that this variable needs to be in the date/time format? PROC IMPORT OUT= box.ed_&month.&year. DATAFILE= "C:\Event_Audit_&month.&year..xlsx" DBMS=xlsx REPLACE; SHEET="&month. 20&year."; GETNAMES=YES; OPTION VALIDVARNAME=V7;/*<------ This will put underscores where there are spaces*/ RUN;

einstein · ‎08-16-2017

Thank you Reeza! Apparently, you need to include all the syntax in the proc template for it to work properly. This link was a great resource for anyone who needs it: http://support.sas.com/kb/43/910.html Thank you SAS Community!

einstein · ‎08-15-2017

I'm trying to limit the survival estimates graph to only display data up to 72 hours. Right now the data is displaying unto 100 hours. My original survial time data was in seconds so I converted it to hours and altered the template to have a viewmax=72. But this seems to give me the following error: WARNING: Insufficient data to produce 'Stat.Lifetest.Graphics.ProductLimitSurvival' Graph. I don't get this error if I simply ran the code without a viewmax=72 limit. Does anyone know what I must be doing wrong? data linex; set line; *where survival_time <='72:00:00't; survival_timex=survival_time*0.000277778; run; ods path show; proc template; define statgraph Stat.Lifetest.Graphics.ProductLimitSurvival; begingraph; layout overlay / xaxisopts=(label="Survival Time (Hours)" offsetmin=.05 linearopts=( viewmax=80 tickvaluelist=(0 20 40 60 72))); endlayout; endgraph; end; run; ods graphics on; ODS TRACE ON; Proc lifetest data=linex plots=(s, lls) graphics; Time survival_timex*delta(0); Strata final_placement; Format final_placement treatment_assignment_.; Run; ods graphics off; proc template; delete Stat.Lifetest.Graphics.ProductLimitSurvival; run;

einstein · ‎08-11-2017

I just tried to get at the predicted means using the output statement, but it doesn't appear to take into account the "estimate" statements I added in. Is there a way to do this? Or do I need to somehow create an output statement for each attending using a where statement to get at the predicted means for each attending? %macro doEst; %do i=1 %to 34; estimate "Attending &i" int 1 age18_34 1 gender_m 1 | int 1 / subject %do k=1 %to %eval(&i-1); 0 %end; 1 ilink e; %end; %mend; proc glimmix data=tables method=quad(qpoints=31) noclprint; class attending; model contact (descending) = age18_34 age35_54 gender_m /CL DIST=Binary link=logit solution; random intercept / subject=attending S CL Type=VC ; COVTEST / wald; output out=glm_out pred(ilink) lcl(ilink) ucl(ilink) stderr(ilink); %doest; run;

einstein · ‎07-11-2017

Thanks for the reply. I guess I'll just have to live with manually calculating the CIs and the labels that are written to the estimate statement. Thanks again for all your help! ##- Please type your reply above this line. Simple formatting, no attachments. -##

einstein · ‎07-11-2017

Just tried this and it worked great! Thank you! But I also just noticed that the labels of the providers don't actually match the attending codes I have. Is there a way to fix this? So my Labels are Attending 1, Attending 2, etc. but the attending codes I have starts with 2 and skips around. Its starting to get confusing. Also, is there a way to see the confidence intervals without me having to manually calculate them in the estimates section? Is there an option for that? Thanks!

einstein · ‎07-10-2017

Oh my goodness - it worked! Thank you so much!

einstein · ‎07-10-2017

Nope, I don't get an error. It seems to run fine, but I'm not getting the output I expect. Is there a way to get at an estimate for each physician ("attending" in my dataset) as opposed to just one estimate in the ESTIMATE statement output, so that I can get at a predicted probability for each physician for the variables I have specified?

Online Status	Offline
Date Last Visited	‎07-12-2018 10:40 PM

Creating a dot map for 3 states

Re: Comparing means for statistical significance

Re: Comparing means for statistical significance

Re: Comparing means for statistical significance

Re: Comparing means for statistical significance

Comparing means for statistical significance

Re: PROC IMPORT - Changing Variable Type from Character to DateTime

PROC IMPORT - Changing Variable Type from Character to DateTime

Re: Limiting the X-axis Range in Proc Lifetest

Limiting the X-axis Range in Proc Lifetest

Re: Comparing means for statistical significance

Re: Comparing means for statistical significance

Re: proc import from excel with variable names with spaces

Re: "NOTE 49-169: The meaning of an identifier after a quoted string.....

Re: Estimating predicted probability using Proc Glimmix for set param...

Re: Estimating predicted probability using Proc Glimmix for set param...

Re: PROC IMPORT - Changing Variable Type from Character to DateTime

Creating a dot map for 3 states

Re: Comparing means for statistical significance

Re: Comparing means for statistical significance

Re: Comparing means for statistical significance

Re: Comparing means for statistical significance

Comparing means for statistical significance

Re: PROC IMPORT - Changing Variable Type from Character to DateTime

PROC IMPORT - Changing Variable Type from Character to DateTime

Re: Limiting the X-axis Range in Proc Lifetest

Limiting the X-axis Range in Proc Lifetest

Re: Estimating predicted probability using Proc Glimmix for set param...

Re: Estimating predicted probability using Proc Glimmix for set parame...

Re: Estimating predicted probability using Proc Glimmix for set param...

Re: Estimating predicted probability using Proc Glimmix for set param...

Re: Estimating predicted probability using Proc Glimmix for set param...