Hi,  How to I make a residuals plot for a logit model? I only found this link. But I would like to plot the residuals against one of the independent variables, not just "by case number". What options do I use?   Thanks in advance. ... View more

Dear all,   I have a dataset scored using several (external) models for predicting probabilities that a certain event occurs. That is, in the dataset I have the binary target variable as well as predicted probabilities from the models, say p_M1, p_M2, .... Now in order to compare these models, I want SAS to compute several fit statistics, like AUC, MSE, AIC. The code below (inspired by https://blogs.sas.com/content/iml/2018/11/14/compare-roc-curves-sas.html) shows me the ROC curves, and AUC values. How do I obtain the other statistics?     proc logistic data=dataset; model target (event='1') = p_M1 p_M2 / nofit; roc 'Model 1' pred=p_M1; roc 'Model 1' pred=p_M1; run;           not necceceralily obtained by logistic regression. I want to use    ... View more

Inspired by the answer to my previous question, I was wondering how to save the graphics produced by ODS, e.g. the DiagnosticsPanel produced by PROC REG. Can I turn it into a png and save it to my C drive?   Thanks,  Dimitri ... View more

Hi,  I'm using proc model to perform linear regression and want to apply the so-called White test that checks whether the residuals have constant variance. Now I want these statistics in a dataset, so that I can use them for later processing, but how?   I have something of the form:   proc model data=dataset;     parms b0 b1;     y = b0 + b1*x;     fit y / white ;   run;   and I am interested in getting the following output values in a dataset:     Do you know how to do that?   Thanks in advance ... View more

Hi all,  I want to add a version number to the dataset I generate. A version number contains dots. Is that allowed?   If so, how to get it done?   I tried this: %let versionnr = v2.8; %let eversionnr = %sysfunc(tranwrd(&versionnr,'.','p0.5'n));   data aa_&eversionnr; aa = 1; run;   But I get the error message: ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, /, ;, _DATA_, _LAST_, _NULL_.    Thanks, kind regards, Dimitri ... View more

Hi all,    I have a (small) dataset with a datavariable x, of type string. I want to use its values to select data from another (big) set. Doing an inner join as follows seems to be too time-consuming. proc sql; create table aa as select a.* from big a inner join small b on a.x = b.x ; quit; Is there a better way? For example, first put the x values from the small set into a macro list, and then subset on the big one using a where statement.   Thanks in advance.   Dimitri ... View more