Hi everyone  I used this code to create a dataset called HOSP data hosp;    do j = 1 to 1000;       AdmitDate = int(ranuni(1234)*1200 + 15500);       quarter = intck('qtr','01jan2002'd,AdmitDate);       do i = 1 to quarter;          if ranuni(0) lt .1 and weekday(AdmitDate) eq 1 then             AdmitDate = AdmitDate + 1;          if ranuni(0) lt .1 and weekday(AdmitDate) eq 7 then             AdmitDate = AdmitDate - int(3*ranuni(0) + 1);          DOB = int(25000*Ranuni(0) + '01jan1920'd);          DischrDate = AdmitDate + abs(10*rannor(0) + 1);          Subject + 1;          output;       end;    end;    drop i j;    format AdmitDate DOB DischrDate mmddyy10.; run;   How do I create a temporary dataset called HOSP2 using "set"? I tried this:   data hosp; set hosp2; do j = 1 to 1000; AdmitDate = int(ranuni(1234)*1200 + 15500); quarter = intck('qtr','01jan2002'd,AdmitDate); do i = 1 to quarter; if ranuni(0) lt .1 and weekday(AdmitDate) eq 1 then AdmitDate = AdmitDate + 1; if ranuni(0) lt .1 and weekday(AdmitDate) eq 7 then AdmitDate = AdmitDate - int(3*ranuni(0) + 1); DOB = int(25000*Ranuni(0) + '01jan1920'd); DischrDate = AdmitDate + abs(10*rannor(0) + 1); Subject + 1; output; end; end; drop i j; format AdmitDate DOB DischrDate mmddyy10.; run; proc print data=hosp2; run;   But it did not work. Does anyone know how to fix this? ... View more

Does anyone know what is wrong with this code: proc iml; x={1, 2, 3, 4, 5, 6}; xt=t(x); print transpose; Using this data, I am expected to find x', x'x, x'x inverse, X’Y, b = (X’X)-1X’Y, e = Y-Xb, etc. Does anyone know how to best do this? X Y 1 2 3 4 5 6   0.83   7.48 14.45 12.70 20.46 25.73   ... View more

Hi everyone,   My data is from a big csv file and in that file, the authors used ####### as a missing value. How do I get sas to identify this as a missing value and not try to fill it in? My code right now is:  proc import out=work.problems datafile="/home/u63556826/sasuser.v94/problems.csv" dbms=csv replace; getnames=YES; run; proc print data=work.problems (obs = 6); run;     ... View more

data MARRIAGE; infile '/home/u63556826/sasuser.v94/MARR500 (2).DAT'; input WOMAN 1-5 MARRSTAT $ 7 GATTPREG 25-26 HATTPREG 27-28; if MARRSTAT = 8 then MARRSTAT = .; if MARRSTAT = 9 then MARRSTAT = .; if GATTPREG > 8 then GATTPREG = .; IF HATTPREG > 8 then HATTPREG = .; if 0<= GATTPREG < 5 then GR_ATTITUDE = 1; if GATTPREG >=5 then GR_ATTITUDE = 0; if 0<= HATTPREG < 5 then HB_ATTITUDE = 1; if HATTPREG >=5 then HB_ATTITUDE = 0;   proc print data=marriage; label WOMAN = "Mother's ID"; label MARRSTAT = "Marital Status"; label GATTPREG = "Gravida's Attitude Towards Pregnancy"; label HATTPREG = "Husband's Attitude Towards Pregnancy"; run;   In procprint, the labels still say Woman, MARRSTAT, etc. ... View more

How do I code this data to be read as one observation spanning over three lines?  This is what the data looks like. 00001150200070750242704380517069207391136212115111383014030100010210164007220090517 62136133691701143081090101010484051999299110 990 01101101117100000000001-1-1-1-1-1- 10301-1-1-12 00001251800070755262915311589160618151410122115211042844040100010310174306420091631 631341406919411430810801020205850714021011201035001101101119200000000001-101-1-1- 102-101-1-1-12 00002155000050500263404420517999905741099211199939991327010000000120154210541590517 65133135701551 05991000103030382051999 9911 996 7100000000004011041010000030301- 10299030701-19 00004159900059900429903950517999906651099211105111022704050190010420143809990060517 6411899999999 9999 9999999999 99 99 99 99 8 99 99 99 99 99 999999999999999999999999991 00005155000070750273702580517999905541099212101211272964030011010320364002140090517 65247225691771118091050104040582051999 99111 064 01000000000050000000002-101-1-1- 19999990699992 00005252200070756324221922262227024841411122111251172924040011010420164209041592354 6523223399999111808105010505058206140710311120640010000000000500000000020200-1-1-1- 1-1-199-1992 000071502000707002426036105179999062710992111092111526640310000102108 380521009051762121107661581 3699106010101040309199929911 990 01000000000000000000002-101-1-1-1-1-102-1-1-12 000081550000707002833036405179999061910992111091113125530502000203906 120822009051762125109999991 0499109010101058 99 999 999 010 011011012201 99 99 9900030102-1-19999999999992 00009155020050500369904480517999907131099211199211422654030000000320164004550090517 65150150691951 46996000502980581071499 9911 991 71202205790410110720206-104-1-1- 109-10202-1009 00010155020050500202103900518999906741099211118211182844010000000120174002420090518 63112105741901 54993000101010383051999 9911 991 211011021161101102202010000-1-1- 104-10201-1001 00011150200009960303004360518999907291099212123111592934000000000000000000550090518 65132122711801905005000603980289051999199119 992 01202201790400380170905-1020302- 102-1020001-11 00012155000000700192303980518999906421099211118210752441010000000110123302220090518 62115106711601 60993030101010382051999 9911 995 710000000000101104206-102-1-1-1- 102-10100-1-15 00013150200009910232704390518999907171099212110211122784010000000120183604320090553 66120110742201147091050101010383981999 99119 992 71000000000000380470900-102-1-1- 104-1020301011 00013251200000115263014491535154317401413122108211232914020000000220163906230091543 6611510673220114709105080604048206140410311920901211011013181101107109-1-104-1- 10102-1000609021 00014155000059960192804000518999906791099214116110992794000000000000000000320090518 62114105671951160001050101010282091999 9911 991 010000000000000000000-1-103-1-1- 19999019999991 00014250300050665202907450983098310311234124110211122864010000000110143901320090983 6114799999999116000105080202038299140010012 00000100000000000000000009999999999999999999999991 00014351600050665243321122191220723871313134110211082754020000000220164007320092207 6212612070175 16000105010606048205 40910912 9960710000000000 99 99 9901-102-1-1- 19999999999991 00014450500050565263529152982299931931412144103111352784030000000320153904320092999 6112412069185116000105010707058209 40910912 000001000000000010110110902-10100-1- 103-100-1-1001 00015150200089950252903980517999906741099213120211062764000000000000000000550090538 62102094651151569005000900000283031499199119 990 710000000000000000000-10101-1-1-1- 10000-1-1-13 00015251600080858273111271219123514111415123113111202844010000000120153904550091241 6210610065110156900600010101988399140120111910000010000000000000000000-102-1-1-1-1-   and this is what I have so far Data pregnancy; Infile '/home/u63556826/sasuser.v94/BASIC50.DAT' missover; Input #1 Woman 1-5 Gravage 18-19 BirthWT 50-52 / GRHEIGHT 84-85 GRWEIGHT 86-88 / ; run; proc print data=pregnancy; run;   ... View more