About nataliavanessa0

nataliavanessa0 · ‎09-16-2021

Hi, After sorting by date and ID, I am trying to select the first row per id that meets a certain criteria (x > 1), but if none of the rows (per id) meet this criteria, I want to select the last row for that id? I appreciate any help, thanks. Natalia

nataliavanessa0 · ‎09-03-2021

Hello , I am trying to create one variable (type2) from multiple rows per ID using variable type. I want to covert a table like this one: ID type 1 A 1 A 1 B 2 A 2 A 3 B 3 B 3 B To: ID type2 1 C 2 A 3 B Where type2 is: If type is always A then type2=A; If type is always B then type2=B; If type is a combination of A and B then type2=C; Thanks

nataliavanessa0 · ‎07-15-2021

Hi everyone: I have a dataset with hierarchically clustered data: repeated measures per patient within repeated hospitals. I am trying to adjust for both levels in my model, plus I would like to estimate Relative Risks instead of odds ratios .I used the following genmode code, would the repeated statement adjust for clustering in the hospital and subject? proc genmod data= data; class hospital gender(ref="2") outcome(ref="1") ID; model outcome= gender /dist=binomial link=log; repeated subject=hospital(ID); run; Thanks quit;

nataliavanessa0 · ‎07-15-2021

Hello everyone: I have a dataset with hierarchically clustered data: repeated measures per patient within repeated hospitals. I am trying to adjust for both levels in my model, plus I would like to estimate Relative Risks instead of odds ratios. I tried to use proc glimmix for my binary outcome, but the model doesn't run as either a binomial log or a poisson. I get the following error: ERROR: Model is too large to be fit by PROC GLIMMIX in a reasonable amount of time on this system. Consider changing your model. Here is the code I am using: proc glimmix data= data1; class hospital gender outcome patient_ID; model outcome= gender/dist=bin link=log s; random hospital/ subject=patient_ID ; run; proc glimmix data= data1; class hospital gender outcome patient_ID; model outcome= gender/dist=poisson link=log OFFSET=followup; random hospital/ subject=patient_ID ; run; thanks,

nataliavanessa0 · ‎07-14-2021

Thank you

nataliavanessa0 · ‎07-13-2021

Hello everyone: I have a dataset with hierarchically clustered data, meaning repeated measures per patient within repeated hospitals. I am trying to adjust for both levels in my model. I am thinking of using a proc glimmix for my binary outcome. As I unable to use the repeated statement, would this code adjust for my repeated measures per patient in addition to the correlation within hospitals? proc glimmix data= data1; class hospital ender outcome patient_ID; model outcome= gender/dist=binary link=logit ddfm=bw solution; random hospital/ subject=patient_ID ; run; thanks,

nataliavanessa0 · ‎05-13-2021

thank you @CarmineVerrell But what if I don't want to combine all 1s and all 2s by ID, I just one to sum dur while a is constant but when it changes I want to restart the sum until it changes again? something like this: and I would like to do this: id a dur sum 1 1 30 30 1 1 30 60 1 2 10 10 1 1 10 10 Thanks.

nataliavanessa0 · ‎05-13-2021

Hi , I am trying to sum one variable as long as another remains constant. I want to cumulative sum dur as long as a is constant. when a changes the sum restarts. when a new id, the sum restarts. id a dur 1 1 30 1 1 30 1 2 10 2 1 20 2 2 10 2 2 10 3 2 10 3 1 10 and I would like to do this: id a dur sum 1 1 30 30 1 1 30 60 1 2 10 10 2 1 20 20 2 2 10 10 2 2 10 20 3 2 10 10 3 1 10 10 Thanks

Online Status	Offline
Date Last Visited	‎09-16-2021 05:55 PM

Selecting first row meeting value, if not last row per id

Creating one variable per multiple rows per ID

Binomial clustered data-genmode

hierarchically clustered data

Re: Hierarchical clustered data (binomial outcome)

Hierarchical clustered data (binomial outcome)

Re: summing a variable by condition and id

summing a variable by condition and id

Re: Creating one variable per multiple rows per ID