About Denali

Denali · ‎08-03-2020

Hi, The indentified variable is currently listed as character $500. How can I shorten the length to $8 and add leading zeros to those numbers shorter than 8 characters? Thank you. proc contents results: record_id Char 500 $500. Proc print results: Obs record_id 1 25481 2 27775 3 167205 4 168552 5 195018 6 293336 7 303971 8 336269 9 360908 10 362220 11 00362383 12 370550 13 447997 14 00496297 15 499403 16 506068 17 506914 18 514282 19 525407 20 584554 21 681037 22 775671 23 788309 24 840175 25 862188 26 35044537

Denali · ‎07-29-2020

@PaigeMiller I checked but nobody has done it in SAS before. Thank you for your help.

Denali · ‎07-29-2020

Hi @ballardw , The code worked, but the variables are ordered from A to Z. Is there a way that we can order them by the original order? Also, I was running another set of macro for all the continuous variables (previous code was for categorical variables with class statement). When I exported the ORs and 95% CIs, why all the ORs and 95% CIs from the categorical variables were all included in the Excel file even I changed the name of the file? Is there a way that I can export all the continuous variables in a seperate Excel file? Please see my code for continuous variables below: %macro IP1(x=); ods select cloddswald; ods output cloddswald=odds_&x.; proc logistic data = CP1; model improve = &x. /rl; run; %mend IP1; %IP1(x=Age); %IP1(x=Pre_Score); ods excel close; data toprint1; length effect $ 40; set odds_: ; run; ods excel file="H:\Data\CI_Continuous.xlsx" options(sheet_interval='NONE'); proc print data=toprint1; run; ods excel close; Thank you!

Denali · ‎07-29-2020

Hi @PaigeMiller , I was going to use the code under Figure 4 that you posted, but I noticed the data (shown in Figure 5) is much cleaner than mine. My time zero is "Date of Disease Diagnosis", and my primary interest is the treatment date for Drug E. But Drug A-D could be given before and after Drug E. I am not sure how to insert the dates of receiving Drug A-D into the figure. Should I calculate the time between Drug E and other drugs?

Denali · ‎07-29-2020

Hi @ballardw , Thanks for the code. I successfully exported ORs and 95% CIs into the Excel file, but it's not in the format that I desire. I have exoported all the HRs and 95%CIs from Cox Proportional Hazard Ratio models into an Excel file (see below photo), and the Hazard Ratios, Lower CI and Upper CI were exported into 3 columns. I am hoping to export ORs and 95% C.I. into 3 columns like this example. If we can merge all 3 columns into this format OR(95% C.I.) = 0.89 (0.29-2.74), that would be even better. Thank you!

Denali · ‎07-29-2020

Hi, Here is the sample graph that I would like to generate:

Denali · ‎07-29-2020

Hi, I would like to visualize patient's date of hospitalization, usage of drug (Drug A-E) and the dates when they died or discharged from the hospital end points. I also have a smoking variable that I want to use as group comparison (smoker vs. non-smoker). Sorry I forgot to post this variable in the first posting. Please see the following link as an example: https://www.nejm.org/doi/full/10.1056/NEJMoa2007016 If you cannot see the contents in the website, please dowland the attached Excel file.

Denali · ‎07-29-2020

Hi, I would like to produce a timeline plot using the below dates. Could anyone please help me with the coding? Thank you so much! ID Drug_A Drug_B Drug_C Drug_D Date of Disease Diagnosis Date of Hospitalization Drug_E Given Date Recovery Date of Death Date of Discharge 38015709 4/9/2020 4/21/2020 4/10/2020 4/2/2020 4/8/2020 4/17/2020 4/22/2020 4/29/2020 38002849 4/15/2020 4/17/2020 4/15/2020 4/15/2020 4/20/2020 4/24/2020 4/27/2020 4/27/2020 38085888 4/10/2020 4/7/2020 4/10/2020 4/17/2020 4/25/2020 4/29/2020 35580777 4/4/2020 4/19/2020 4/25/2020 4/26/2020 4/26/2020 35666671 4/8/2020 4/8/2020 4/23/2020 4/26/2020 4/30/2020 35452169 4/7/2020 4/25/2020 4/26/2020 4/27/2020 4/27/2020 35522178 4/21/2020 4/17/2020 4/21/2020 4/24/2020 4/28/2020 4/28/2020 38033034 4/20/2020 4/24/2020 4/26/2020 4/28/2020 4/28/2020 35406667 4/15/2020 4/15/2020 4/21/2020 4/28/2020 4/29/2020 35222190 4/9/2020 4/10/2020 4/17/2020 4/28/2020 4/28/2020

