About TJ87

Reeza · ‎05-03-2017

For pre written macros search lexjansen.com and clinical reports or summary tables. You'll find a ton of papers with detailed explanations. There's one that's a great reference: Creating Complex Reports by Cynthia Zender. FYI - as phrased, your question isn't coming across as help me do something I can't do, but can you please do my work? Obviously this is up to people how they respond to questions of this nature.

TJ87 · ‎02-10-2017

Wow thanks I'll give this a try.

TJ87 · ‎10-20-2016

Hi Reeza, My understanding is that this will give all combinations in one model: y=a b c a*b a*c b*c Is that correct? I'd like to model each product term separately. y(1)=a b a*b y(2)=a c a*c y(3)=b c b*c Thanks.

TJ87 · ‎08-09-2016

I think the trick is that the program needs to take the difference between age and the next highest age per ID (in this example, from 18 to 25), but I don't know how to code that.

Reeza · ‎08-03-2016

@TJ87 wrote: Hi Reeza, but I'd like to be able to use a binary variable for the comparison of interest. The OddsRatio doesn't give you the correct comparison? proc logistic data=have; class var_quartile (ref="1") /param=ref; model outcome (event="1")= var_quartile; oddsratio var_quartile; run;

Reeza · ‎07-13-2016

Change your select statement to select * from...

TJ87 · ‎06-24-2016

This works, too! Thanks!

Astounding · ‎10-02-2015

Assuming that LOGISTIC has no options to simplify the task, you can create the interactions without using macros: data want; set have; array original {10} B1-B10; array inters {10} inter_1 - inter_10; do _k_=1 to 10; inters{_k_} = A * original{_k_}; end; run; proc logistic data=want; model event = A B1-B10 inter_1 - inter_10; run;

TJ87 · ‎10-23-2014

Thank you, Reeza!

stat_sas · ‎06-21-2014

data want(drop= i x rename=(y=x)); set have; i=1; do while (scan(x,i,'or ') ne ' '); id=_n_; y=scan(x,i,'or '); output; i=i+1; end; run;

TJ87 · ‎05-31-2014

Cool, thank you Reeza.

TJ87 · ‎01-20-2014

Thank you. I found this link to be especially helpful for testing multiple independent variables.

TJ87 · ‎09-24-2013

Thank you for your responses! Proc sql worked great.

Rick_SAS · ‎01-21-2014

Perhaps I'm missing something, but if you just want 9 different independent analyses, transform the data into a long data set with SITE=A-I and use a BY statement with SITE as the BY variable. If you want to specify a single model that incorporates the sites, you can specify SITE as a CLASS variable and include interactions between the variables and the sites. Lastly, if SITE is a random variable, rather than a fixed effect, you might want to look at using PROC GLIMMIX instead of PROC LOGISTIC. has posted many examples of using PROC GLIMMIX.

Online Status	Offline
Date Last Visited	‎08-28-2017 04:31 PM

Macro for Proc Freq and Proc Means

Re: LASSO Cox proportional hazards model

LASSO Cox proportional hazards model

Re: Product terms as all combinations of two variables in regression

Product terms as all combinations of two variables in regression

Re: Calculate cumulative exposure time

Re: Calculate cumulative exposure time

Calculate cumulative exposure time

Re: Proc Logistic categorical variable

Proc Logistic categorical variable

Re: Product terms as all combinations of two variables in regression

Re: Subset for multiple observations per subject

Re: Subset for multiple observations per subject

Re: Subset for multiple observations per subject

Re: Simple macro for interaction

LASSO Cox proportional hazards model

Re: Macro for Proc Freq and Proc Means

Re: LASSO Cox proportional hazards model

Re: Product terms as all combinations of two variables in regression

Re: Calculate cumulative exposure time

Re: Proc Logistic categorical variable

Re: Proc Sql Create table for duplicates across multiple variables

Re: Subset for multiple observations per subject

Re: Simple macro for interaction

Re: Subset significant confidence intervals

Re: Create new observation from 'or' statement

Re: Cumulative Income Calculation

Re: How to write a Macro that outputs statistics across many variables

Re: Identify unique values between two variables

Re: How to code for many regression models with similar variables