About zihdonv19

zihdonv19 · ‎02-01-2024

I have a dataset like this: data your_dataset; input id year weight seq; datalines; 1 2000 12 0 1 2005 14 1 1 2006 23 2 2 2001 12 0 2 2001 45 1 2 2001 42 2 2 2002 75 3 2 2002 45 4 3 2003 97 0 3 2004 90 1 4 2010 56 0 4 2011 38 1 4 2012 91 2 4 2012 31 3 4 2014 16 4 5 2013 46 0 5 2013 46 1 5 2014 55 2 5 2015 64 3 5 2016 26 4 5 2017 36 5 5 2018 87 6 5 2019 46 7 ; run; This is what I would like to get: data your_dataset; input id time0 time1 time2 time3 time4 time5 time6; datalines; 1 12 14 23 . . . . 2 33 60 . . . . . 3 97 90 . . . . . 4 56 38 61 16 . . . 5 46 55 64 26 36 87 46 ; run; The rule is: for people with same id and year, I only want the mean weight of this year. For example, for id2 with year 2001, the value in the desired table is 33, because (12+45+42)/3=33. Due to 2001 is the year that id2 had the first weight record, it is located in the colomn "time0" in the desired table.

zihdonv19 · ‎12-06-2023

thanks! this is magic 🙂

zihdonv19 · ‎12-06-2023

Hi Patrick, Indeed, you have a valid point! I didn't explain myself clearly before I asked this question, but you made me rethink what kind of data I really have. May I ask a follow-up question? What if I want the year range to be the first year of visit to 4 years after the first year of visit, instead of a fixed range 2007-2011? For example, for id1 the year range I want to look at should be 2007-2011, id2 2008-2012, id3 2007-2011, id4 2007-2011 etc.

zihdonv19 · ‎12-01-2023

Hi! The reason I expected only the first 5 rows in the output is that for id 1, their "type" is not missing for year 2007, 2008, 2009, 2010 and 2011.

zihdonv19 · ‎12-01-2023

I have data below data have; input id type visit_date :yymmdd10.; format visit_date yymmdd10.; datalines; 1 1 2007-01-01 1 2 2008-01-02 1 2 2009-01-03 1 3 2010-01-04 1 5 2011-01-05 2 1 2008-01-01 2 2 2008-01-02 2 2 2009-01-03 2 3 2010-01-04 2 5 2011-01-05 3 2 2007-01-09 3 . 2008-01-10 3 2 2009-01-11 3 . 2010-01-12 4 . 2007-01-10 4 3 2008-01-11 4 1 2009-01-12 5 2 2007-01-11 5 2 2008-01-12 5 2 2009-01-10 5 2 2010-01-11 6 2 2008-01-12 6 1 2009-01-10 6 . 2010-01-11 ; proc sort data=have; by id visit_date ;run; I want to select rows for the id, whose id have non-missing "type" for each "visit_year" of 2007-2011. So, for the dataset above, I would expect I will get row 1-5.

zihdonv19 · ‎09-04-2023

I'm using this example dataset to show my question, which is from: http://support.sas.com/kb/24/455.html data uti; input diagnosis : $13. treatment $ response $ count @@; datalines; complicated A cured 78 complicated A not 28 complicated B cured 101 complicated B not 11 complicated C cured 68 complicated C not 46 uncomplicated A cured 40 uncomplicated A not 5 uncomplicated B cured 54 uncomplicated B not 5 uncomplicated C cured 34 uncomplicated C not 6 ; I want to examine the relationship between count and diagnosis (odds ratio) using interaction term in logistic regression at each level of treatment. What I want: Treatment ORs (diagnosis~count) Confidence interval A 1.4 (1.2, 1.6) B 1.2 (1.1, 1.6) C 1.5 (0.8, 1.8) For a fabricate example, the odds ratio is 1.4 at treatment A meaning that for every one count increase, the risk of being diagnosed increased by 40%.

zihdonv19 · ‎08-24-2023

thanks for your reply. maybe I didn't explain clearly about my variables. actually my outcome variable is "cc". The years of drug, category of drug, education and weight are predictors. Besides, I also want to add the interaction term between years of drug use and category of drug as predictors in my model. Do you know whether it's possible to get odds ratio directly in SAS in this situation?

zihdonv19 · ‎08-24-2023

My data is like: data have; input group_num id cc years_on_drug category_drug$ weight education$; datalines; 1 1 1 3 A 55 high 1 2 0 6 B 56 low 1 3 0 8 C 45 mid 2 4 1 12 C 78 mid 2 5 0 2 C 88 mid 2 6 0 1 A 54 mid 3 7 1 3 B 66 low 3 8 0 2 A 64 high 3 9 0 16 C 65 high 4 10 1 9 A 70 mid 4 11 0 7 A 78 low 4 12 0 4 B 79 mid 5 13 1 5 B 80 high 5 14 0 2 C 64 low" 5 15 0 1 C 83 low" ; run; I have R code below to run a conditional logistic regression model with categorical*continuous interaction term: model = clogit ( cc ~years_on_drug:category_drug + education + weight+ strata (group_num), data=have) model I want to use SAS to get the same output as in R (odds ratios rather than coefficients), could anyone help with this?

zihdonv19 · ‎08-18-2023

