About DanielQuay

DanielQuay · ‎08-08-2023

That is was precisely what I was struggling to do. Everything I had tried up to now got me close but didn't seem exactly right. I can't thank you enough mate, now I get to learn about cubic relationships and I really appreciate the note you attached.

DanielQuay · ‎08-04-2023

I'll give that code a shot. referring to the slopes, this is a graph of the rates when I calculated them manually: I am trying to figure out how to determine if there is a statistically significant difference between the trend lines.

DanielQuay · ‎08-04-2023

So, it's per total visits. Data would be... year Participant Incident Visit 2016 1 1 1 2016 1 0 1 2016 0 0 1 2016 0 1 1 2016 1 0 1 2016 0 1 1 2016 1 1 1 2016 0 0 1 2016 1 1 1 output looks like this when I run the table: YEAR Program and Incident Not Program and Incident Program and Total Visits Not Program and Total Visits 2016 33 52 21903 48969 2017 23 37 21637 47737 2018 26 38 21608 47675 2019 30 43 21156 46878 2020 24 56 20109 45540 2021 16 46 19134 43691

DanielQuay · ‎08-04-2023

I am at a bit of a loss. Or perhaps I am once again making things more difficult than they have to be as I am rather good at that. I'm working with a data set with over 400k observations. I have a binary variable to indicate whether or not an organization participated (1) in a program or did not (0). I have another variable which indicates whether an incident happened (1) or did not (0). I have each of these repeated for 2016-2021. proc freq data = HAVE; tables PROGRAM * Incident; by year; run; I can manually calculate the rate per 10,000 and graph that using the code above, but I am looking for a way to calculate the rate within SAS so that I could then determine if there is a difference in the slopes between those that participated in the program and those that did not with regard to incidents. And I'm not sure precisely how to go about that part of things within SAS.

DanielQuay · ‎06-08-2023

That is where I've talked myself into a circle. Doing a wilcoxon analysis seemed like it would be appropriate, but I haven't used time data in ... 12 years. Can you help me wrap my head around how this isn't time series data? I need a better understanding here so I can defend my methodology if challenged.

DanielQuay · ‎06-08-2023

Good Morning Everyone, or whatever time of day it is. I have talked myself into a circle and I'm not sure which path to follow at this point. So, I thought I would ask the experts. What I am trying to do is determine if there is a statistically significant difference in the time it takes to reach a diagnosis based on the result of the diagnosis. For example, does it take significantly longer to reach a final diagnosis based on whether a tumor is malignant or benign. Calculating the median number of days to final diagnosis I believe I have figured out successfully. But then I have found myself a bit stuck. I considered ANOVA but the time data violates the independence assumption. I considered proc lifetest, conducting a peto test, and probdf but I'm uncertain which to use in this scenario. Any guidance would be helpful. Thanks

DanielQuay · ‎11-04-2022

I think this is the code you're wanting from the Log Reeza. NOTE: There were 69871 observations read from the data set WORK.MODIFY. NOTE: The data set WORK.MOD2 has 69871 observations and 186 variables. NOTE: At least one W.D format was too small for the number to be printed. The decimal may be shifted by the "BEST" format. NOTE: DATA statement used (Total process time): real time 0.27 seconds cpu time 0.23 seconds There is not formatting applied in the creation of this one. Here is what I get when I run the contents: 78 HSMRNT_PRVD_TP Char 1 $1. $1.

DanielQuay · ‎11-03-2022

Well that's probably it, it's a character variable. I will try to get you the log on that, but I have to clean up the log a bit first.

DanielQuay · ‎11-03-2022

I give up, this one doesn't make sense to me. I have a variable in a dataset that is all missing. I need it to recode to 99, the code for does not collect. I've tried a number of variations. Dropping the variable beforehand and then adding it back, If/Then logic. Everything keeps generating * when I run a proc freq. Here's my basic code: data want; set have; variable = 99; run;

DanielQuay · ‎09-15-2022

