In E-Miner, I see 2 selections in the Model Comparison node:   - Average Squared Error - Mean Squared Error   What is the difference?   Searching the HELP does not yield any decent description:   ----->8  snip from HELP file ------------------------------ The Selection Statistic choices are as follows: Default — The default selection uses different statistics based on the type of target variable and whether a profit/loss matrix has been defined. If a profit/loss matrix is defined for a categorical target, the average profit or average loss is used. If no profit/loss matrix is defined for a categorical target, the misclassification rate is used. If the target variable is interval, the average squared error is used. Akaike's Information Criterion — chooses the model with the smallest Akaike's Information Criterion value. Average Squared Error — chooses the model with the smallest average squared error value. Mean Squared Error — chooses the model with the smallest mean squared error value.   ----->8  snip from HELP file ------------------------------           ... View more

I love SAS for it's arrays. I use it often to make imputations like this:  (change missing to the value 75)   data want; set have; array change [*] x1-x999; do over change; if change=. then change=75; end; run; But what if, instead of changing to 75, I wanted impute to the minimum value of x.    Thinking about this hurts my brain because I know that array is moving "sideways" and I'm looking for a whole dataset aggregation to obtain the minimum.    I'm sure I could hack someting together, but I'm really worried about effiecency due to my dataset size. ... View more

I've read the papers but have been a little stuck on some minor syntax issues. I'm trying to figure out how to take an existing data step and thread it using DS2:   First, some fake data:   data have; input IdNumber Name $ 6-20 Team $ 22-27 StartWeight EndWeight; datalines; 1023 David Shaw red 189 165 1049 Amelia Serrano yellow 145 124 1219 Alan Nance red 210 192 1246 Ravi Sinha yellow 194 177 1078 Ashley McKnight red 127 118 1221 Jim Brown yellow 220 . ; run;   Here is the data step code I'm trying to migrate into a threaded process using DS2:   data want; set have; if Name = 'David' then David_Flag=1; else David_Flag=0; WeightDiff=EndWeight-StartWeight; run; ... View more

I am writing a macro with a rather complicated IF statement - however I noticed when I put comments inside I get this annoying error:  ERROR: There is no matching %IF statement for the %ELSE.   I really dont have the option to *not* write comments, is there some other way I can do this? %global testvar; %global check; %let testvar=5; %MACRO printme(check); %IF &testvar=1 %THEN %DO; %let check = 1; %put testvar is &testvar and check was ✓ %END; * comment ; %ELSE %IF &testvar=2 %THEN %DO; %let check = 1; %put testvar is &testvar and check was ✓ %END; * comment ; %ELSE %IF &testvar=3 %THEN %DO; %let check = 1; %put testvar is &testvar and check was ✓ %END; * comment ; %ELSE %IF &testvar=4 %THEN %DO; %let check = 1; %put testvar is &testvar and check was ✓ %END; * comment ; %ELSE %IF &testvar=5 %THEN %DO; %let check = 1; %put testvar is &testvar and check was ✓ %END; * comment ; %ELSE %IF &testvar=6 %THEN %DO; %let check = 1; %put testvar is &testvar and check was ✓ %END; * comment ; %ELSE %IF &testvar=7 %THEN %DO; %let check = 1; %put testvar is &testvar and check was ✓ %END; * comment ; %ELSE %IF &testvar=8 %THEN %DO; %let check = 1; %put testvar is &testvar and check was ✓ %END; * comment ; %ELSE %DO; %let check = 1; %put testvar is &testvar and check was ✓ %END; %MEND printme; %printme;   ... View more

I have a rather complicated program that I run, it will iterate through a list of variables and do certain things...   One of those things I want to do, is create a scatterplot, so when I'm all done I can open up my HTML results and see a whole list of scatterplots that it created.   For some reason, my code works fine but the scatterplots never appear. In fact I get no HTML results whatsoever (the default in my case) options source NOnotes NOserror; %macro plotting(datasetname,xvar,yvar); proc sgscatter data=&datasetname); title "&xvar versus &yvar"; plot (&xvar)*(&yvar) / pbspline; run; %mend plotting; %macro main; * do stuff; %plotting(&datasetname,&xvar,&yvar); %mend main;   ... View more