I want to keep all rows of same id as long as this id has at least one record of type=2. The dataset I have is: data have; input id type visit_date :yymmdd10.; format visit_date yymmdd10.; datalines; 1 1 2000-01-01 1 2 2005-01-02 1 2 2006-01-03 1 3 2007-01-04 1 5 2010-01-05 2 . 2000-01-06 2 . 2000-01-07 2 . 2000-01-08 3 2 2001-01-09 3 . 2006-01-10 3 2 2007-01-11 3 . 2008-01-12 4 . 2006-01-10 4 3 2007-01-11 4 1 2008-01-12 5 2 2007-01-11 5 2 2008-01-12 5 2 2009-01-10 5 2 2010-01-11 6 2 2002-01-12 6 1 2003-01-10 6 . 2004-01-11 ; What I want: data have; input id type visit_date :yymmdd10.; format visit_date yymmdd10.; datalines; 1 1 2000-01-01 1 2 2005-01-02 1 2 2006-01-03 1 3 2007-01-04 1 5 2010-01-05 3 2 2001-01-09 3 . 2006-01-10 3 2 2007-01-11 3 . 2008-01-12 5 2 2007-01-11 5 2 2008-01-12 5 2 2009-01-10 5 2 2010-01-11 6 2 2002-01-12 6 1 2003-01-10 6 . 2004-01-11 ;

zihdonv19 · ‎08-16-2023

Thank you @ballardw and @SaSoDude for your solutions and discussion! I learned a lot! Here I also want to share my solution that I came up with just now, which is kinda redundant, but seems also work: data have; input id weight visit_date :yymmdd10.; format visit_date yymmdd10.; datalines; 1 55 2000-01-01 1 76 2005-01-02 1 80 2006-01-03 1 62 2007-01-04 1 75 2010-01-05 2 . 2000-01-06 2 . 2000-01-07 2 . 2000-01-08 3 57 2001-01-09 3 . 2006-01-10 3 69 2007-01-11 3 . 2008-01-12 ; data temp; set have; weight1=weight; if weight1=. then weight1=9999; keep_=0; if weight1^=9999 then keep_=1; run; proc sql; create table temp1 as select *, range(weight1)=0 as constant from temp group by id; quit; data temp2; set temp1; if constant=1 and weight1=9999 then keep_=2; run; data temp3; set temp2; if keep_=1 or keep_=2; run; data want; set temp3; by id; if (first.id and keep_=2) or keep_=1 then output; drop keep_ constant; run;

zihdonv19 · ‎08-15-2023

thank you for pointing out. Will use code next time! The conditions are: To keep all the rows that "weight" is not missing. And, If for the same id, all the "weight" are missing, then only keep the first row of this id.

zihdonv19 · ‎08-15-2023

The "visit_date" is sorted by "id". The conditions are: To keep all the rows that "weight" is not missing. And, If for the same id, all the "weight" are missing, then only keep the first row of this id. What I have: data have; input id weight visit_date :yymmdd10.; format visit_date yymmdd10.; datalines; 1 55 2000-01-01 1 76 2005-01-02 1 80 2006-01-03 1 62 2007-01-04 1 75 2010-01-05 2 . 2000-01-06 2 . 2000-01-07 2 . 2000-01-08 3 57 2001-01-09 3 . 2006-01-10 3 69 2007-01-11 3 . 2008-01-12 ; What I want: id weight visit_date 1 55 2000-01-01 1 76 2005-01-02 1 80 2006-01-03 1 62 2007-01-04 1 75 2010-01-05 2 . 2000-01-06 3 57 2001-01-09 3 69 2007-01-11

zihdonv19 · ‎08-08-2023

Hi! For unique id, I want to keep the record; for non-unique id, I want to keep the records with non-missing date. Could anyone help with it? Thank you!! What I have: id date 1 . 2 . 2 2000-06-10 2 2002-08-26 3 2010-02-03 4 . 4 2000-06-10 4 2005-07-26 4 2016-04-03 What I want: id date 1 . 2 2000-06-10 2 2002-08-26 3 2010-02-03 4 2000-06-10 4 2005-07-26 4 2016-04-03

zihdonv19 · ‎08-07-2023

Thanks for you reply Tom. Your solution works! May I further ask does "if last.lopnr and not other" always do the same as "if last.lopnr and other=0"?

zihdonv19 · ‎08-07-2023

Hi! Thanks for your reply. The output I'd like to have is: id 282 299 Rows 1 and 2 should not be in the output, because the atc value for id "233" is not restricted to "A10A". For example, id 233 also has atc value of "C05", "V90A" etc.

Online Status	Offline
Date Last Visited	‎10-08-2024 05:24 PM

Re: merge rows with condition

Re: merge rows with condition

Re: merge rows with condition

merge rows with condition

calculate 75 percentile of a variable using proc sql

proc sql join multiple datasets

Proc genmod with categorical covariates

Re: Stratified analysis using proc genmod

Stratified analysis using proc genmod

Re: How to get description for all the variables in the dataset?

Re: merge rows with condition

Re: merge rows with condition

Re: merge rows with condition

Re: proc sql join multiple datasets

Re: proc sql join multiple datasets

Re: How to export data to Microsoft Excel using the SAS/ACCESS XLSX en...

Re: How does "SPLIT=options" work?

calculating mean by id and year

Re: select rows with condition

Re: select rows with condition

Re: select rows with condition

select rows with condition

Estimating an odds ratio for a variable involved in an interaction

Re: Transfer R code (conditional logistic regression with interaction ...

Transfer R code (conditional logistic regression with interaction term...

Delete rows with condition

Re: Delete rows with condition

Re: Delete rows with condition

Delete rows with condition

Delete row with condition

Re: How to extract id number based on another variable?

Re: How to extract id number based on another variable?