Denali · ‎07-29-2020

Hi SAS experts, I have zero experience in meta-analysis. Would you receoomend people that SAS is a great tool for it? So far none of my colleagues is using SAS, but I am more comfortable with using SAS. Could anyone please receommend me any readings, code or point me toward the right direction? Thank you very much in advance.

Denali · ‎07-29-2020

All the 40 ORs and 95% CIs in a single tab in an Excel file. Could you help me to modify my code? Thank you.

Denali · ‎07-29-2020

Hi, I have about 40 variables for the univariate logistic regression model so I wrote up a simple macro for it. But I don't know how to export all the OR(95% C.I.) into an Excel file. Could you please help me with it? Below is my SAS macro: %macro IP(x=); proc logistic data = CP1; class &x; model improve = &x /rl; run; ods output close; ods graphics on; %mend IP; %IP(x=Age_C); %IP(x=Gender); %IP(x=Disease_Type); %IP(x=Disease_Status); %IP(x=Active_Therapy); %IP(x=Blood_Type_A); Thank you very much in advance.

Denali · ‎07-04-2020

Bravo! It worked! THANK YOU SO MUCH!!!

Denali · ‎07-02-2020

Hi @Oligolas , Thank you so much for the code! Could we optimize it and put all the HR(95%CI) in one single tab in the Excel? Maybe "append" all the HR(95% CI)? At the moment, the code exported all the HRs and 95% CIs into seperate tabs by outcome (gender, active therapy). Thanks again!

Denali · ‎07-01-2020

Hi, I wrote a simple macro for Proc Phreg function below. I would like to export the HR (95% C.I.) for all variables in one Excel file. Could anyone please help me with the code? Thank you all in advance. %macro HR(x=); proc phreg data = CP1; class &x; model Time*Event(0) = &x /rl; run; %mend HR; %HR(x=Gender); %HR(x=Disease_Type); %HR(x=Disease_Status); %HR(x=Active_Therapy);

Denali · ‎06-11-2020

Hi @PGStats , It worked!!! Thank you so much!!!

Online Status	Offline
Date Last Visited	‎10-16-2024 06:29 PM

Re: Time-varying covariate in Cox model (no drug, receiving drug at ba...

Time-varying covariate in Cox model (no drug, receiving drug at baseli...

Unable to convert all character values to date format mmddyy10.

How to delete participants who did not complete more than 60% of the s...

Conver Char to mmddyy10.

How to conduct a time-to-event survival analysis in a 1:2 matched case...

Re: How to conduct a conditional logitic regression model on a 1:2 mat...

Re: How to conduct a conditional logitic regression model on a 1:2 mat...

Re: How to conduct a conditional logitic regression model on a 1:2 mat...

How to conduct a conditional logitic regression model on a 1:2 matched...

Re: Unable to convert all character values to date format mmddyy10.

Re: How to delete participants who did not complete more than 60% of t...

Re: ERROR: More positional parameters found than defined.

Re: ERROR: More positional parameters found than defined.

Re: ERROR: More positional parameters found than defined.

How to use MACRO or SQL to convert thousands of numeric to character v...

How to shorten identifier length and add leading zeros?

Re: How to produce a timeline plot?

Re: How to export all the OR(95%.CI) into an Excel file from a macro?

Re: How to produce a timeline plot?

Re: How to export all the OR(95%.CI) into an Excel file from a macro?

Re: How to produce a timeline plot?

Re: How to produce a timeline plot?

How to produce a timeline plot?

Meta-analysis

Re: How to export all the OR(95%.CI) into an Excel file from a macro?

How to export all the OR(95%.CI) into an Excel file from a macro?

Re: How to export HR (95% CI) from Proc Phreg Macro

Re: How to export HR (95% CI) from Proc Phreg Macro

How to export HR (95% CI) from Proc Phreg Macro

Re: Univariate logistic regression using time variable with hr:min:sec...