Most of variables has two levels.   It seems that SAS discretizes deu_spl (it appeared 7 levels), if it does, how are built those levels ?   Also, now there are results for Type III Tests of Fixed Effects.   ... View more

Yes, the code works OK, excepting the deviance analysis.   There are 1815 events and 742 nonevents.   ... View more

Program is   proc gam data=modelo2; class viv act iess prov gen civil edu trab; model tipo (event='1')=spline(deuda_6m) param(viv)param(act)param(iess)param(prov) param(gen)param(civil)param(edu)param(trab) / dist=binomial link=logit maxiter=10000 maxitscore=200000; output out=result pred linp uclm lclm adiag std; score data=result out=result; run;   I tried to attach the file sas modelo2, but I was not able. I can send it by email.   Table of deviance analysis gives no result, excepting DF. Why ?   I found that if the anodev=norefit is included among the options of the sentence model, then a result for this table is obtained.       ... View more

x = "x"; defines variable x to be written in excel. ... View more

I tried it but it does not work. However I succed to write in excel using range names ! The problem is that I need to define a number of range names in my excel template. ... View more

Thank you for the answer, but I do not have any of those problems. About the sentence x '"c:\program files (x86)\microsoft office\office14\excel.exe"'; that is only to open excel, but even that can de done manually. Executing only filename avg1 dde 'excel|US!r235c15:r235c15'; data _null_;   file avg1;   x = "x";   put x; run; SAS log shows: NOTE: The file AVG1 is:       DDE Session,       SESSION=excel|US!r235c15:r235c15,RECFM=V,       LRECL=256 NOTE: 1 record was written to the file AVG1.       The minimum record length was 1.       The maximum record length was 1. NOTE: DATA statement used (Total process time):       real time           0.32 seconds       cpu time            0.03 seconds apparently record was written, but cell (235;15) is still empty. Further, I do not use a sleep function. ... View more