Dear All,   I just want to ask if anyone knows a website to download datasets related to predictive marketing and Economics.     Thanks, ... View more

So the endogenous statement in proc qlim is to specify that dependent variable on the left hand side of the equation is endogenous; proc qlim data = mydata itprint; title "enrolled logit regression model results"; class race gender; model curr_enrolled = age race gender; endogenous curr_enrolled ~ discrete (distribution = logit); output out =logit marginal proball; run;   how else can we accomplish the same results?     ... View more

thanks ... View more

Proc SQL; create table moth as Select distinct a.motherid, a.perid as kidid, a.tage as kidage, a.esex as kidgender, a.EHLTSTAT as kid_currhealth , a.EHOSPNIT as kid_nightsinhosp, a.EVISDOC as kid_docvisit from momkid a, wave5top b where a.motherid=b.perid and a.tage lt 18 order by a.motherid, a.tage; Quit;   Th log is not showing any errors its just showing 0 observations  0 rows 7 columns ... View more

proc sort data = waves; by ssuid eentaid epppnum srefmon; run; data wave5sipp (rename = (tage=tage1 tptotinc=ptotinc1 srefmon=srefmon1 )) wave6sipp (rename =(tage=tage2 tptotinc=ptotinc2 srefmon=srefmon2 )); set waves; select (srefmon); when (1) output wave5sipp; when (2) output wave6sipp; end; run;   log message:   ERROR: Unsatisfied WHEN clause and no OTHERWISE clause at line 2120 column 5. SSUID=019128000932 SWAVE=5 SREFMON=3 RHCALMN=5 SHHADID=11 TFIPSST=22 THOTHINC=0 RFID=3 RFNKIDS=0 RFOKLT18=0 EENTAID=11 EPPPNUM=101 ESEX=2 ERACE=1 EORIGIN=2 TAGE=47 ERRP=6 EMS=4 ETYPMOM=-1 ETYPDAD=-1 TPEARN=2800 TPTOTINC=2800 RENROLL=3 EEDUCATE=37 EJBHRS1=40 _ERROR_=1 _N_=5 NOTE: The SAS System stopped processing this step because of errors. NOTE: There were 5 observations read from the data set WORK.WAVES. WARNING: The data set WORK.WAVE5SIPP may be incomplete. When this step was stopped there were 2 observations and 25 variables. WARNING: Data set WORK.WAVE5SIPP was not replaced because this step was stopped. WARNING: The data set WORK.WAVE6SIPP may be incomplete. When this step was stopped there were 2 observations and 25 variables. WARNING: Data set WORK.WAVE6SIPP was not replaced because this step was stopped. ... View more

Whats the best way to import the data on this website https://download.bls.gov/pub/time.series/la/la.data.3.AllStatesS to SAS ... View more

