About tomas-andriotti

tomas-andriotti · ‎04-29-2019

yes, I am working with a dataset with one line per visit in which every patient has at least one visit. the variables are; 1. id 2. begdate: date of visit 3. freq_user_y: frequent user a calendar year 4. year: calendar year I wonder how I can code to get frequent user within 365 days rather than within a calendar year. Thanks

tomas-andriotti · ‎04-29-2019

thank you for your answer. yes, that is what I need to code now: frequent user at the ED who went 4 or more times within a year (365 days). For instance, if they went at the 7th time at the ED on July 4, 2015, and the 4ht visit had been on July 18, 2014, then they must be counted as a frequent user. However, if the period between 4 visits is greater than 365 days, then it should not be counted as such, Let me know if you have more questions, please. Tomas

tomas-andriotti · ‎04-29-2019

Hi! I am trying to recode a variable defined as freq_user in a long data set (longitudinal form). Frequent users (freq_users) were identified as those who went to the emergent department (ED) more often than 4 times a calendar year. However, I need to identify as freq_users those who went to the ED in 365 days in order that I can also capture, for example, those who went to the ED 2 times in one year and 2 times in the following but they still happened within 365 days. - the name of the variables are : Id: individuals k: order of observations or visits begdate : date of the observations - visit at the ED y : calendar year freq_user_y : 4 visits or more to the ED a year Look forward to hearing from you. Tomas

tomas-andriotti · ‎04-23-2019

I have a follow-up question regarding this topic - if I want to find the frequent user counting those with 4 visits at the ED in 365 days after each visit instead of 4 visits in a calendar year only, how should I do code it?

tomas-andriotti · ‎03-06-2019

Hey thanks ! I believe it worked. I just have to merge table want with the dataset I have. Best, Tomas

tomas-andriotti · ‎03-06-2019

Hi, I ran the command and it created another table with the difference in line 1 for all individuals even the ones with no second observation because there are individuals with no k2. So, I do have a dataset have and what I need is to scoot up the diff only for those individuals with a recurrent event ( k>2) those with no second event should not have a difference because they were not observed or followed up to a second time. Look forward to hearing from you. Tomas

tomas-andriotti · ‎03-05-2019

Hi, I have a longitudinal dataset with many ED (emergency department) visits per individual (id). Each visit has an index date (begdate) and the variable year. I am trying to model a cox for recurrent events creating time0 (start) and time2 (stop). The main variables are: id: individuals k: observations or visits begdate : date of the observations - visit the ED year : calendar year freq_user_y : 4 visits or more to the ED a year I created the difference between the observations and the lag time but it turns out the observations k=1 are being excluded because they do not have a time2. And the lag time has been created just for the observations k >= 2 . I wonder how I can create a time 2 for the first observation then the difference between time 1 and 2 (t2-t1) be kept in this line (k=1), not in the second visit (k=2) and so on, time difference t3-t2 in line k=2, not in k=3... Look forward to hearing from you. Tomas

tomas-andriotti · ‎03-04-2019

thank you !this worked! so if I want to count within a calendar year, does the code below just changing fy to year (after creating the calendar year ) suffice? proc sort data=have; by id year begdate; run; data want; set have; by id year; if first.year then counter = 1; else counter + 1; drop counter; new_freq_user_y = (mod(counter, 4) = 0); run;

tomas-andriotti · ‎03-03-2019

Ansewers to your questions 1. the name of the variables are : Id: individuals k: observations or visits begdate : date of the observations - visit to the ED fy : fiscal year (sep year X - august year X+1) freq_user_fy : 4 visits or more to the ED a year 2. yes, the dataset contains fy = fiscal year that was used to code freq users within a fiscal year. 3. I am certain that if the next 2 visits happen in another fiscal year that they were not flagged but if they happened within the fiscal year, all of them were flagged, which is the issue I am trying to solve because I need just the 4th visit to ED within the same fiscal year thanks

tomas-andriotti · ‎03-03-2019

Hi! I am trying to recode a variable defined as freq_user in a long data set (longitudinal form). Frequent users (freq_users) were identified as those who went to the emergent department (ED) more often than 4 times a year. It turns out that all observations in a year (visits to ED) were identified as freq_users if the individual has gone more than 4 times to ED - the 1st, 2nd and 3rd as well as the 4th visit. However, I just need to identify as freq_users those observations at the 4th visit or its multiples (8th, 12th and so on) if they were considered so. Look forward to hearing from you. Tomas

tomas-andriotti · ‎03-03-2019

thank you ! very helpful

tomas-andriotti · ‎02-25-2019

Hello, i need help with coding a longitudinal dataset. I want to exclude individuals from a long format dataset which have different levels of the covariate over time, i.e., if they present a hospital type observations in one occasion as PFF system and in one another as DIRECT system, they should be excluded. if on all occasions they are only PFF or only DIRECT they should stay in the dataset. Thus, I can only keep those who do not cross between systems over time. The covariate is binary, PFF/DIREC. Look forward to hearing from you. TA

Online Status	Offline
Date Last Visited	‎08-11-2019 01:49 PM

Re: frequent user in 365 dasy

Re: frequent user in 365 dasy

frequent user within 365 days

Re: recode just the multiples of 4 of a variable

Re: create time stop

Re: create time stop

create time stop

Re: recode just the multiples of 4 of a variable

Re: recode just the multiples of 4 of a variable

recode just the multiples of 4 of a variable

Re: frequent user in 365 dasy

Re: frequent user in 365 dasy

frequent user within 365 days

Re: recode just the multiples of 4 of a variable

Re: create time stop

Re: create time stop

create time stop

Re: recode just the multiples of 4 of a variable

Re: recode just the multiples of 4 of a variable

recode just the multiples of 4 of a variable

Re: How to only exclude ID's with subsequent unwanted observations

How to only exclude ID's with subsequent unwanted observations