cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
jamuriuk
‎09-24-2017
  • 7 Posts
  • 2 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: SAS Coding

by Fluorite | Level 6 in SAS Procedures
‎09-12-2017 08:42 PM
‎09-12-2017 08:42 PM
ChrisBrooks: Could you please advise on an alternative way of coding this?   ... View more

Comparing numerical variable w/ char constants

by Fluorite | Level 6 in SAS Procedures
‎09-12-2017 08:11 PM
‎09-12-2017 08:11 PM
I am trying to change the numerical variable to read as either 1, 10,20 or 100 but I am getting the errors as shown below. Kindly help.   data HARVEST_UTILIZE_BEANS_enid2; set HARVEST_UTILIZE_BEANS_enid1; if HUB_UNITFRESHHV="Kg" then HUB_UNITFRESHHV=1; if HUB_UNITFRESHHV="Basin (20 pounds)" then HUB_UNITFRESHHV=10; if HUB_UNITFRESHHV= "Tin/Bucket (20kg)" then HUB_UNITFRESHHV=20; if HUB_UNITFRESHHV ="Bag/sac 100 kg" then HUB_UNITFRESHHV=100; /*standardizing the prices, quantities and units of output beans harvested*/ if HUB_UNITGREENC="Kg" then HUB_UNITGREENC=1; if HUB_UNITGREENC="Tin/Bucket (20Kg)" then HUB_UNITGREENC=20; if HUB_UNITGREENC ="Basin (20 pounds)" then HUB_UNITGREENC=10; if HUB_UNITGREENC="Bag/sac 100 kg" then HUB_UNITGREENC=100; run;     OTE: Character values have been converted to numeric values at the places given by: (Line):(Column).       25:20   26:20   27:21   28:21   30:19   31:19   32:20   33:19    NOTE: Invalid numeric data, 'Kg' , at line 25 column 20. NOTE: Invalid numeric data, 'Basin (20 pounds)' , at line 26 column 20. NOTE: Invalid numeric data, 'Tin/Bucket (20kg)' , at line 27 column 21. NOTE: Invalid numeric data, 'Bag/sac 100 kg' , at line 28 column 21. NOTE: Invalid numeric data, 'Kg' , at line 30 column 19. NOTE: Invalid numeric data, 'Tin/Bucket (20Kg)' , at line 31 column 19. NOTE: Invalid numeric data, 'Basin (20 pounds)' , at line 32 column 20. NOTE: Invalid numeric data, 'Bag/sac 100 kg' , at line 33 column 19. HH_ID=101 region=Eastern region dist=KAMULI scounty=KISOZI parish=MAGOGO village=BUKWALU plot_id=001-01-B-2 HUB_BVNAME=KILEGEYA name2=kilegeya(Bush) code=369 I_L=Local HUB_PLOTNO=2 HUB_GREENHV=0 HUB_UNITGREENHV=. HUB_FRESHHV=0 HUB_UNITFRESHHV=Kg HUB_DRYHV=50 HUB_UNITDRYHV=Kg HUB_GREENC=0 HUB_UNITGREENC=Kg HUB_FRESHC=0 HUB_UNITFRESHC=. HUB_DRYC=20 HUB_UNITDRYC=Kg HUB_QTYFORSEED=5 comment= BEAN_MERGE_COMMENT=  _ERROR_=1 _N_=1 NOTE: Invalid numeric data, 'Kg' , at line 25 column 20. NOTE: Invalid numeric data, 'Basin (20 pounds)' , at line 26 column 20. NOTE: Invalid numeric data, 'Tin/Bucket (20kg)' , at line 27 column 21. NOTE: Invalid numeric data, 'Bag/sac 100 kg' , at line 28 column 21. NOTE: Invalid numeric data, 'Kg' , at line 30 column 19. NOTE: Invalid numeric data, 'Tin/Bucket (20Kg)' , at line 31 column 19. NOTE: Invalid numeric data, 'Basin (20 pounds)' , at line 32 column 20. 2                                                          The SAS System                          08:57 Tuesday, September 12, 2017 NOTE: Invalid numeric data, 'Bag/sac 100 kg' , at line 33 column 19. HH_ID=103 region=Eastern region dist=KAMULI scounty=KISOZI parish=MAGOGO village=BUKWALU plot_id=001-03-B-1 HUB_BVNAME=Kanyebwa name2=kanyebwa(Bush) code=262 I_L=Local HUB_PLOTNO=1 HUB_GREENHV=0 HUB_UNITGREENHV=. HUB_FRESHHV=5 HUB_UNITFRESHHV=Kg HUB_DRYHV=20 HUB_UNITDRYHV=Kg HUB_GREENC=0 HUB_UNITGREENC=Kg HUB_FRESHC=5 HUB_UNITFRESHC=Kg HUB_DRYC=15 HUB_UNITDRYC=Bag/sac 50 kg HUB_QTYFORSEED=1 comment=  BEAN_MERGE_COMMENT=  _ERROR_=1 _N_=2 NOTE: Invalid numeric data, 'Kg' , at line 25 column 20. NOTE: Invalid numeric data, 'Basin (20 pounds)' , at line 26 column 20. NOTE: Invalid numeric data, 'Tin/Bucket (20kg)' , at line 27 column 21. NOTE: Invalid numeric data, 'Bag/sac 100 kg' , at line 28 column 21. NOTE: Invalid numeric data, 'Kg' , at line 30 column 19. NOTE: Invalid numeric data, 'Tin/Bucket (20Kg)' , at line 31 column 19. NOTE: Invalid numeric data, 'Basin (20 pounds)' , at line 32 column 20. NOTE: Invalid numeric data, 'Bag/sac 100 kg' , at line 33 column 19. HH_ID=104 region=Eastern region dist=KAMULI scounty=KISOZI parish=MAGOGO village=BUKWALU plot_id=001-04-B-1 HUB_BVNAME=kanyebwa name2=kanyebwa(Bush) code=262 I_L=Local HUB_PLOTNO=1 HUB_GREENHV=0 HUB_UNITGREENHV=. HUB_FRESHHV=10 HUB_UNITFRESHHV=Kg HUB_DRYHV=20 HUB_UNITDRYHV=Kg HUB_GREENC=0 HUB_UNITGREENC=Kg HUB_FRESHC=10 HUB_UNITFRESHC=Kg HUB_DRYC=15 HUB_UNITDRYC=Kg HUB_QTYFORSEED=5 comment=  BEAN_MERGE_COMMENT=  _ERROR_=1 _N_=3 NOTE: Invalid numeric data, 'Kg' , at line 25 column 20. NOTE: Invalid numeric data, 'Basin (20 pounds)' , at line 26 column 20. NOTE: Invalid numeric data, 'Tin/Bucket (20kg)' , at line 27 column 21. NOTE: Invalid numeric data, 'Bag/sac 100 kg' , at line 28 column 21. NOTE: Invalid numeric data, 'Kg' , at line 30 column 19. NOTE: Invalid numeric data, 'Tin/Bucket (20Kg)' , at line 31 column 19. NOTE: Invalid numeric data, 'Basin (20 pounds)' , at line 32 column 20. NOTE: Invalid numeric data, 'Bag/sac 100 kg' , at line 33 column 19. HH_ID=106 region=Eastern region dist=KAMULI scounty=KISOZI parish=MAGOGO village=BUKWALU plot_id=001-06-B-1 HUB_BVNAME=obweru name2=obweru(Bush) code=80 I_L=Selected HUB_PLOTNO=1 HUB_GREENHV=0 HUB_UNITGREENHV=. HUB_FRESHHV=2 HUB_UNITFRESHHV=Kg HUB_DRYHV=5 HUB_UNITDRYHV=Kg HUB_GREENC=0 HUB_UNITGREENC=Kg HUB_FRESHC=2 HUB_UNITFRESHC=Kg HUB_DRYC=2 HUB_UNITDRYC=Kg HUB_QTYFORSEED=3 comment= BEAN_MERGE_COMMENT=  _ERROR_=1 _N_=4 NOTE: Invalid numeric data, 'Kg' , at line 25 column 20. NOTE: Invalid numeric data, 'Basin (20 pounds)' , at line 26 column 20. NOTE: Invalid numeric data, 'Tin/Bucket (20kg)' , at line 27 column 21. NOTE: Invalid numeric data, 'Bag/sac 100 kg' , at line 28 column 21. NOTE: Invalid numeric data, 'Kg' , at line 30 column 19. NOTE: Invalid numeric data, 'Tin/Bucket (20Kg)' , at line 31 column 19. NOTE: Invalid numeric data, 'Basin (20 pounds)' , at line 32 column 20. NOTE: Invalid numeric data, 'Bag/sac 100 kg' , at line 33 column 19. HH_ID=107 region=Eastern region dist=KAMULI scounty=KISOZI parish=MAGOGO village=BUKWALU plot_id=001-07-B-1 HUB_BVNAME=Kaki Round Small name2=kaki round small(Bush) code=202 I_L=Local HUB_PLOTNO=1 HUB_GREENHV=0 HUB_UNITGREENHV=. HUB_FRESHHV=0.5 HUB_UNITFRESHHV=Basin (20 pounds) HUB_DRYHV=9 HUB_UNITDRYHV=Kg HUB_GREENC=0 HUB_UNITGREENC=Kg HUB_FRESHC=0.5 HUB_UNITFRESHC=Basin (20 pounds) HUB_DRYC=5 HUB_UNITDRYC=Kg HUB_QTYFORSEED=4 comment=  BEAN_MERGE_COMMENT=  _ERROR_=1 _N_=5 NOTE: Invalid numeric data, 'Kg' , at line 25 column 20. NOTE: Invalid numeric data, 'Basin (20 pounds)' , at line 26 column 20. NOTE: Invalid numeric data, 'Tin/Bucket (20kg)' , at line 27 column 21. NOTE: Invalid numeric data, 'Bag/sac 100 kg' , at line 28 column 21. NOTE: Invalid numeric data, 'Kg' , at line 30 column 19. NOTE: Invalid numeric data, 'Tin/Bucket (20Kg)' , at line 31 column 19. NOTE: Invalid numeric data, 'Basin (20 pounds)' , at line 32 column 20. NOTE: Invalid numeric data, 'Bag/sac 100 kg' , at line 33 column 19. HH_ID=108 region=Eastern region dist=KAMULI scounty=KISOZI parish=MAGOGO village=BUKWALU plot_id=001-08-B-1 HUB_BVNAME=Kanyebwa name2=kanyebwa(Bush) code=262 I_L=Local HUB_PLOTNO=1 HUB_GREENHV=0 HUB_UNITGREENHV=. HUB_FRESHHV=2 HUB_UNITFRESHHV=Tin/Bucket (20kg) HUB_DRYHV=1 HUB_UNITDRYHV=Bag/sac 100 kg HUB_GREENC=0 HUB_UNITGREENC=Kg HUB_FRESHC=1 HUB_UNITFRESHC=Tin/Bucket (20kg) HUB_DRYC=3 HUB_UNITDRYC=Tin/Bucket (20kg) HUB_QTYFORSEED=20 comment=  BEAN_MERGE_COMMENT=  _ERROR_=1 _N_=6 NOTE: Invalid numeric data, 'Kg' , at line 25 column 20. NOTE: Invalid numeric data, 'Basin (20 pounds)' , at line 26 column 20. NOTE: Invalid numeric data, 'Tin/Bucket (20kg)' , at line 27 column 21. NOTE: Invalid numeric data, 'Bag/sac 100 kg' , at line 28 column 21. NOTE: Invalid numeric data, 'Kg' , at line 30 column 19. 3                                                          The SAS System                          08:57 Tuesday, September 12, 2017 NOTE: Invalid numeric data, 'Tin/Bucket (20Kg)' , at line 31 column 19. NOTE: Invalid numeric data, 'Basin (20 pounds)' , at line 32 column 20. NOTE: Invalid numeric data, 'Bag/sac 100 kg' , at line 33 column 19. HH_ID=109 region=Eastern region dist=KAMULI scounty=KISOZI parish=MAGOGO village=BUKWALU plot_id=001-09-B-1 HUB_BVNAME=obweru name2=obweru(Bush) code=80 I_L=Selected HUB_PLOTNO=1 HUB_GREENHV=0 HUB_UNITGREENHV=. HUB_FRESHHV=0 HUB_UNITFRESHHV=Kg HUB_DRYHV=1 HUB_UNITDRYHV=Basin (20 pounds) HUB_GREENC=0 HUB_UNITGREENC=Kg HUB_FRESHC=0 HUB_UNITFRESHC=. HUB_DRYC=5 HUB_UNITDRYC=Kg HUB_QTYFORSEED=7 comment=  BEAN_MERGE_COMMENT=  _ERROR_=1 _N_=7 NOTE: Invalid numeric data, 'Kg' , at line 25 column 20. NOTE: Invalid numeric data, 'Basin (20 pounds)' , at line 26 column 20. NOTE: Invalid numeric data, 'Tin/Bucket (20kg)' , at line 27 column 21. NOTE: Invalid numeric data, 'Bag/sac 100 kg' , at line 28 column 21. NOTE: Invalid numeric data, 'Kg' , at line 30 column 19. NOTE: Invalid numeric data, 'Tin/Bucket (20Kg)' , at line 31 column 19. NOTE: Invalid numeric data, 'Basin (20 pounds)' , at line 32 column 20. NOTE: Invalid numeric data, 'Bag/sac 100 kg' , at line 33 column 19. HH_ID=110 region=Eastern region dist=KAMULI scounty=KISOZI parish=MAGOGO village=BUKWALU plot_id=001-10-B-1 HUB_BVNAME=obweru name2=obweru(Bush) code=80 I_L=Selected HUB_PLOTNO=1 HUB_GREENHV=0 HUB_UNITGREENHV=. HUB_FRESHHV=2 HUB_UNITFRESHHV=Tin/Bucket (20kg) HUB_DRYHV=3 HUB_UNITDRYHV=Kg HUB_GREENC=0 HUB_UNITGREENC=Kg HUB_FRESHC=2 HUB_UNITFRESHC=Kg HUB_DRYC=3 HUB_UNITDRYC=Kg HUB_QTYFORSEED=0 comment=  BEAN_MERGE_COMMENT=  _ERROR_=1 _N_=8 NOTE: Invalid numeric data, 'Kg' , at line 25 column 20. NOTE: Invalid numeric data, 'Basin (20 pounds)' , at line 26 column 20. NOTE: Invalid numeric data, 'Tin/Bucket (20kg)' , at line 27 column 21. NOTE: Invalid numeric data, 'Bag/sac 100 kg' , at line 28 column 21. NOTE: Invalid numeric data, 'Kg' , at line 30 column 19. NOTE: Invalid numeric data, 'Tin/Bucket (20Kg)' , at line 31 column 19. NOTE: Invalid numeric data, 'Basin (20 pounds)' , at line 32 column 20. NOTE: Invalid numeric data, 'Bag/sac 100 kg' , at line 33 column 19. HH_ID=111 region=Eastern region dist=KAMULI scounty=KISOZI parish=MAGOGO village=BUKWALU plot_id=001-11-B-2 HUB_BVNAME=obwirugavu name2=obwirugavu(Bush) code=43 I_L=Improved HUB_PLOTNO=2 HUB_GREENHV=0 HUB_UNITGREENHV=. HUB_FRESHHV=5 HUB_UNITFRESHHV=Kg HUB_DRYHV=2 HUB_UNITDRYHV=Kg HUB_GREENC=0 HUB_UNITGREENC=Kg HUB_FRESHC=5 HUB_UNITFRESHC=Kg HUB_DRYC=2 HUB_UNITDRYC=Kg HUB_QTYFORSEED=0 comment=  BEAN_MERGE_COMMENT=  _ERROR_=1 _N_=9 NOTE: Invalid numeric data, 'Kg' , at line 25 column 20. NOTE: Invalid numeric data, 'Basin (20 pounds)' , at line 26 column 20. NOTE: Invalid numeric data, 'Tin/Bucket (20kg)' , at line 27 column 21. NOTE: Invalid numeric data, 'Bag/sac 100 kg' , at line 28 column 21. NOTE: Invalid numeric data, 'Kg' , at line 30 column 19. NOTE: Invalid numeric data, 'Tin/Bucket (20Kg)' , at line 31 column 19. NOTE: Invalid numeric data, 'Basin (20 pounds)' , at line 32 column 20. NOTE: Invalid numeric data, 'Bag/sac 100 kg' , at line 33 column 19. HH_ID=112 region=Eastern region dist=KAMULI scounty=KISOZI parish=MAGOGO village=BUKWALU plot_id=001-12-B-2 HUB_BVNAME=Bumyufu name2=bumyufu(Bush) code=526 I_L=Improved HUB_PLOTNO=2 HUB_GREENHV=0 HUB_UNITGREENHV=. HUB_FRESHHV=0 HUB_UNITFRESHHV=Kg HUB_DRYHV=1 HUB_UNITDRYHV=Kg HUB_GREENC=0 HUB_UNITGREENC=Kg HUB_FRESHC=0 HUB_UNITFRESHC=. HUB_DRYC=0 HUB_UNITDRYC=. HUB_QTYFORSEED=1 comment= BEAN_MERGE_COMMENT=  _ERROR_=1 _N_=10 NOTE: Invalid numeric data, 'Kg' , at line 25 column 20. NOTE: Invalid numeric data, 'Basin (20 pounds)' , at line 26 column 20. NOTE: Invalid numeric data, 'Tin/Bucket (20kg)' , at line 27 column 21. NOTE: Invalid numeric data, 'Bag/sac 100 kg' , at line 28 column 21. NOTE: Invalid numeric data, 'Kg' , at line 30 column 19. NOTE: Invalid numeric data, 'Tin/Bucket (20Kg)' , at line 31 column 19. NOTE: Invalid numeric data, 'Basin (20 pounds)' , at line 32 column 20. NOTE: Invalid numeric data, 'Bag/sac 100 kg' , at line 33 column 19. HH_ID=114 region=Eastern region dist=KAMULI scounty=KISOZI parish=MAGOGO village=BUKWALU plot_id=001-14-B-2 HUB_BVNAME=Kaki Round Small name2=kaki round small(Bush) code=202 I_L=Local HUB_PLOTNO=2 HUB_GREENHV=0 HUB_UNITGREENHV=. HUB_FRESHHV=0 HUB_UNITFRESHHV=Kg HUB_DRYHV=3 HUB_UNITDRYHV=Kg HUB_GREENC=0 HUB_UNITGREENC=Kg HUB_FRESHC=0 HUB_UNITFRESHC=. HUB_DRYC=3 HUB_UNITDRYC=Kg HUB_QTYFORSEED=0 comment=  BEAN_MERGE_COMMENT=  _ERROR_=1 _N_=11 NOTE: Invalid numeric data, 'Kg' , at line 25 column 20. NOTE: Invalid numeric data, 'Basin (20 pounds)' , at line 26 column 20. NOTE: Invalid numeric data, 'Tin/Bucket (20kg)' , at line 27 column 21. 4                                                          The SAS System                          08:57 Tuesday, September 12, 2017 NOTE: Invalid numeric data, 'Bag/sac 100 kg' , at line 28 column 21. NOTE: Invalid numeric data, 'Kg' , at line 30 column 19. NOTE: Invalid numeric data, 'Tin/Bucket (20Kg)' , at line 31 column 19. NOTE: Invalid numeric data, 'Basin (20 pounds)' , at line 32 column 20. NOTE: Invalid numeric data, 'Bag/sac 100 kg' , at line 33 column 19. HH_ID=118 region=Eastern region dist=KAMULI scounty=KISOZI parish=MAGOGO village=BUKWALU plot_id=001-18-B-1 HUB_BVNAME=White Haricot/white name2=white haricot/white(Bush) code=1 I_L=Local HUB_PLOTNO=1 HUB_GREENHV=0 HUB_UNITGREENHV=. HUB_FRESHHV=6 HUB_UNITFRESHHV=Kg HUB_DRYHV=5 HUB_UNITDRYHV=Kg HUB_GREENC=0 HUB_UNITGREENC=Kg HUB_FRESHC=6 HUB_UNITFRESHC=Tin/Bucket (20kg) HUB_DRYC=4 HUB_UNITDRYC=Kg HUB_QTYFORSEED=1 comment=  BEAN_MERGE_COMMENT=  _ERROR_=1 _N_=12 NOTE: Invalid numeric data, 'Kg' , at line 25 column 20. NOTE: Invalid numeric data, 'Basin (20 pounds)' , at line 26 column 20. NOTE: Invalid numeric data, 'Tin/Bucket (20kg)' , at line 27 column 21. NOTE: Invalid numeric data, 'Bag/sac 100 kg' , at line 28 column 21. NOTE: Over 100 NOTES, additional NOTES suppressed. NOTE: Invalid numeric data, 'Kg' , at line 30 column 19. ... View more

