I am labeling variables with LABEL statement. It labels correctly but it is not shown in the data set. What i mean - The variable label should be dispayed instead of variable name when i open data set. Can both be displayed when someone point cursor on the variable? I am using SAS EG5.1.
... View more
I am using EG5.1. Is there a way we can delete excel file that is already saved on a server? I am using the code below. I want to delete XLS if it exists already in this path - /fts/sas/bhandari/. ODS HTML FILE = "/fts/sas/bhandari/results.xls"; PROC PRINT DATA = A; RUN; PROC PRINT DATA = A; RUN; ODS HTML CLOSE; Is there a better way to output the result in a single data set or excel file? I have 2-3 tables. I want to stack the results. Each output is structured differently. I cannot use SET statement to combine them. Thanks in anticipation!
... View more
I want to check categorical variable distribution over a period of time. For example, the distribution of variable district code has changed over a period of time ( Time 0 - Period of model Development, time1 - after one year). I perform the following analysis for numeric variables. Step 1 - Rank variable into 10 group (decile) Step 2- (% of records based on variable in Scoring Sample (A) - % of records based on variable in Training Sample (B)) * In(A/ B) Step 3 - Then sum up the scores in step2 on 10 groups I'm little bit skeptical about the same analysis for categorical variables. I guess chi square analysis isn't correct technique to check it. Am i correct? What's the correct way?
... View more
Thanks a ton. It works like charm. Could you please explain how it works - if Variable = "Intercept" then eq = catx(" + ", Eq, Estimate); else eq = catx(" + ", Eq, catx(" * ", Estimate, Variable)); end;
... View more
I want to generate logistic regression equation based on coefficient estimates. I am trying to find automate solution - The coefficient estimates are stored in a dataset. They look like below - Variables Estimate Intercept 0.001 ABCD 0.558356 DEFG 0.464783 HIJKL 0.111268 MNOP 0.811915 score = 0.001 + 0.558356 * ABCD + 0.464783 * DEFG + 0.111269 * HIJKL + 0.811915 * MNOP p = 1 / (1 + exp(-score)) I want the following equation to be stored in a separate data set. In this data set, there would be a single column named "Equation" and first row contains the equation: P_1 = 1 / (1 + exp( -(0.001 + 0.558356 * ABCD + 0.464783 * DEFG + 0.111269 * HIJKL + 0.811915 * MNOP)) Note : I am aware of SCORE, OUTMODEL and INMODEL statements in PROC LOGISTIC to calculate predicted probability. But my task is to note down the equation based on estimates.
... View more
Thanks a bunch for your detailed answer. Last question - Where output file is saved? The file in which predicted probability (P_1) against each row is stored. Does it calculate automatically? I didn't find any option to look at probability column.
... View more
I have two data sources (data sets). One is a training dataset in which i have developed a decision tree model. The other one is a out-of-time validation sample. I am trying to calculate AUC based on predicted probabilities drawn from model on training sample. In SAS enterprise miner, there is an option to define % of data for training, validation and test. But i have these samples in two separate datasets. How can i calculate AUC on out-of-time sample? And where predicted probability column is saved against each rows?
... View more
Is it possible to write IF-THEN-ELSE statement under any procedure? %macro (depvar=,numvars=,charvars=); proc logistic data = abc descending; class &charvars / param = ref; model &depvar = &numvars &charvars / selection = stepwise; run; %mend; I want the following statement wrapped in IF THEN condition. It should run only if an user specify variable(s) in CHARVARS parameter in the macro. class &charvars / param = ref; Something like this : proc logistic data = abc descending; %IF countw(&charvars) = 0 %THEN; class &charvars / param = ref; %END; model &depvar = &numvars &charvars / selection = stepwise; run;
... View more
I am unable to drag data source table to a diagram in E-miner. It is not being pulled. It is not throwing any error. Is there any alternative to add table to a diagram?
... View more
In SAS website, it states that brier score is the weighted squared difference between the predicted probabilities and their observed response levels. SAS/STAT(R) 9.3 User's Guide Does it take into account the event rate (% of events)? Can i safely use cutoff .09? Brier score less than .09 is acceptable.
... View more
Proc logistic returns brier score with fitstat option. My question - Can we set cutoff to check model calibration? What i understand it is sensitive to % of events. For example, for 50% event rate model, brier score less than 0.09 considers satisfactory. Does it exist for 10% event rate model? Does SAS generate scaled brier score?
... View more
Hi Experts, I have 2 datasets - file1 and file2. I want to compare the text appeared in variable. File1: Variable A B C D E F G File2 Variable A B D E G I want the macro to return "C and F not found" based on the data shown above. If no mismatch found, it should return "No mismatch".
... View more
