About JenMMerc

JenMMerc · ‎10-26-2021

Good morning, I am trying to create a table of summed variables grouped by date. When I run the code I receive the error: I can't see where the problem is occurring. What am I missing? Thanks in advance. PROC SQL; CREATE TABLE new_table AS SELECT Date, SUM (Fully_vaccinated) as fullvax_persons, SUM (Unvaccinated) as unvax_persons Group BY Date FROM denominator WHERE Age in (12,13,14,15,16,17); QUIT;

JenMMerc · ‎12-08-2020

It's not for an analysis. I am trying to identify individuals and their speciifc incidents and time of incidents from a large data set. I need to determine the time period from the initial incident to the most current incident. The data are not entered into the database consistently (for any PersonID a new incident could be entered under the old incident number with a new date or be entered as a new incident number) and I am trying to account for that. Each separate incident (whether the number is the same as a previous incident number or a new incident number) needs to be associated with the PersonID. Does that make sense?

JenMMerc · ‎12-08-2020

Good morning, I have a line list of data (HAVE) and want to transform it (merge, modify?) so that there is a single personID with associated info (WANT, below). I know there has got to be a simple way to do this. Value of the Incident number is not always chronologically associated with the Incident Date and when the data transpose there will need to be multiple Incident and Incident Date vars. Please advise. Thank you, Jenny HAVE Person ID Incident Incident Date A 101 6/3/2020 A 102 8/3/2020 A 101 10/2/2020 B 200 8/5/2020 C 300 8/12/2020 D 400 6/10/2020 D 401 6/15/2020 WANT Person ID Incident1 Incident Date1 Incident2 Incident Date2 Incident3 Incident Date3 A 101 6/3/2020 102 8/3/2020 101 10/2/2020 B 200 8/5/2020 C 300 8/12/2020 D 400 6/10/2020 401 6/15/2020

JenMMerc · ‎04-04-2020

data new; input patient_id headache fever blur_vision hospital; datalines; 120 1 1 0 0 121 1 1 1 0 122 0 1 0 1 123 1 0 0 1 124 1 1 1 1 125 0 0 1 0 126 0 1 0 1 127 0 0 1 1 128 0 0 0 0 129 1 1 1 1 130 1 0 0 1 131 0 1 1 0 ; run;

JenMMerc · ‎04-04-2020

I have a data set with multiple variables for symptoms (headache 0,1; blurry vision 0,1). I'd like to create 3 tables-first a table with all vars by presence of symptom like this 0 1 Headache Hypertension Blurry vision a second table with all of the identified symptoms (symptom var=1) and col % for each. N % Headache Hypertension Blurry vision and last a table with identified symptoms (symptom var=1) by hospitalized or not (hospital=0,1). Hospitalized 0 1 Headache Hypertension Blurry vision Thank you, Jenny

JenMMerc · ‎03-28-2020

This worked! Thanks!

JenMMerc · ‎03-28-2020

I'm trying to do something simple but am struggling. I'd like to create a simple one way frequency table with column total. I'd like to customize the order of the labels (not just by frequency) and change the Frequency label to Number. So the table would look like this: Thanks! Number Red 5 Blue 8 Yellow 2 Green 3 Total 18

JenMMerc · ‎07-23-2019

It worked! Thank you.

JenMMerc · ‎07-23-2019

Hi, I am working with a data set where I have created new variables based on success of outcomes. 0=not sucessful 1=successful .= outcome not applicable to client. I want to create a 2 new variables count_1 and count_0 that each count the number of 1s and 0s from the outcomes variables so I can eventually calculate a success rate for each client. Thanks in advance for the help. data outcome; input client outcome1 outcome2 outcome3; cards; A . . 0 B . 1 0 C 0 0 1 D . . 1 ; run;

JenMMerc · ‎06-04-2018

Good morning, I am trying to create 3 year moving average rates from a large birth file. I have used proc summary to get the data into a format to create the rates by year proc summary data=ptm_denom; class year; var preterm birth; output out=ptmtab sum=preterm birth; run; proc print data=ptmtab; run; data ptm_rate (drop = _type_ _freq_); set ptmtab; ptmrate = (preterm/birth)*100; run; proc print data=ptm_rate noobs; var year preterm birth ptmrate; run; And my output looks like this: year preterm birth ptmrate . 3986 52025 7.66170 2007 439 5549 7.91134 2008 453 5627 8.05047 2009 453 5517 8.21098 2010 453 5298 8.55040 2011 394 5082 7.75285 2012 363 5069 7.16118 2013 368 4946 7.44036 2014 374 5031 7.43391 2015 328 4977 6.59032 2016 361 4929 7.32400 but I can't figure out how to sum and average the data and manipulate the table so my output looks like this: 2007-2009 2008-2010 2009-2011 2010-2012 2011-2013 2012-2014 2013-2015 2014-2016 preterm birth ptmrate This seems like there would be an easy solution, but I can't figure one out. Any help would be great!

Online Status	Offline
Date Last Visited	‎11-05-2021 03:53 AM

Error in proc sql group by statement

Re: TRANSFORMING DATA

TRANSFORMING DATA

Re: How do I create a frequency table with multiple row variables

How do I create a frequency table with multiple row variables

Re: I'd like to create a simple table using proc freq, customize the l...

I'd like to create a simple table using proc freq, customize the label...

Re: Counting values in multiple variables to create new variable

Counting values in multiple variables to create new variable

How do I modify proc summary output to create a table

Re: Error in proc sql group by statement

Re: Counting values in multiple variables to create new variable

Error in proc sql group by statement

Re: TRANSFORMING DATA

TRANSFORMING DATA

Re: How do I create a frequency table with multiple row variables

How do I create a frequency table with multiple row variables

Re: I'd like to create a simple table using proc freq, customize the l...

I'd like to create a simple table using proc freq, customize the label...

Re: Counting values in multiple variables to create new variable

Counting values in multiple variables to create new variable

How do I modify proc summary output to create a table