Hi folks,    I have a dataset that looks like this:    data have; input studyID mth_date ed_visits year ; cards; 1 2011-04 0 2011 1 2011-05 1 2011 1 2012-01 3 2012 2 2011-03 4 2011 3 2011-04 2 2011 3 2011-06 0 2011 3 2013-08 2 2013 run; And I'm trying to create a dataset that will tell me which of the study id's have 3 or more ed_visits within 12 months ( we'll call them repeat users). The trick is that I don't care if it's 3 hospitalizations in the same year, just that within any 12 month period they have a total of 3 or more hospitalizations. So Using the above dataset, and creating a binary variable for "repeat user" my output could look something like:   data want; input studyID mth_date ed_visits year Repeat_user ; cards; 1 2011-04 0 2011 1 1 2011-05 1 2011 1 1 2012-01 3 2012 1 2 2011-03 4 2011 1 3 2011-04 2 2011 0 3 2011-06 0 2011 0 3 2013-08 2 2013 0 run;   Study ID's 1 and 2 both have enough hospitalizations to qualify as repeat users (value of 1),  but #3 never had more than 2 visits within a 12 month period, so they remain 0's.   Alternatively,  a list of the study ID's that meet the "repeat user" criteria would also work.     Also, just FYI the mnth_date variable is currently not a SAS date, just a string (not my fault that's just how the data came).    In essence I need to be able to sort out the people who made 3 or more trips to the ED within 12 months over the course of my study period  from those that haven't    Any thoughts would be much appreciated!    Thanks so much   Mike ... View more

Hi All,    I have this longitudinal dataset with multiple observations per studyid:    data have; input studyID FSA $3. Exposure Age ; cards; 1 B2Y 384 17 1 B2Y 384 17 1 B2Y 384 18 2 BgT 1000 15 3 M6D 400 14 3 M6D 400 15 3 M6D 400 16 run; What I want to do is create a new variable called "Age_start" which is the lowest value for age for each indivdual in the study, so the "want" dataset would look like this:    data want; input studyID FSA $3. Exposure Age age_start ; cards; 1 B2Y 384 17 17 1 B2Y 384 17 17 1 B2Y 384 18 17 2 BgT 1000 15 15 3 M6D 400 14 14 3 M6D 400 15 14 3 M6D 400 16 14 run; As per usual, any thoughts would be hugely appreciated. I've been playing with it for a couple of hours using proc sort and then running variations of a data step that looks like  data want; set have; age_start = first.age; run; but all I get are zeros.    Any thoughts are much appreciated.    Thank you.    Rightcoast ... View more

Hi All,    First off if this has been answered I apologize, I've been looking around the forums and I've found a bunch of answers that are close, but don't quite work for what I'm looking for. Here's what I've got    data have; input studyID FSA Exposure ED_binary ; cards; 1 B2Y 384 1 1 B2Y 384 0 1 B2y 384 1 2 BgT 1000 0 3 M6D 400 1 3 M6D 400 1 3 M6D 400 1 run; Essentially what I am looking to do is get one record per person. I need to collapse studyid FSA and Exposure, and then sum the ed _binary variable. so the resuting dataset would look like :  data want; input studyID FSA Exposure ED_binary ; cards; 1 B2Y 384 2 2 BgT 1000 0 3 M6D 400 3 run; the closest i've come is with proc SQL but that doesn't give me a dataset, just the report. I've tried proc means as well but my system just keeps hanging (I have a fairly large dataset).   as always any thoughts would be much appreciated.    Thank so much   Rightcoast     ... View more

Hi All,   I have a dataset that looks something like this:     data have; input studyID ED_type1 ED_type2 ED_type3; cards; 1 . 1 1 2 . . 1 3 1 . . 4 1 . 1 5 . 1 1 ; What I am trying to do is develop a summary variable for each record based on the ED_type variables. Essentially the ed_types are hierarchical (ED_type 1 being the top of the hierarchy, ED_type2 below it, and ED_type3 below that).  The summary variable needs to reflect whichever the "highest" ED type visit is for a given record.    Clear as mud right? It might be easier with an example, in the end I want my new dataset to look like this:   data have2; input studyID ED_type1 ED_type2 ED_type3 ED_Summary; cards; 1 . 1 1 2 2 . . 1 3 3 1 . . 1 4 1 . 1 1 5 . 1 1 2 ; Since ID 1 has (1) in both ed visits in categories 2 and 3 it get's summarized as a 2 (because 2 falls above 3 on the hierarchy)  Similarly, since ID 4 has visits in categories 1 and 3, then it get's a 1 because 1 is higher in the hierarchy than 3.   Thanks so much in advance folks, you are always a huge help and any thoughts would be much appreciated.    Rightcoast   ... View more

Hi everyone, I have a dataset that looks roughly like this:    Data have; Input ID Year Num_visits; datalines; 1 2011 3 . 2012 2 . 2013 0 . 2014 4 2 2011 2 . 2012 3 . 2013 1 . 2014 0 3 2011 6 . 2012 0 . 2013 2 . 2014 5 ; run; What I'm trying to do is convert that into a dataset that looks like this:    Patient ID      2011     2012     2013     2014   Total       1                  3         2           0           4         9       2                  2         3           1           0         6       3                  6         0           2           5         13   Any thoughts would be much appreciated!    Thanks so much   Mike              ... View more

Hi All,    I've been tasked with creating a Concentration curve based on some socioeconomic data and health data, but it's proving to be quite tricky to even find documentation on how to set things up. I've managed to find this paper about how to do it in STATA (http://repec.sowi.unibe.ch/files/wp15/jann-2016-lorenz.pdf) , but nothing for SAS. Normally I would include a sample dataset, but to be honest I can't even figure out how the data needs to be laid out. I am pretty sure it can be done, but I am at a loss as to where to begin.    Any help would be much appreciated.    Thanks so much   Mike     ... View more