BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Dcicantab5
Obsidian | Level 7

Hi,

Can anyone help?

I have a binary dependent variable (outcome of interest: severe dengue) with independent continuous variables (admission Hct, admission AST, admission ALT and AST^2/ALT). 365 observations.

 

1. How do you get diagnostic test evaluation (sens, spec, NPV, PPV, LR+, LR-, AUC of ROC) with their 95% CI?

2. Is there a way to do it straight from the raw data table without creating separate dummy tables for each independent continuous variable? - how do you partition a continuous variable eg AST^2/ALT with interval of 100.

 

Help much appreciated!

1 ACCEPTED SOLUTION

Accepted Solutions
FreelanceReinh
Jade | Level 19

Hi @Dcicantab5,

 

Given that your independent variables are continuous, I would start with PROC LOGISTIC and compute ROC curves for each continuous independent variable. (Later you can continue with multiple logistic regression models in order to define new predictors involving two or more independent variables.) I did this with SAS 8.2 (and other statistical software) long ago, but relevant new features have been added to PROC LOGISTIC in SAS 9.2: please see this paper. This includes the calculation of the AUC together with a confidence interval.

 

The question of finding an optimal cut-point (to dichotomize a continuous independent variable) is discussed in this recent paper

 

Once you have determined a cut-point, you have a 2x2 table and you can present sensitivity, specificity etc. for this cut-point.

View solution in original post

3 REPLIES 3
Reeza
Super User

Here's how you calculate it, based on a 2x2 table. 

http://support.sas.com/kb/24/170.html

 

If you have continuous variables you'll need to categorize them somehow? You can use proc format for this so, yes, you can do it straight from the raw table. 

 

 

Dcicantab5
Obsidian | Level 7

 Ok, gotcha on the link you provided, thanks. 

Now I am stuck again; the example in the link has binary outcome (same as mine) and BINARY predictor (vs. mine is continuous).

Do you know of similar guide on how to categorize the continuous independent variables into categories (ranges, eg 0-100, 101-200, 201-300,..) using PROC FORMAT? Now, let's say i have done the categorizing of a continuous variable, (?)INFMT, it MAY contain both options of the binary outcome e.g. range 201-300 may contain both outcome severe dengue and non-severe. How do i deal with that?

 

help very much needed!

FreelanceReinh
Jade | Level 19

Hi @Dcicantab5,

 

Given that your independent variables are continuous, I would start with PROC LOGISTIC and compute ROC curves for each continuous independent variable. (Later you can continue with multiple logistic regression models in order to define new predictors involving two or more independent variables.) I did this with SAS 8.2 (and other statistical software) long ago, but relevant new features have been added to PROC LOGISTIC in SAS 9.2: please see this paper. This includes the calculation of the AUC together with a confidence interval.

 

The question of finding an optimal cut-point (to dichotomize a continuous independent variable) is discussed in this recent paper

 

Once you have determined a cut-point, you have a 2x2 table and you can present sensitivity, specificity etc. for this cut-point.

sas-innovate-2024.png

Don't miss out on SAS Innovate - Register now for the FREE Livestream!

Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.

 

Register now!

What is ANOVA?

ANOVA, or Analysis Of Variance, is used to compare the averages or means of two or more populations to better understand how they differ. Watch this tutorial for more.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 3 replies
  • 2127 views
  • 4 likes
  • 3 in conversation