Re: Creating Age Groups from Age Variable

by Fluorite | Level 6 in SAS Enterprise Guide
‎06-24-2017 04:29 PM
‎06-24-2017 04:29 PM
Thank you although I did not want to add extra variables x1, x2 and x3. I have apparently used if age <= 15 then z2=1;else if 12 <= age < 65 then z2=2;else if age >=65 then z2=3; and it has worked. Thanks so much. James ... View more

Creating Age Groups from Age Variable

by Fluorite | Level 6 in SAS Enterprise Guide
‎06-24-2017 03:54 PM
‎06-24-2017 03:54 PM
Hello team, i am trying to group the variable "age" to assign a dummy with groupings 0-14 years, 15-65 years and above 65 years. My variable representing age is z2. How do I set the codes please?   James ... View more

Re: Errors in SAS

by Fluorite | Level 6 in SAS Enterprise Guide
‎06-22-2017 02:05 PM
‎06-22-2017 02:05 PM
Thanks, I actually don't have the B0101 unless I create it. Thanks. How about the second error, please? ERROR: (execution) Matrix has not been set to a value. ... View more

Errors in SAS

by Fluorite | Level 6 in SAS Enterprise Guide
‎06-22-2017 01:53 PM
‎06-22-2017 01:53 PM
Hello team, I am not so conversant with SAS but I have been running SAS codes with proc iml but apparently getting these kinds of errors   31         /* Especify the number of equations you are estimating*/ 32          33         e=9; 34          35          36          37         /* Especify the equation you drop in the SUR*/ 38          39         d=9; 40          41          42          43         /* Especify the number of socio demographic variables included in the model */ 44          45         r=4; 46          47          48          49         /* Especify the degree of polynomial used in the model*/ 50          51         s=5; 52          53          54          55         /*/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// 2                                                          The SAS System                              11:36 Thursday, June 22, 2017 55       ! */ 56          57          58          59         /*/////Importing into matrices Arithmetic mean values for budget shares,price indices and socio demographic 59       ! charact/////*/ 60          61          62          63         /*Read the mean values of budget shares*/ 64          65         USE w_means; 66          67         READ ALL INTO W; 68          69         W2= W[4,3:e+2]; 70          71         *print w2; 72          73          74          75         /*Read the mean values of price variables*/ 76          77         USE p_means; 78          79         READ ALL INTO P; 80          81         P2= P[4,3:e+2]; 82          83         *print p2; 84          85          86          87         /*Read the mean values of demographic variables*/ 88          89         USE sd_means; 90          91         READ ALL INTO SD; 92          93         SD2= 1||SD[4,3:r+2]; 94          95         *print sd2; 96          97          98          99          100         101        /*/////////////////////////Importing into a matrix the parameter estimates for Beta from the EASI model, where the 101      ! missing 102         103        parameters are recovered trough the adding up  restriction/////////////////////////////////////////////////////////*/ 104         105         106         107        USE beans_excel3; 108         109        READ ALL VAR { 110         3                                                          The SAS System                              11:36 Thursday, June 22, 2017 111        b0101 b0102 b0103 b0104 b0105 b0106 b0107 b0108 b0109 112         113        b0201 b0202 b0203 b0204 b0205 b0206 b0207 b0208 b0209 114         115        b0301 b0302 b0303 b0304 b0305 b0306 b0307 b0308 b0309 116         117        b0401 b0402 b0403 b0404 b0405 b0406 b0407 b0408 b0409 118         119        b0501 b0502 b0503 b0504 b0505 b0506 b0507 b0508 b0509 120         121        b0601 b0602 b0603 b0604 b0605 b0606 b0607 b0608 b0609 122         123        b0701 b0702 b0703 b0704 b0705 b0706 b0707 b0708 b0709 124         125        b0801 b0802 b0803 b0804 b0805 b0806 b0807 b0808 b0809 126         127        b0901 b0902 b0903 b0904 b0905 b0906 b0907 b0908 b0909 128         129         130        } INTO B; ERROR: B0101 is not in the scope of variables for the data set.  statement : READ at line 109 column 1 131         132         133         134        B1= J(e-1,e,0); 135         136        Do i=1 to e-1; 137         138        j=i-1; 139         140        M= B[1,1+e*j:e*(j+1)]; 141         142        B1 [i,]= M; 143         144        end; ERROR: (execution) Matrix has not been set to a value.  operation : [ at line 140 column 5  operands  : B, *LIT1021, _TEM1002, _TEM1004 B      0 row       0 col     (type ?, size 0) *LIT1021      1 row       1 col     (numeric)          1 _TEM1002      1 row       1 col     (numeric)          1 _TEM1004      1 row       1 col     (numeric)          9  statement : ASSIGN at line 140 column 1 4                                                          The SAS System                              11:36 Thursday, June 22, 2017 145         146        *print B1; 147         148         149         150        B2= J(1,e,0); 151         152        Do i=1 to e; 153         154        M= -SUM(B1[,i]); 155         156        B2 [,i] = M; 157         158        END; 159         160        *print B2; 161         162         163         164        B3=B1//B2; 165         166        *print B3; 167        run; NOTE: Module MAIN is undefined in IML; cannot be RUN. 168         169        GOPTIONS NOACCESSIBLE; 170        %LET _CLIENTTASKLABEL=; 171        %LET _CLIENTPROJECTPATH=; 172        %LET _CLIENTPROJECTNAME=; 173        %LET _SASPROGRAMFILE=; 174         175        ;*';*";*/;quit; NOTE: Exiting IML. NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE IML used (Total process time):       real time           0.03 seconds       cpu time            0.03 seconds        175      !                run; 176        ODS _ALL_ CLOSE; 177         178         179        QUIT; RUN; 180          these are my codes for more information proc iml;   /*///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////*/   /* Especify the number of equations you are estimating*/ e=9;   /* Especify the equation you drop in the SUR*/ d=9;   /* Especify the number of socio demographic variables included in the model */ r=4;   /* Especify the degree of polynomial used in the model*/ s=5;   /*///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////*/   /*/////Importing into matrices Arithmetic mean values for budget shares,price indices and socio demographic charact/////*/   /*Read the mean values of budget shares*/ USE w_means; READ ALL INTO W; W2= W[4,3:e+2]; *print w2;   /*Read the mean values of price variables*/ USE p_means; READ ALL INTO P; P2= P[4,3:e+2]; *print p2;   /*Read the mean values of demographic variables*/ USE sd_means; READ ALL INTO SD; SD2= 1||SD[4,3:r+2]; *print sd2;   /*/////////////////////////Importing into a matrix the parameter estimates for Beta from the EASI model, where the missing parameters are recovered trough the adding up  restriction/////////////////////////////////////////////////////////*/   USE beans_excel3; READ ALL VAR { b0101 b0102 b0103 b0104 b0105 b0106 b0107 b0108 b0109 b0201 b0202 b0203 b0204 b0205 b0206 b0207 b0208 b0209 b0301 b0302 b0303 b0304 b0305 b0306 b0307 b0308 b0309 b0401 b0402 b0403 b0404 b0405 b0406 b0407 b0408 b0409 b0501 b0502 b0503 b0504 b0505 b0506 b0507 b0508 b0509 b0601 b0602 b0603 b0604 b0605 b0606 b0607 b0608 b0609 b0701 b0702 b0703 b0704 b0705 b0706 b0707 b0708 b0709 b0801 b0802 b0803 b0804 b0805 b0806 b0807 b0808 b0809 b0901 b0902 b0903 b0904 b0905 b0906 b0907 b0908 b0909 } INTO B;   B1= J(e-1,e,0); Do i=1 to e-1; j=i-1; M= B[1,1+e*j:e*(j+1)]; B1 [i,]= M; end; *print B1;   B2= J(1,e,0); Do i=1 to e; M= -SUM(B1[,i]); B2 [,i] = M; END; *print B2;   B3=B1//B2; *print B3; run;   I will really appreciate your advise  James ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎09-24-2017 12:32 PM
Likes given to
View All
Quick links