Dear All,   I was trying to run this and I got this for the 3 matrices created "(Execution) Matrices has not been set a value";   proc iml; *part a; n = 10; x1 = j(10,1,1); x2 = {1, 2, 3, 4, 5, 6, 7, 8, 9, 10}; x = x1 || x2; M = 1000; B10 = j(M,1,0); T10 = j(M,1,0); title "Answer to part a"; print x1 x2 x M B10 T10; *part b; u = j(n,1,0); Btot = {1, 2}; Var = {2}; *part c; do i = 1 to M; call randgen(u,"normal",0,Var); y = (x*BTot) + u; b = inv((x`) * x) * (x`) * y; e = y - (x*b); b2 = b[2,1]; B10[i,] = b2; B2 = Btot[2,1]; se2 = ((e`) * e) * (1/(n - 2)); varb2 = s2 * b2; seb2 = sqrt(varb2); t2 = (b2 - B2) * (1/seb2); T10[i,] = t2; end; *part d; n = 100; x_1 = j(100,1,1); x_2 = repeat({1, 2, 3, 4, 5, 6, 7, 8, 9, 10}, 10); x = x_1 || x_2; M = 1000; B100 = j(M,1,0); T100 = j(M,1,0); u = j(n,1,0); Btot = {1, 2}; S = {2}; do i = 1 to M; call randgen(u,"normal",0,S); y = (x*B_pop) + u; b = inv((x`) * x) * (x`) * y; e = y - (x*b); b2 = b[2,1]; B100[i,] = b2; B2 = Btot[2,1]; se2 = ((e`) * e) * (1/(n - 2)); varb2 = se2 * b2; seb2 = sqrt(varb2); t2 = (b2 - B2) * (1/seb2); T100[i,] = t2; end; *part e; n = 1000; x1 = j(1000,1,1); x2 = repeat({1, 2, 3, 4, 5, 6, 7, 8, 9, 10}, 100); x = x1 || x2; M = 1000; B1000 = j(M,1,0); T1000 = j(M,1,0); u = j(n,1,0); Btot = {1, 2}; Var = {2}; do i = 1 to M; call randgen(u,"normal",0,S); y = (x*Btot) + u; b = inv((x`) * x) * (x`) * y; e = y - (x*b); b2 = b[2,1]; B1000[i,] = b2; B2 = Btot[2,1]; se2 = ((e`) * e) * (1/(n - 2)); varb2 = se2 * b2; seb2 = sqrt(varb2); t2 = (b2 - B2) * (1/seb2); T1000[i,] = t_2; end; ... View more

I am trying to use this code, everything is working perfectly except for FAM_E, anyone can help me    data merged; set merged; BY FAMID; if FIRST.FAMID THEN DO; FAM_A = 0; FAM_B = 0; FAM_C = 0; FAM_D = 0; FAM_E = 0; FAM_F = 0; FAM_G = 0; END; IF (EFNP EQ 1) AND (adult eq 1) THEN DO; FAM_A = 1; FAM_B = 0; FAM_C = 0; FAM_D = 0; FAM_E = 0; FAM_F = 0; FAM_G = 0; END; ELSE IF (RHTYPE EQ 3) AND (EFNP GE 2) AND (under18 eq 1) AND (adult eq 1) THEN DO; FAM_A = 0; FAM_B = 1; FAM_C = 0; FAM_D = 0; FAM_E = 0; FAM_F = 0; FAM_G = 0; END; ELSE IF (RHTYPE EQ 2) AND (EFNP GE 2) AND (under18 eq 1) AND (adult eq 1) THEN DO; FAM_A = 0; FAM_B = 0; FAM_C = 1; FAM_D = 0; FAM_E = 0; FAM_F = 0; FAM_G = 0; END; ELSE IF (EFNP GE 2) AND (adult eq 1) THEN DO; FAM_A = 0; FAM_B = 0; FAM_C = 0; FAM_D = 1; FAM_E = 0; FAM_F = 0; FAM_G = 0; END; ELSE IF (EFNP gt 2) AND (adult eq 1) AND (under18 eq 1) and (over64 eq 0) THEN DO; FAM_A = 0; FAM_B = 0; FAM_C = 0; FAM_D = 0; FAM_E = 1; FAM_F = 0; FAM_G = 0; END; ELSE IF (EFNP GT 2) AND (under18 eq 1) AND (over64 eq 1) THEN DO; FAM_A = 0; FAM_B = 0; FAM_C = 0; FAM_D = 0; FAM_E = 0; FAM_F = 1; FAM_G = 0; END; ELSE IF (EFNP ge 1) AND (over64 eq 1) THEN DO; FAM_A = 0; FAM_B = 0; FAM_C = 0; FAM_D = 0; FAM_E = 0; FAM_F = 0; FAM_G = 1; END; ELSE IF (RHTYPE EQ .) AND (EFNP EQ .) AND (under18 eq .) AND (OVER64 EQ .) and (adut eq .) THEN DO; FAM_A = .; FAM_B = .; FAM_C = .; FAM_D = .; FAM_E = .; FAM_F = .; FAM_G = .; END; if LAST.FAMID THEN OUTPUT; Retain Fam_A Fam_B Fam_C Fam_D Fam_E Fam_F Fam_G; ... View more