Hey guys,
So I have a quick question. The same dataset and model fit perfectly well in stata using the whole gamut of specs but in SAS 9.22 and EG4.3 it givs an error
Error:
ERROR: Each observation for time point date=19940103 has a missing value for at least one
variable in MODEL statement .
NOTE: The SAS System stopped processing this step because of errors.
Code:
------------------------
ROC TSCSREG DATA = WORK.SORTTempTableSorted
OUTEST=WORK.TSCSPanelDataAnalysisXSH_EQUIV_F(LABEL="Panel Data Analysis of WORK.XSH_EQUIV_FIN_FULL_REG_NOMISS") CORROUT;
MODEL RET= curr_fund_dret equiv_pct_dvol pdvol_inter VWRETD /
FIXONE
FIXTWO
RANONE
RANTWO
CORRB
;
ID ticker date
;
/* -------------------------------------------------------------------
End of task code.
------------------------------------------------------------------- */
RUN; QUIT;
-----------------------
I tried Proc Panel, still the same, tried all different fixed random effects still the same thing. Apparently if for the first observation its where the series start one of the variables has missing values for all groups. But this shouldn't matter at all! The valid data will just be limited to the ones where the observations have values for all variables in the model, right? Maybe it tried to fit the model day by day not that it would make any sense? some sort of missing option or something?
I may post some data but it's big and with no attachments and no table markup available, it's gonna be a mess.
Would greatly appreciate any help!
Thanks!