So I have a multi-select variable and in sas the value is the selected list of values delimited by a | (the example below is from a PROC FREQ on this variable). What I am needing is to break each of these out into separate variables so that I can analyze these stress factors individually. The solutions I've found don't accurately reflect the data I have, when I compare them it misses some of the factors. In the below example of data, I've only been able to get two CPS involvement and 1 History of DV for example. I could use a little guidance here, this part of SAS is really not my strong suit. I'm working in SAS 9.4 saepsoes_eosoe_stres Child Protective Services Involvement|History of Substance Use|(blank) Child Protective Services Involvement|History of Treatment for Substance UseHistory of Domestic Violence|(blank) History of Domestic Violence|Child Protective Services Involvement|History of Substance Use| Unemployment|History of Treatment for Substance Use|History of Childhood Trauma|(blank) History of Domestic Violence|Child Protective Services Involvement|History of Substance Use|Unemployment| History of Treatment for Substance Use|Prior Suicide Attempts|(blank) History of Domestic Violence|History of Psychiatric Hospitalizations or Treatment|OtherHistory of Domestic Violence|Recent Trauma|(blank) History of Psychiatric Hospitalizations or Treatment|Child Protective Services Involvement|History of Substance Use|Unemployment|History of Treatment for Substance Use|(blank) History of Psychiatric Hospitalizations or Treatment|Child Protective Services Involvement|History of Substance Use|Unemployment|Other History of Substance UseHistory of Substance Use|Other|(blank)

DanielQuay · ‎04-14-2022

I kind of love this response actually and am going to remember that analogy. The clients are aware, the management that is making this have to happen says it has to happen though. So I get to keep trying to find a way to make this more useable for the clients.

DanielQuay · ‎04-13-2022

I have a dataset with 57 observations. Each observation has over 100 variables. When I use proc print to write the data to a PDF I get a 660 page document. I need to reduce my page count if humanly possible. Right now each page contains one row of data. Basically I need it to not start a new page until it gets to a new observation or runs out of space. Here is the code I have, truncated of course (nobody wants to see all my variable names and formats). ods pdf file="C:\PAMR Program\SAS Codes\Data\BC_Data_&sysdate..pdf" ; proc print data = P_BC noobs ; var <variables list> ; by MNAME; where MNAME ne ' '; run; ods pdf close; I thought I was onto something with the startpage optionbut I'm coming up with the same thing.

DanielQuay · ‎04-04-2022

The problem is that I need this to basically show up on one page. So instead of one row with 33 variables I would need like 8 rows with 4 variables and one row of 1.

DanielQuay · ‎04-04-2022

Hello All, So I have a lot of variables that I am needing to print out using a BY variable. The problem is that when it goes to the Excel file, I wind up with a single row that is going from A to EQ. I'd rather have this print as columns or like, A - G then go down a row and repeat. I've been trying to research this but I haven't found the solution yet. Here is my code (abbreviated): ods excel file="H:\PAMR Program\SAS Codes\Certificate Data\Birth Certificate Data_&sysdate..xlsx" ; proc print data = PAMR_CERT noobs; var nchsap5 nchsap10 livedep brefed ctrans ctranslit forcep vacuum fetpres delroute trial vent surf seiz ventl6 nicuadm newbanti bthinj nchs_abcond anenc cyanotic omph limbred cleflip downsyn hypspad spina hern gastro clefpal suspchrom cgaoth nchs_cgana ; by patnm; format CDOB mmddyy10. fdob mmddyy10. mdob mmddyy10. lldob mmddyy10. lodob monyy7. nchsbpt $nchsbpt. Attend_Type $Attend_Type. MOM_XFER $MOM_XFER. vrfac $Fac2020a. nchsfedu $educ. marrever $marrever. pataff $pataff. nchsmedu $educ.; run; Am I wanting to do the impossible here?

DanielQuay · ‎11-16-2021

THis got it, but I had to add a format for it to print properly to the CSV txt file I had to send them.

Online Status	Offline
Date Last Visited	‎08-08-2023 08:26 PM

Re: Creating and Comparing Rates between Groups

Re: Creating and Comparing Rates between Groups

Re: Creating and Comparing Rates between Groups

Creating and Comparing Rates between Groups

Re: Median Days To Diagnosis

Median Days To Diagnosis

Re: Variable keeps generating with * as result

Re: Variable keeps generating with * as result

Variable keeps generating with * as result

Converting Multi-Select Variable to Multi-Variable

Re: How do I print to fewer pages with an ODS PDF

Re: Proc Surveymeans: Suppressing the kernel & normal density plot ove...

Re: Merging Variables

Re: Same Variable Name - Different responses

Re: Proc SurveyReg Output

Re: Proc SurveyReg Output

Re: Merging Variables

Re: Creating and Comparing Rates between Groups

Re: Creating and Comparing Rates between Groups

Re: Creating and Comparing Rates between Groups

Creating and Comparing Rates between Groups

Re: Median Days To Diagnosis

Median Days To Diagnosis

Re: Variable keeps generating with * as result

Re: Variable keeps generating with * as result

Variable keeps generating with * as result

Converting Multi-Select Variable to Multi-Variable

Re: How do I print to fewer pages with an ODS PDF

How do I print to fewer pages with an ODS PDF

Re: Changing EXCEL output

Changing EXCEL output

Re: Adding Trailing Zeros