topic Re: Invalid numeric data error in SAS Procedures

topic Re: Invalid numeric data error in SAS Procedures https://communities.sas.com/t5/SAS-Procedures/Invalid-numeric-data-error/m-p/173021#M44571 <HTML><HEAD></HEAD><BODY><P>This is the full log:</P><P></P><P>8           proc FORMAT;</P><P>9          </P><P>9        !  VALUE ELIGFMT</P><P>10         1 = "Eligible"</P><P>11         2 = "Under age 17"</P><P>12         3 = "Ineligible" ;</P><P>NOTE: Format ELIGFMT has been output.</P><P>13        </P><P>13       !  VALUE MORTFMT</P><P>14         0 = "Assumed alive"</P><P>15         1 = "Assumed deceased"</P><P>16         . = "Ineligible or under age 17";</P><P>NOTE: Format MORTFMT has been output.</P><P>17         RUN ;</P><P></P><P></P><P>NOTE: PROCEDURE FORMAT used (Total process time):</P><P>      real time           0.05 seconds</P><P>      cpu time            0.00 seconds</P><P>      </P><P></P><P></P><P>18         </P><P>19         data nyu ;</P><P>20         set ahn_final834 ;</P><P>21         </P><P>22         if PEPMNK1R = 888 then PEPMNK1R=. ;</P><P>23         if PM10StEYM20MeanW ne . and PEPMNK1R ne .</P><P>24         then eligible = 1 ; else eligible = 0 ; * SUBSET ELIGIBLE ;</P><P>25         </P><P>26         if HSSEX=2 then HSSEX=0; * 0=F, 1=M ;</P><P>27        </P><P>28         </P><P>29         if TGP = 8888 or TGP>1450 then TGP=. ;</P><P>30         if TCP = 888 or TCP>600 then TCP=. ;                           * remove extreme values ;</P><P>31        </P><P>32         if BMPBMI = 8888 then BMPBMI=. ;</P><P>33         if 0<BMPBMI<18.5 then bmi=1 ;</P><P>34         if BMPBMI>=18.5 and BMPBMI<25 then bmi=4 ;</P><P>35         if BMPBMI>=25 and BMPBMI<30 then bmi=2 ;</P><P>36         if BMPBMI>=30 then bmi=3 ;</P><P>37         if BMPBMI=. or BMPBMI=0 then bmi=0 ;</P><P>38         </P><P>39         if HAR1=2 then smoke=3 ;</P><P>40         if HAR1=1 and HAR3=2 then smoke=2 ;</P><P>41         if HAR1=1 and HAR3=1 then smoke=1 ;</P><P>42         if HAR1=. or HAR1=8 or HAR3=8 then smoke=3 ;</P><P>43         </P><P>44         </P><P>45         if DMARACER=1 then race=2 ;</P><P>46         if DMARACER=2 then race=1 ;</P><P>47         if DMARACER in (3,8) then race=0 ;</P><P>48         </P><P>49        </P><P>50         pm_iqr = PM10StEYM20MeanW / 10.8486 ; * PM10 per IQR ;</P><P>51         </P><P>52         log_TG = log(TGP);</P><P>53         </P><P>54         if rs9939609 = 44 then rs9939609_new = "TT";</P><P>55         if rs9939609 = 14 then rs9939609_new = "AT";</P><P>56         if rs9939609 = 11 then rs9939609_new = "AA";</P><P>57         </P><P>58         </P><P>59         if rs515135 = "GG" then snp1 = "wt" ;</P><P>60         if rs515135 in ("AG", "AA")  then snp1 = "var" ;</P><P>61         </P><P>62         if rs3751812 = "GG" then snp2 = "wt" ;</P><P>63         if rs3751812 in ("GT", "TT")  then snp2 = "var" ;</P><P>64         </P><P>65         if rs1454626 = "AA" then snp3 = "wt" ;</P><P>66         if rs1454626 in ("AC", "CC")  then snp3 = "var" ;</P><P>67         </P><P>68         if rs6919346 = "GG" then snp4 = "wt" ;</P><P>69         if rs6919346 in ("AG", "AA")  then snp4 = "var" ;</P><P>70         </P><P>71         if rs7903146 = 22 then snp5 = "wt" ;</P><P>72         if rs7903146 in (24, 44)  then snp5 = "var" ;</P><P>73         </P><P>74         if rs9939609_new = "TT" then snp6 = "wt" ;</P><P>75         if rs9939609_new in ("AA", "AT") then snp6 = "var" ;</P><P>76         </P><P>77         if rs17366743 = "TT" then snp7 = "wt" ;</P><P>78         if rs17366743 in ("CT", "CC") then snp7 = "var" ;</P><P>79         </P><P>80         if rs17782313_A = "TT" then snp8 = "wt" ;</P><P>81         if rs17782313_A in ("CT", "CC") then snp8 = "var" ;</P><P>82         run;</P><P></P><P></P><P>NOTE: Character values have been converted to numeric values at the places given by: (Line):(Column).</P><P>      54:5   55:5   56:5   </P><P>NOTE: Invalid numeric data, rs9939609='TT' , at line 54 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='TT' , at line 55 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='TT' , at line 56 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='TT' , at line 54 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='TT' , at line 55 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='TT' , at line 56 column 5.</P><P>_N_=10122</P><P>NOTE: Invalid numeric data, rs9939609='AT' , at line 54 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='AT' , at line 55 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='AT' , at line 56 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='TT' , at line 54 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='TT' , at line 55 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='TT' , at line 56 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='AT' , at line 54 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='AT' , at line 55 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='AT' , at line 56 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='AT' , at line 54 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='AT' , at line 55 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='AT' , at line 56 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='TT' , at line 54 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='TT' , at line 55 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='TT' , at line 56 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='TT' , at line 54 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='TT' , at line 55 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='TT' , at line 56 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='TT' , at line 54 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='TT' , at line 55 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='TT' , at line 56 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='TT' , at line 54 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='TT' , at line 55 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='TT' , at line 56 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='AT' , at line 54 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='AT' , at line 55 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='AT' , at line 56 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='AT' , at line 54 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='AT' , at line 55 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='AT' , at line 56 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='TT' , at line 54 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='TT' , at line 55 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='TT' , at line 56 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='TT' , at line 54 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='TT' , at line 55 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='TT' , at line 56 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='AT' , at line 54 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='AT' , at line 55 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='AT' , at line 56 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='TT' , at line 54 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='TT' , at line 55 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='TT' , at line 56 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='TT' , at line 54 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='TT' , at line 55 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='TT' , at line 56 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='TT' , at line 54 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='TT' , at line 55 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='TT' , at line 56 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='TT' , at line 54 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='TT' , at line 55 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='TT' , at line 56 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='AT' , at line 54 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='AT' , at line 55 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='AT' , at line 56 column 5.</P><P>NOTE: Missing values were generated as a result of performing an operation on missing values.</P><P>      Each place is given by: (Number of times) at (Line):(Column).</P><P>      7151 at 50:28   2987 at 52:11   </P><P>NOTE: There were 20050 observations read from the data set WORK.AHN_FINAL834.</P><P>NOTE: The data set WORK.NYU has 20050 observations and 458 variables.</P><P>NOTE: At least one W.D format was too small for the number to be printed. The decimal may be shifted by the "BEST" format.</P><P>NOTE: DATA statement used (Total process time):</P><P>      real time           0.17 seconds</P><P>      cpu time            0.18 seconds</P><P>      </P><P></P><P></P><P>83          proc surveyreg data=nyu;</P><P>84         class HSSEX race bmi smoke DMPCREGN;</P><P>85         model log_TG = pm_iqr HSAGEIR HSSEX race bmi smoke DMPCREGN / CLPARM SOLUTION;</P><P>86         domain eligible*snp1;</P><P>87         run;</P><P></P><P></P><P>NOTE: In data set NYU, total 20050 observations read, 15118 observations with missing values are omitted.</P><P>NOTE: The PROCEDURE SURVEYREG printed pages 1-5.</P><P>NOTE: PROCEDURE SURVEYREG used (Total process time):</P><P>      real time           1.03 seconds</P><P>      cpu time            1.03 seconds</P><P>      </P><P></P><P></P><P>88          proc surveyreg data=nyu;</P><P>89         class HSSEX race bmi smoke DMPCREGN;</P><P>90         model log_TG = pm_iqr HSAGEIR HSSEX race bmi smoke DMPCREGN / CLPARM SOLUTION;</P><P>91         domain eligible*snp2;</P><P>92         run;</P><P></P><P></P><P>NOTE: In data set NYU, total 20050 observations read, 15429 observations with missing values are omitted.</P><P>NOTE: The PROCEDURE SURVEYREG printed pages 6-10.</P><P>NOTE: PROCEDURE SURVEYREG used (Total process time):</P><P>      real time           0.92 seconds</P><P>      cpu time            0.92 seconds</P><P>      </P><P></P><P></P><P>93          proc surveyreg data=nyu;</P><P>94         class HSSEX race bmi smoke DMPCREGN;</P><P>95         model log_TG =  pm_iqr HSAGEIR HSSEX race bmi smoke DMPCREGN / CLPARM SOLUTION;</P><P>96         domain eligible*snp3;</P><P>97         run;</P><P></P><P></P><P>NOTE: In data set NYU, total 20050 observations read, 15205 observations with missing values are omitted.</P><P>NOTE: The PROCEDURE SURVEYREG printed pages 11-15.</P><P>NOTE: PROCEDURE SURVEYREG used (Total process time):</P><P>      real time           0.92 seconds</P><P>      cpu time            0.92 seconds</P><P>      </P><P></P><P></P><P>98          proc surveyreg data=nyu;</P><P>99         class HSSEX race bmi smoke DMPCREGN;</P><P>100         model log_TG = pm_iqr HSAGEIR HSSEX race bmi smoke DMPCREGN / CLPARM SOLUTION;</P><P>101         domain eligible*snp4;</P><P>102        run;</P><P></P><P></P><P>NOTE: In data set NYU, total 20050 observations read, 15204 observations with missing values are omitted.</P><P>NOTE: The PROCEDURE SURVEYREG printed pages 16-20.</P><P>NOTE: PROCEDURE SURVEYREG used (Total process time):</P><P>      real time           0.92 seconds</P><P>      cpu time            0.92 seconds</P><P>      </P><P></P><P></P><P>103         proc surveyreg data=nyu;</P><P>104         class HSSEX race bmi smoke DMPCREGN;</P><P>105         model log_TG = pm_iqr HSAGEIR HSSEX race bmi smoke DMPCREGN / CLPARM SOLUTION;</P><P>106         domain eligible*snp5;</P><P>107        run;</P><P></P><P></P><P>NOTE: In data set NYU, total 20050 observations read, 15097 observations with missing values are omitted.</P><P>NOTE: The PROCEDURE SURVEYREG printed pages 21-25.</P><P>NOTE: PROCEDURE SURVEYREG used (Total process time):</P><P>      real time           0.95 seconds</P><P>      cpu time            0.96 seconds</P><P>      </P><P></P><P></P><P>108         proc surveyreg data=nyu;</P><P>109         class HSSEX race bmi smoke DMPCREGN;</P><P>110         model log_TG = pm_iqr HSAGEIR HSSEX race bmi smoke DMPCREGN / CLPARM SOLUTION;</P><P>111         domain eligible*snp6;</P><P>112        run;</P><P></P><P></P><P>NOTE: In data set NYU, total 20050 observations read, 19973 observations with missing values are omitted.</P><P>NOTE: All observations were omitted due to missing values or non-positive weights in domain eligible=0 snp6=va.</P><P>NOTE: All observations were omitted due to missing values or non-positive weights in domain eligible=0 snp6=wt.</P><P>NOTE: The PROCEDURE SURVEYREG printed pages 26-28.</P><P>NOTE: PROCEDURE SURVEYREG used (Total process time):</P><P>      real time           0.69 seconds</P><P>      cpu time            0.70 seconds</P><P>      </P><P></P><P></P><P>113         proc surveyreg data=nyu;</P><P>114         class HSSEX race bmi smoke DMPCREGN;</P><P>115         model log_TG = pm_iqr HSAGEIR HSSEX race bmi smoke DMPCREGN / CLPARM SOLUTION;</P><P>116         domain eligible*snp7;</P><P>117        run;</P><P></P><P></P><P>NOTE: In data set NYU, total 20050 observations read, 15161 observations with missing values are omitted.</P><P>NOTE: The PROCEDURE SURVEYREG printed pages 29-33.</P><P>NOTE: PROCEDURE SURVEYREG used (Total process time):</P><P>      real time           0.91 seconds</P><P>      cpu time            0.92 seconds</P><P>      </P><P></P><P></P><P>118         proc surveyreg data=nyu;</P><P>119         class HSSEX race bmi smoke DMPCREGN;</P><P>120         model log_TG = pm_iqr HSAGEIR HSSEX race bmi smoke DMPCREGN / CLPARM SOLUTION;</P><P>121         domain eligible*snp8;</P><P>122        run;</P><P></P><P></P><P>NOTE: In data set NYU, total 20050 observations read, 15118 observations with missing values are omitted.</P><P>NOTE: The PROCEDURE SURVEYREG printed pages 34-38.</P><P>NOTE: PROCEDURE SURVEYREG used (Total process time):</P><P>      real time           0.91 seconds</P><P>      cpu time            0.92 seconds</P><P>      </P><P></P><P></P><P>123         proc surveyreg data=nyu;</P><P>124         class bmi HSSEX race smoke DMPCREGN snp1;</P><P>125         model log_TG = pm_iqr HSAGEIR HSSEX bmi race smoke DMPCREGN snp1 pm_iqr*snp1 / CLPARM SOLUTION;</P><P>126         domain eligible;</P><P>127        run;</P><P></P><P></P><P>NOTE: In data set NYU, total 20050 observations read, 15118 observations with missing values are omitted.</P><P>NOTE: The PROCEDURE SURVEYREG printed pages 39-41.</P><P>NOTE: PROCEDURE SURVEYREG used (Total process time):</P><P>      real time           0.75 seconds</P><P>      cpu time            0.74 seconds</P><P>      </P><P></P><P></P><P>128         proc surveyreg data=nyu;</P><P>129         class  bmi HSSEX race smoke DMPCREGN snp2;</P><P>130         model log_TG = pm_iqr HSAGEIR HSSEX bmi race smoke DMPCREGN snp2 pm_iqr*snp2 / CLPARM SOLUTION;</P><P>131         domain eligible;</P><P>132        run;</P><P></P><P></P><P>NOTE: In data set NYU, total 20050 observations read, 15429 observations with missing values are omitted.</P><P>NOTE: The PROCEDURE SURVEYREG printed pages 42-44.</P><P>NOTE: PROCEDURE SURVEYREG used (Total process time):</P><P>      real time           0.81 seconds</P><P>      cpu time            0.82 seconds</P><P>      </P><P></P><P></P><P>133         proc surveyreg data=nyu;</P><P>134         class bmi HSSEX race smoke DMPCREGN snp3 ;</P><P>135         model log_TG = pm_iqr HSAGEIR HSSEX bmi race smoke DMPCREGN snp3  pm_iqr*snp3 / CLPARM SOLUTION;</P><P>136         domain eligible;</P><P>137        run;</P><P></P><P></P><P>NOTE: In data set NYU, total 20050 observations read, 15205 observations with missing values are omitted.</P><P>NOTE: The PROCEDURE SURVEYREG printed pages 45-47.</P><P>NOTE: PROCEDURE SURVEYREG used (Total process time):</P><P>      real time           0.74 seconds</P><P>      cpu time            0.73 seconds</P><P>      </P><P></P><P></P><P>138         proc surveyreg data=nyu;</P><P>139         class  bmi HSSEX race smoke DMPCREGN snp4;</P><P>140         model log_TG = pm_iqr HSAGEIR HSSEX bmi race smoke DMPCREGN snp4  pm_iqr*snp4 / CLPARM SOLUTION;</P><P>141         domain eligible;</P><P>142        run;</P><P></P><P></P><P>NOTE: In data set NYU, total 20050 observations read, 15204 observations with missing values are omitted.</P><P>NOTE: The PROCEDURE SURVEYREG printed pages 48-50.</P><P>NOTE: PROCEDURE SURVEYREG used (Total process time):</P><P>      real time           0.80 seconds</P><P>      cpu time            0.79 seconds</P><P>      </P><P></P><P></P><P>143         proc surveyreg data=nyu;</P><P>144         class bmi HSSEX race smoke DMPCREGN snp5;</P><P>145         model log_TG = pm_iqr HSAGEIR HSSEX bmi race smoke DMPCREGN snp5  pm_iqr*snp5 / CLPARM SOLUTION;</P><P>146         domain eligible;</P><P>147        run;</P><P></P><P></P><P>NOTE: In data set NYU, total 20050 observations read, 15097 observations with missing values are omitted.</P><P>NOTE: The PROCEDURE SURVEYREG printed pages 51-53.</P><P>NOTE: PROCEDURE SURVEYREG used (Total process time):</P><P>      real time           0.73 seconds</P><P>      cpu time            0.74 seconds</P><P>      </P><P></P><P></P><P>148         proc surveyreg data=nyu;</P><P>149         class bmi HSSEX race smoke DMPCREGN snp6;</P><P>150         model log_TG = pm_iqr HSAGEIR HSSEX bmi race smoke DMPCREGN snp6  pm_iqr*snp6 / CLPARM SOLUTION;</P><P>151         domain eligible;</P><P>152        run;</P><P></P><P></P><P>NOTE: In data set NYU, total 20050 observations read, 19973 observations with missing values are omitted.</P><P>NOTE: All observations were omitted due to missing values or non-positive weights in domain eligible=0.</P><P>NOTE: The PROCEDURE SURVEYREG printed pages 54-55.</P><P>NOTE: PROCEDURE SURVEYREG used (Total process time):</P><P>      real time           0.57 seconds</P><P>      cpu time            0.56 seconds</P><P>      </P><P></P><P></P><P>153         proc surveyreg data=nyu;</P><P>154         class bmi HSSEX race smoke DMPCREGN snp7;</P><P>155         model log_TG = pm_iqr HSAGEIR HSSEX bmi race smoke DMPCREGN snp7  pm_iqr*snp7 / CLPARM SOLUTION;</P><P>156         domain eligible;</P><P>157        run;</P><P></P><P></P><P>NOTE: In data set NYU, total 20050 observations read, 15161 observations with missing values are omitted.</P><P>NOTE: The PROCEDURE SURVEYREG printed pages 56-58.</P><P>NOTE: PROCEDURE SURVEYREG used (Total process time):</P><P>      real time           0.73 seconds</P><P>      cpu time            0.73 seconds</P><P>      </P><P></P><P></P><P>158         proc surveyreg data=nyu;</P><P>159         class bmi HSSEX race smoke DMPCREGN snp8 ;</P><P>160         model log_TG = pm_iqr HSAGEIR HSSEX bmi race smoke DMPCREGN snp8  pm_iqr*snp8 / CLPARM SOLUTION;</P><P>161         domain eligible;</P><P>162        run;</P><P></P><P></P><P>NOTE: In data set NYU, total 20050 observations read, 15118 observations with missing values are omitted.</P><P>NOTE: The PROCEDURE SURVEYREG printed pages 59-61.</P><P>NOTE: PROCEDURE SURVEYREG used (Total process time):</P><P>      real time           0.74 seconds</P><P>      cpu time            0.74 seconds</P><P>      </P><P></P><P></P><P>163        </P><P>164        </P><P>165        </P><P>166        </P><P></P><P></P><P>NOTE: SAS Institute Inc., SAS Campus Drive, Cary, NC USA 27513-2414</P><P>NOTE: The SAS System used:</P><P>      real time           15.65 seconds</P><P>      cpu time            13.66 seconds</P></BODY></HTML> Wed, 09 Jul 2014 15:00:56 GMT hershee1121 2014-07-09T15:00:56Z Invalid numeric data error https://communities.sas.com/t5/SAS-Procedures/Invalid-numeric-data-error/m-p/173018#M44568 <HTML><HEAD></HEAD><BODY><P>I do not understand why I am getting this error:</P><P></P><P>NOTE: Invalid numeric data, rs9939609='TT' , at line 54 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='TT' , at line 55 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='TT' , at line 56 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='TT' , at line 54 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='TT' , at line 55 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='TT' , at line 56 column 5.</P><P>_N_=10122</P><P>NOTE: Invalid numeric data, rs9939609='AT' , at line 54 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='AT' , at line 55 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='AT' , at line 56 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='TT' , at line 54 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='TT' , at line 55 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='TT' , at line 56 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='AT' , at line 54 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='AT' , at line 55 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='AT' , at line 56 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='AT' , at line 54 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='AT' , at line 55 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='AT' , at line 56 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='TT' , at line 54 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='TT' , at line 55 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='TT' , at line 56 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='TT' , at line 54 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='TT' , at line 55 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='TT' , at line 56 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='TT' , at line 54 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='TT' , at line 55 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='TT' , at line 56 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='TT' , at line 54 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='TT' , at line 55 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='TT' , at line 56 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='AT' , at line 54 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='AT' , at line 55 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='AT' , at line 56 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='AT' , at line 54 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='AT' , at line 55 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='AT' , at line 56 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='TT' , at line 54 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='TT' , at line 55 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='TT' , at line 56 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='TT' , at line 54 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='TT' , at line 55 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='TT' , at line 56 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='AT' , at line 54 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='AT' , at line 55 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='AT' , at line 56 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='TT' , at line 54 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='TT' , at line 55 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='TT' , at line 56 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='TT' , at line 54 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='TT' , at line 55 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='TT' , at line 56 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='TT' , at line 54 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='TT' , at line 55 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='TT' , at line 56 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='TT' , at line 54 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='TT' , at line 55 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='TT' , at line 56 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='AT' , at line 54 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='AT' , at line 55 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='AT' , at line 56 column 5.</P><P>NOTE: Missing values were generated as a result of performing an operation on missing values.</P><P></P><P></P><P>.....When I enter the following code:</P><P></P><TABLE><TBODY><TR><TD>54        </TD><TD>if rs9939609 = 44 then rs9939609_new = "TT";</TD></TR><TR><TD>55        </TD><TD>if rs9939609 = 14 then rs9939609_new = "AT";</TD></TR><TR><TD>56        </TD><TD>if rs9939609 = 11 then rs9939609_new = "AA";</TD></TR></TBODY></TABLE><P></P><P></P><P>Thanks,</P><P>Gita</P></BODY></HTML> Wed, 09 Jul 2014 14:47:39 GMT https://communities.sas.com/t5/SAS-Procedures/Invalid-numeric-data-error/m-p/173018#M44568 hershee1121 2014-07-09T14:47:39Z Re: Invalid numeric data error https://communities.sas.com/t5/SAS-Procedures/Invalid-numeric-data-error/m-p/173019#M44569 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>The variable rs9939609 is a character variable holding data such as TT or AT, you are trying to compare that to a numeric 44 or 14, hence you get the notes.  This is my assumption from what you have provided.</P></BODY></HTML> Wed, 09 Jul 2014 14:50:06 GMT https://communities.sas.com/t5/SAS-Procedures/Invalid-numeric-data-error/m-p/173019#M44569 RW9 2014-07-09T14:50:06Z Re: Invalid numeric data error https://communities.sas.com/t5/SAS-Procedures/Invalid-numeric-data-error/m-p/173020#M44570 <HTML><HEAD></HEAD><BODY><P>Post the full code/log. You'll note that the error is for rs9939609 so there's something wrong with that variable. Most likely you forgot _new for one of the if then lines or the variable is originally a text variable and should be = '11' rather than =11.</P><P></P><P>You should also be using if/then/else rather than if/then.</P></BODY></HTML> Wed, 09 Jul 2014 14:51:42 GMT https://communities.sas.com/t5/SAS-Procedures/Invalid-numeric-data-error/m-p/173020#M44570 Reeza 2014-07-09T14:51:42Z Re: Invalid numeric data error https://communities.sas.com/t5/SAS-Procedures/Invalid-numeric-data-error/m-p/173021#M44571 <HTML><HEAD></HEAD><BODY><P>This is the full log:</P><P></P><P>8           proc FORMAT;</P><P>9          </P><P>9        !  VALUE ELIGFMT</P><P>10         1 = "Eligible"</P><P>11         2 = "Under age 17"</P><P>12         3 = "Ineligible" ;</P><P>NOTE: Format ELIGFMT has been output.</P><P>13        </P><P>13       !  VALUE MORTFMT</P><P>14         0 = "Assumed alive"</P><P>15         1 = "Assumed deceased"</P><P>16         . = "Ineligible or under age 17";</P><P>NOTE: Format MORTFMT has been output.</P><P>17         RUN ;</P><P></P><P></P><P>NOTE: PROCEDURE FORMAT used (Total process time):</P><P>      real time           0.05 seconds</P><P>      cpu time            0.00 seconds</P><P>      </P><P></P><P></P><P>18         </P><P>19         data nyu ;</P><P>20         set ahn_final834 ;</P><P>21         </P><P>22         if PEPMNK1R = 888 then PEPMNK1R=. ;</P><P>23         if PM10StEYM20MeanW ne . and PEPMNK1R ne .</P><P>24         then eligible = 1 ; else eligible = 0 ; * SUBSET ELIGIBLE ;</P><P>25         </P><P>26         if HSSEX=2 then HSSEX=0; * 0=F, 1=M ;</P><P>27        </P><P>28         </P><P>29         if TGP = 8888 or TGP>1450 then TGP=. ;</P><P>30         if TCP = 888 or TCP>600 then TCP=. ;                           * remove extreme values ;</P><P>31        </P><P>32         if BMPBMI = 8888 then BMPBMI=. ;</P><P>33         if 0<BMPBMI<18.5 then bmi=1 ;</P><P>34         if BMPBMI>=18.5 and BMPBMI<25 then bmi=4 ;</P><P>35         if BMPBMI>=25 and BMPBMI<30 then bmi=2 ;</P><P>36         if BMPBMI>=30 then bmi=3 ;</P><P>37         if BMPBMI=. or BMPBMI=0 then bmi=0 ;</P><P>38         </P><P>39         if HAR1=2 then smoke=3 ;</P><P>40         if HAR1=1 and HAR3=2 then smoke=2 ;</P><P>41         if HAR1=1 and HAR3=1 then smoke=1 ;</P><P>42         if HAR1=. or HAR1=8 or HAR3=8 then smoke=3 ;</P><P>43         </P><P>44         </P><P>45         if DMARACER=1 then race=2 ;</P><P>46         if DMARACER=2 then race=1 ;</P><P>47         if DMARACER in (3,8) then race=0 ;</P><P>48         </P><P>49        </P><P>50         pm_iqr = PM10StEYM20MeanW / 10.8486 ; * PM10 per IQR ;</P><P>51         </P><P>52         log_TG = log(TGP);</P><P>53         </P><P>54         if rs9939609 = 44 then rs9939609_new = "TT";</P><P>55         if rs9939609 = 14 then rs9939609_new = "AT";</P><P>56         if rs9939609 = 11 then rs9939609_new = "AA";</P><P>57         </P><P>58         </P><P>59         if rs515135 = "GG" then snp1 = "wt" ;</P><P>60         if rs515135 in ("AG", "AA")  then snp1 = "var" ;</P><P>61         </P><P>62         if rs3751812 = "GG" then snp2 = "wt" ;</P><P>63         if rs3751812 in ("GT", "TT")  then snp2 = "var" ;</P><P>64         </P><P>65         if rs1454626 = "AA" then snp3 = "wt" ;</P><P>66         if rs1454626 in ("AC", "CC")  then snp3 = "var" ;</P><P>67         </P><P>68         if rs6919346 = "GG" then snp4 = "wt" ;</P><P>69         if rs6919346 in ("AG", "AA")  then snp4 = "var" ;</P><P>70         </P><P>71         if rs7903146 = 22 then snp5 = "wt" ;</P><P>72         if rs7903146 in (24, 44)  then snp5 = "var" ;</P><P>73         </P><P>74         if rs9939609_new = "TT" then snp6 = "wt" ;</P><P>75         if rs9939609_new in ("AA", "AT") then snp6 = "var" ;</P><P>76         </P><P>77         if rs17366743 = "TT" then snp7 = "wt" ;</P><P>78         if rs17366743 in ("CT", "CC") then snp7 = "var" ;</P><P>79         </P><P>80         if rs17782313_A = "TT" then snp8 = "wt" ;</P><P>81         if rs17782313_A in ("CT", "CC") then snp8 = "var" ;</P><P>82         run;</P><P></P><P></P><P>NOTE: Character values have been converted to numeric values at the places given by: (Line):(Column).</P><P>      54:5   55:5   56:5   </P><P>NOTE: Invalid numeric data, rs9939609='TT' , at line 54 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='TT' , at line 55 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='TT' , at line 56 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='TT' , at line 54 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='TT' , at line 55 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='TT' , at line 56 column 5.</P><P>_N_=10122</P><P>NOTE: Invalid numeric data, rs9939609='AT' , at line 54 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='AT' , at line 55 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='AT' , at line 56 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='TT' , at line 54 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='TT' , at line 55 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='TT' , at line 56 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='AT' , at line 54 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='AT' , at line 55 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='AT' , at line 56 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='AT' , at line 54 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='AT' , at line 55 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='AT' , at line 56 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='TT' , at line 54 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='TT' , at line 55 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='TT' , at line 56 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='TT' , at line 54 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='TT' , at line 55 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='TT' , at line 56 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='TT' , at line 54 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='TT' , at line 55 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='TT' , at line 56 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='TT' , at line 54 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='TT' , at line 55 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='TT' , at line 56 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='AT' , at line 54 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='AT' , at line 55 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='AT' , at line 56 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='AT' , at line 54 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='AT' , at line 55 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='AT' , at line 56 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='TT' , at line 54 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='TT' , at line 55 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='TT' , at line 56 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='TT' , at line 54 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='TT' , at line 55 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='TT' , at line 56 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='AT' , at line 54 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='AT' , at line 55 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='AT' , at line 56 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='TT' , at line 54 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='TT' , at line 55 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='TT' , at line 56 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='TT' , at line 54 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='TT' , at line 55 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='TT' , at line 56 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='TT' , at line 54 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='TT' , at line 55 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='TT' , at line 56 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='TT' , at line 54 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='TT' , at line 55 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='TT' , at line 56 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='AT' , at line 54 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='AT' , at line 55 column 5.</P><P>NOTE: Invalid numeric data, rs9939609='AT' , at line 56 column 5.</P><P>NOTE: Missing values were generated as a result of performing an operation on missing values.</P><P>      Each place is given by: (Number of times) at (Line):(Column).</P><P>      7151 at 50:28   2987 at 52:11   </P><P>NOTE: There were 20050 observations read from the data set WORK.AHN_FINAL834.</P><P>NOTE: The data set WORK.NYU has 20050 observations and 458 variables.</P><P>NOTE: At least one W.D format was too small for the number to be printed. The decimal may be shifted by the "BEST" format.</P><P>NOTE: DATA statement used (Total process time):</P><P>      real time           0.17 seconds</P><P>      cpu time            0.18 seconds</P><P>      </P><P></P><P></P><P>83          proc surveyreg data=nyu;</P><P>84         class HSSEX race bmi smoke DMPCREGN;</P><P>85         model log_TG = pm_iqr HSAGEIR HSSEX race bmi smoke DMPCREGN / CLPARM SOLUTION;</P><P>86         domain eligible*snp1;</P><P>87         run;</P><P></P><P></P><P>NOTE: In data set NYU, total 20050 observations read, 15118 observations with missing values are omitted.</P><P>NOTE: The PROCEDURE SURVEYREG printed pages 1-5.</P><P>NOTE: PROCEDURE SURVEYREG used (Total process time):</P><P>      real time           1.03 seconds</P><P>      cpu time            1.03 seconds</P><P>      </P><P></P><P></P><P>88          proc surveyreg data=nyu;</P><P>89         class HSSEX race bmi smoke DMPCREGN;</P><P>90         model log_TG = pm_iqr HSAGEIR HSSEX race bmi smoke DMPCREGN / CLPARM SOLUTION;</P><P>91         domain eligible*snp2;</P><P>92         run;</P><P></P><P></P><P>NOTE: In data set NYU, total 20050 observations read, 15429 observations with missing values are omitted.</P><P>NOTE: The PROCEDURE SURVEYREG printed pages 6-10.</P><P>NOTE: PROCEDURE SURVEYREG used (Total process time):</P><P>      real time           0.92 seconds</P><P>      cpu time            0.92 seconds</P><P>      </P><P></P><P></P><P>93          proc surveyreg data=nyu;</P><P>94         class HSSEX race bmi smoke DMPCREGN;</P><P>95         model log_TG =  pm_iqr HSAGEIR HSSEX race bmi smoke DMPCREGN / CLPARM SOLUTION;</P><P>96         domain eligible*snp3;</P><P>97         run;</P><P></P><P></P><P>NOTE: In data set NYU, total 20050 observations read, 15205 observations with missing values are omitted.</P><P>NOTE: The PROCEDURE SURVEYREG printed pages 11-15.</P><P>NOTE: PROCEDURE SURVEYREG used (Total process time):</P><P>      real time           0.92 seconds</P><P>      cpu time            0.92 seconds</P><P>      </P><P></P><P></P><P>98          proc surveyreg data=nyu;</P><P>99         class HSSEX race bmi smoke DMPCREGN;</P><P>100         model log_TG = pm_iqr HSAGEIR HSSEX race bmi smoke DMPCREGN / CLPARM SOLUTION;</P><P>101         domain eligible*snp4;</P><P>102        run;</P><P></P><P></P><P>NOTE: In data set NYU, total 20050 observations read, 15204 observations with missing values are omitted.</P><P>NOTE: The PROCEDURE SURVEYREG printed pages 16-20.</P><P>NOTE: PROCEDURE SURVEYREG used (Total process time):</P><P>      real time           0.92 seconds</P><P>      cpu time            0.92 seconds</P><P>      </P><P></P><P></P><P>103         proc surveyreg data=nyu;</P><P>104         class HSSEX race bmi smoke DMPCREGN;</P><P>105         model log_TG = pm_iqr HSAGEIR HSSEX race bmi smoke DMPCREGN / CLPARM SOLUTION;</P><P>106         domain eligible*snp5;</P><P>107        run;</P><P></P><P></P><P>NOTE: In data set NYU, total 20050 observations read, 15097 observations with missing values are omitted.</P><P>NOTE: The PROCEDURE SURVEYREG printed pages 21-25.</P><P>NOTE: PROCEDURE SURVEYREG used (Total process time):</P><P>      real time           0.95 seconds</P><P>      cpu time            0.96 seconds</P><P>      </P><P></P><P></P><P>108         proc surveyreg data=nyu;</P><P>109         class HSSEX race bmi smoke DMPCREGN;</P><P>110         model log_TG = pm_iqr HSAGEIR HSSEX race bmi smoke DMPCREGN / CLPARM SOLUTION;</P><P>111         domain eligible*snp6;</P><P>112        run;</P><P></P><P></P><P>NOTE: In data set NYU, total 20050 observations read, 19973 observations with missing values are omitted.</P><P>NOTE: All observations were omitted due to missing values or non-positive weights in domain eligible=0 snp6=va.</P><P>NOTE: All observations were omitted due to missing values or non-positive weights in domain eligible=0 snp6=wt.</P><P>NOTE: The PROCEDURE SURVEYREG printed pages 26-28.</P><P>NOTE: PROCEDURE SURVEYREG used (Total process time):</P><P>      real time           0.69 seconds</P><P>      cpu time            0.70 seconds</P><P>      </P><P></P><P></P><P>113         proc surveyreg data=nyu;</P><P>114         class HSSEX race bmi smoke DMPCREGN;</P><P>115         model log_TG = pm_iqr HSAGEIR HSSEX race bmi smoke DMPCREGN / CLPARM SOLUTION;</P><P>116         domain eligible*snp7;</P><P>117        run;</P><P></P><P></P><P>NOTE: In data set NYU, total 20050 observations read, 15161 observations with missing values are omitted.</P><P>NOTE: The PROCEDURE SURVEYREG printed pages 29-33.</P><P>NOTE: PROCEDURE SURVEYREG used (Total process time):</P><P>      real time           0.91 seconds</P><P>      cpu time            0.92 seconds</P><P>      </P><P></P><P></P><P>118         proc surveyreg data=nyu;</P><P>119         class HSSEX race bmi smoke DMPCREGN;</P><P>120         model log_TG = pm_iqr HSAGEIR HSSEX race bmi smoke DMPCREGN / CLPARM SOLUTION;</P><P>121         domain eligible*snp8;</P><P>122        run;</P><P></P><P></P><P>NOTE: In data set NYU, total 20050 observations read, 15118 observations with missing values are omitted.</P><P>NOTE: The PROCEDURE SURVEYREG printed pages 34-38.</P><P>NOTE: PROCEDURE SURVEYREG used (Total process time):</P><P>      real time           0.91 seconds</P><P>      cpu time            0.92 seconds</P><P>      </P><P></P><P></P><P>123         proc surveyreg data=nyu;</P><P>124         class bmi HSSEX race smoke DMPCREGN snp1;</P><P>125         model log_TG = pm_iqr HSAGEIR HSSEX bmi race smoke DMPCREGN snp1 pm_iqr*snp1 / CLPARM SOLUTION;</P><P>126         domain eligible;</P><P>127        run;</P><P></P><P></P><P>NOTE: In data set NYU, total 20050 observations read, 15118 observations with missing values are omitted.</P><P>NOTE: The PROCEDURE SURVEYREG printed pages 39-41.</P><P>NOTE: PROCEDURE SURVEYREG used (Total process time):</P><P>      real time           0.75 seconds</P><P>      cpu time            0.74 seconds</P><P>      </P><P></P><P></P><P>128         proc surveyreg data=nyu;</P><P>129         class  bmi HSSEX race smoke DMPCREGN snp2;</P><P>130         model log_TG = pm_iqr HSAGEIR HSSEX bmi race smoke DMPCREGN snp2 pm_iqr*snp2 / CLPARM SOLUTION;</P><P>131         domain eligible;</P><P>132        run;</P><P></P><P></P><P>NOTE: In data set NYU, total 20050 observations read, 15429 observations with missing values are omitted.</P><P>NOTE: The PROCEDURE SURVEYREG printed pages 42-44.</P><P>NOTE: PROCEDURE SURVEYREG used (Total process time):</P><P>      real time           0.81 seconds</P><P>      cpu time            0.82 seconds</P><P>      </P><P></P><P></P><P>133         proc surveyreg data=nyu;</P><P>134         class bmi HSSEX race smoke DMPCREGN snp3 ;</P><P>135         model log_TG = pm_iqr HSAGEIR HSSEX bmi race smoke DMPCREGN snp3  pm_iqr*snp3 / CLPARM SOLUTION;</P><P>136         domain eligible;</P><P>137        run;</P><P></P><P></P><P>NOTE: In data set NYU, total 20050 observations read, 15205 observations with missing values are omitted.</P><P>NOTE: The PROCEDURE SURVEYREG printed pages 45-47.</P><P>NOTE: PROCEDURE SURVEYREG used (Total process time):</P><P>      real time           0.74 seconds</P><P>      cpu time            0.73 seconds</P><P>      </P><P></P><P></P><P>138         proc surveyreg data=nyu;</P><P>139         class  bmi HSSEX race smoke DMPCREGN snp4;</P><P>140         model log_TG = pm_iqr HSAGEIR HSSEX bmi race smoke DMPCREGN snp4  pm_iqr*snp4 / CLPARM SOLUTION;</P><P>141         domain eligible;</P><P>142        run;</P><P></P><P></P><P>NOTE: In data set NYU, total 20050 observations read, 15204 observations with missing values are omitted.</P><P>NOTE: The PROCEDURE SURVEYREG printed pages 48-50.</P><P>NOTE: PROCEDURE SURVEYREG used (Total process time):</P><P>      real time           0.80 seconds</P><P>      cpu time            0.79 seconds</P><P>      </P><P></P><P></P><P>143         proc surveyreg data=nyu;</P><P>144         class bmi HSSEX race smoke DMPCREGN snp5;</P><P>145         model log_TG = pm_iqr HSAGEIR HSSEX bmi race smoke DMPCREGN snp5  pm_iqr*snp5 / CLPARM SOLUTION;</P><P>146         domain eligible;</P><P>147        run;</P><P></P><P></P><P>NOTE: In data set NYU, total 20050 observations read, 15097 observations with missing values are omitted.</P><P>NOTE: The PROCEDURE SURVEYREG printed pages 51-53.</P><P>NOTE: PROCEDURE SURVEYREG used (Total process time):</P><P>      real time           0.73 seconds</P><P>      cpu time            0.74 seconds</P><P>      </P><P></P><P></P><P>148         proc surveyreg data=nyu;</P><P>149         class bmi HSSEX race smoke DMPCREGN snp6;</P><P>150         model log_TG = pm_iqr HSAGEIR HSSEX bmi race smoke DMPCREGN snp6  pm_iqr*snp6 / CLPARM SOLUTION;</P><P>151         domain eligible;</P><P>152        run;</P><P></P><P></P><P>NOTE: In data set NYU, total 20050 observations read, 19973 observations with missing values are omitted.</P><P>NOTE: All observations were omitted due to missing values or non-positive weights in domain eligible=0.</P><P>NOTE: The PROCEDURE SURVEYREG printed pages 54-55.</P><P>NOTE: PROCEDURE SURVEYREG used (Total process time):</P><P>      real time           0.57 seconds</P><P>      cpu time            0.56 seconds</P><P>      </P><P></P><P></P><P>153         proc surveyreg data=nyu;</P><P>154         class bmi HSSEX race smoke DMPCREGN snp7;</P><P>155         model log_TG = pm_iqr HSAGEIR HSSEX bmi race smoke DMPCREGN snp7  pm_iqr*snp7 / CLPARM SOLUTION;</P><P>156         domain eligible;</P><P>157        run;</P><P></P><P></P><P>NOTE: In data set NYU, total 20050 observations read, 15161 observations with missing values are omitted.</P><P>NOTE: The PROCEDURE SURVEYREG printed pages 56-58.</P><P>NOTE: PROCEDURE SURVEYREG used (Total process time):</P><P>      real time           0.73 seconds</P><P>      cpu time            0.73 seconds</P><P>      </P><P></P><P></P><P>158         proc surveyreg data=nyu;</P><P>159         class bmi HSSEX race smoke DMPCREGN snp8 ;</P><P>160         model log_TG = pm_iqr HSAGEIR HSSEX bmi race smoke DMPCREGN snp8  pm_iqr*snp8 / CLPARM SOLUTION;</P><P>161         domain eligible;</P><P>162        run;</P><P></P><P></P><P>NOTE: In data set NYU, total 20050 observations read, 15118 observations with missing values are omitted.</P><P>NOTE: The PROCEDURE SURVEYREG printed pages 59-61.</P><P>NOTE: PROCEDURE SURVEYREG used (Total process time):</P><P>      real time           0.74 seconds</P><P>      cpu time            0.74 seconds</P><P>      </P><P></P><P></P><P>163        </P><P>164        </P><P>165        </P><P>166        </P><P></P><P></P><P>NOTE: SAS Institute Inc., SAS Campus Drive, Cary, NC USA 27513-2414</P><P>NOTE: The SAS System used:</P><P>      real time           15.65 seconds</P><P>      cpu time            13.66 seconds</P></BODY></HTML> Wed, 09 Jul 2014 15:00:56 GMT https://communities.sas.com/t5/SAS-Procedures/Invalid-numeric-data-error/m-p/173021#M44571 hershee1121 2014-07-09T15:00:56Z Re: Invalid numeric data error https://communities.sas.com/t5/SAS-Procedures/Invalid-numeric-data-error/m-p/173022#M44572 <HTML><HEAD></HEAD><BODY><P>There is no mention in your log of what variable type rs9939609 is, I suspect it is character, hence you cannot do rs9939609=text without getting the notes.</P></BODY></HTML> Wed, 09 Jul 2014 15:04:11 GMT https://communities.sas.com/t5/SAS-Procedures/Invalid-numeric-data-error/m-p/173022#M44572 RW9 2014-07-09T15:04:11Z Re: Invalid numeric data error https://communities.sas.com/t5/SAS-Procedures/Invalid-numeric-data-error/m-p/173023#M44573 <HTML><HEAD></HEAD><BODY><P>Sorry I'm a newbie to SAS.  Can you tell me what you are referring to when you say "notes"?</P></BODY></HTML> Wed, 09 Jul 2014 16:29:51 GMT https://communities.sas.com/t5/SAS-Procedures/Invalid-numeric-data-error/m-p/173023#M44573 hershee1121 2014-07-09T16:29:51Z Re: Invalid numeric data error https://communities.sas.com/t5/SAS-Procedures/Invalid-numeric-data-error/m-p/173024#M44574 <HTML><HEAD></HEAD><BODY><P>The item in the log starting with "NOTE:"</P><P>which are not errors but generally let you know you <SPAN style="text-decoration: underline;"><STRONG>may</STRONG></SPAN> be doing something a tad off from intended. </P></BODY></HTML> Wed, 09 Jul 2014 17:09:30 GMT https://communities.sas.com/t5/SAS-Procedures/Invalid-numeric-data-error/m-p/173024#M44574 ballardw 2014-07-09T17:09:30Z Re: Invalid numeric data error https://communities.sas.com/t5/SAS-Procedures/Invalid-numeric-data-error/m-p/173025#M44575 <HTML><HEAD></HEAD><BODY><P>Yes, it is a character.  I do not know why I get "Invalid numeric data" in the output.  That is the issue I am having, and I am not sure if it is affecting my results.</P></BODY></HTML> Thu, 10 Jul 2014 19:43:37 GMT https://communities.sas.com/t5/SAS-Procedures/Invalid-numeric-data-error/m-p/173025#M44575 hershee1121 2014-07-10T19:43:37Z Re: Invalid numeric data error https://communities.sas.com/t5/SAS-Procedures/Invalid-numeric-data-error/m-p/173026#M44576 <HTML><HEAD></HEAD><BODY><P>When you use this syntax:</P><P>if rs9939609 = 44</P><P></P><P>SAS will attempt to convert the variable rs9939609 to numeric since you have asked it to be compared to a number, not a character.</P><P>The note is saying it can't conver 'TT' to a valid numeric.</P><P>The comparison should be</P><P>if rs9939609 = '44'</P><P>and similar so you compare character value to a character if you don't want the notes.</P></BODY></HTML> Thu, 10 Jul 2014 19:46:43 GMT https://communities.sas.com/t5/SAS-Procedures/Invalid-numeric-data-error/m-p/173026#M44576 ballardw 2014-07-10T19:46:43Z Re: Invalid numeric data error https://communities.sas.com/t5/SAS-Procedures/Invalid-numeric-data-error/m-p/173027#M44577 <HTML><HEAD></HEAD><BODY><P>Hello Gita,</P><P></P><P>You can reproduce the error message if you attempt to assign a text value to a numeric variable:</P><P></P><P>data _null_;</P><P>  length</P><P>    rs9939609 8;</P><P>  rs9939609 = 'TT';</P><P>  if rs9939609 = 44 then rs9939609_new = 'TT';</P><P>run;</P><P></P><P>Is variable "rs9939609" in data set "ahn_final834" character or numeric?</P></BODY></HTML> Thu, 10 Jul 2014 20:54:15 GMT https://communities.sas.com/t5/SAS-Procedures/Invalid-numeric-data-error/m-p/173027#M44577 JasonAllen 2014-07-10T20:54:15Z Re: Invalid numeric data error https://communities.sas.com/t5/SAS-Procedures/Invalid-numeric-data-error/m-p/173028#M44578 <HTML><HEAD></HEAD><BODY><P>Thank you Jason.  I just converted the numeric variable (44) to a character variable ("44") as Ballardw pointed out and that took care of the "invalid numeric data."</P></BODY></HTML> Thu, 10 Jul 2014 21:04:07 GMT https://communities.sas.com/t5/SAS-Procedures/Invalid-numeric-data-error/m-p/173028#M44578 hershee1121 2014-07-10T21:04:07Z Re: Invalid numeric data error https://communities.sas.com/t5/SAS-Procedures/Invalid-numeric-data-error/m-p/173029#M44579 <HTML><HEAD></HEAD><BODY><P>and <SPAN style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; background-color: #ffffff;"> "rs9939609"</SPAN> is a character variable.</P></BODY></HTML> Thu, 10 Jul 2014 21:04:57 GMT https://communities.sas.com/t5/SAS-Procedures/Invalid-numeric-data-error/m-p/173029#M44579 hershee1121 2014-07-10T21:04:57Z Re: Invalid numeric data error https://communities.sas.com/t5/SAS-Procedures/Invalid-numeric-data-error/m-p/173030#M44580 <HTML><HEAD></HEAD><BODY><P>Okay.  Automatic numeric-character conversion is described here:</P><P><A href="http://support.sas.com/documentation/cdl/en/lrcon/67227/HTML/default/viewer.htm#n0wdni3l4ti3fan1pd5s0zhpn3be.htm" title="http://support.sas.com/documentation/cdl/en/lrcon/67227/HTML/default/viewer.htm#n0wdni3l4ti3fan1pd5s0zhpn3be.htm">SAS Variables in Expressions :: SAS(R) 9.4 Language Reference: Concepts, Second Edition</A></P></BODY></HTML> Thu, 10 Jul 2014 21:24:29 GMT https://communities.sas.com/t5/SAS-Procedures/Invalid-numeric-data-error/m-p/173030#M44580 JasonAllen 2014-07-10T21:24:29Z