I am receiving a very frustrating SAS error when trying to use PROC PANEL."Expecting a name" I have created some sample code that reproduces the error. Any ideas on what I'm missing? 876        PROC SORT DATA=TEMP OUT=TEMPSORTED; 877         BY OBS_DATE; 878        RUN; NOTE: There were 26 observations read from the data set WORK.TEMP. NOTE: The data set WORK.TEMPSORTED has 26 observations and 2 variables. NOTE: PROCEDURE SORT used (Total process time):       real time           0.02 seconds       cpu time            0.01 seconds 879        880        PROC PANEL DATA=TEMPSORTED; 881         ID OBS_DATE;                        _                        22 ERROR 22-322: Expecting a name. 882         LAG DEGREES_F(1) / OUT=TEMP_W_LAG; ERROR: Variable NAME not found. 883        RUN; NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE PANEL used (Total process time):       real time           0.06 seconds       cpu time            0.00 seconds Here is an entire section of code which reproduces the error: DATA TEMP;     INPUT OBS_DATE mmddyy10. DEGREES_F @17;     FORMAT OBS_DATE mmddyy10.;     datalines; 11/01/2014  44 11/02/2014  53 11/03/2014  64 11/04/2014  61 11/05/2014  63 11/06/2014  52 11/07/2014  45 11/08/2014  49 11/09/2014  53 11/10/2014  65 11/11/2014  61 11/12/2014  33 11/13/2014  31 11/14/2014  29 11/15/2014  33 11/16/2014  33 11/17/2014  25 11/18/2014  21 11/19/2014  33 11/20/2014  30 11/21/2014  36 11/22/2014  54 11/23/2014  54 11/24/2014  51 11/25/2014  30 11/26/2014  32 ; PROC SORT DATA=TEMP OUT=TEMPSORTED;   BY OBS_DATE; RUN; ; PROC PANEL DATA=TEMPSORTED;   ID ;   LAG DEGREES_F(1) / OUT=TEMP_W_LAG; RUN; ... View more

When I run this statement on a dataset, I usually get 5 columns. TableVar, TableVarLabel, NLevels, NMissLevels, NNonMissLevels ods output nlevels=nlevelsds; proc freq data=LIB.DATASET nlevels; tables _all_/noprint; run; But when I change the dataset to a different dataset, I only get 3 columns!   TableVar, TableVarLabel, NLevels Why?  Would this happen if my dataset had no missing values? Is there a way to force these columns to appear? The unpredictable output is really giving me problems with programming and automation. ... View more

In SAS Enterprise Guide, when I run PROC LOGISTIC ...  the process spawns a bunch of temp table shortcuts to appear on my Process Flow work space. It's immensely annoying because it causes clutter and it always readjusts the positioning of my objects.  Any way to suppress this behavior? The temp tables are all named like... _DOCTMP000000000000000000000026 _DOCTMP000000000000000000000027 _DOCTMP000000000000000000000028 _DOCTMP000000000000000000000029 _DOCTMP000000000000000000000030 Sample code: %LET VARS = v1 v2 v3 v4; %LET OUTDATA = work.outdata; ods graphics on; proc logistic data=work.indata NAMELEN=32; model Y_VAR(event='1') = &VARS.   / SELECTION = STEPWISE rsq lackfit;     roc;   OUTPUT OUT=&OUTDATA. p=myPrediction ; run; title; title1; proc reg data=data=work.indata; model Y_VAR= &VARS. / TOL VIF COLLIN; run; ods graphics off; ... View more

I have a variable which has possible values of 1Y 2Y 3Y 4Y 5Y U <missing> I'm creating a new variable in a data step, like this: data want; set have; if var1 In('3Y','4Y','5Y') then newvar=1; else if var1=. THEN newvar=.; ELSE newvar=0; run; My problem is that the newvar becomes missing when in fact the original value was 1Y or 2Y.  But the newvar seems to actually be correct in the instance of it being in the IN() list. I get no errors, but I get a warning: Limit set by ERRORS=option reached. Further errors of this type will not be printed (makes no sense, because I'm not getting errors) I get a note for just about every row - Invalid numeric data, VAR1='1Y', at line xxxx column yyyy So - what in the world am I doing wrong that allows this to partially work? It works in the first list but apparently on the ELSE I am getting this weird note. ... View more

Anybody have any tricks to avoid the output from PROC LOGISTIC,  especially in the "Analysis of Maximum Likelihood Estimates" section. Sometimes, I have multiple variables such as: WoE_DV_EST_NUM_TYPE1 WoE_DV_EST_NUM_TYPE2 WoE_DV_EST_NUM_TYPE3 And when one of the variables shows up in this section, I have no idea which one it was! It will trim them off at a certain length Example of my code: (opening HTML result in Chrome) ods graphics on; proc logistic data=TRAINDATA; model YVAR(event='1') = X1 X2 X3 X4 ...   / SELECTION = STEPWISE rsq lackfit;     roc;   OUTPUT OUT=OUTPUTDATA p=myPrediction ; run; ods graphics off; ... View more