I do not understand why I am getting this error:
NOTE: Invalid numeric data, rs9939609='TT' , at line 54 column 5.
NOTE: Invalid numeric data, rs9939609='TT' , at line 55 column 5.
NOTE: Invalid numeric data, rs9939609='TT' , at line 56 column 5.
NOTE: Invalid numeric data, rs9939609='TT' , at line 54 column 5.
NOTE: Invalid numeric data, rs9939609='TT' , at line 55 column 5.
NOTE: Invalid numeric data, rs9939609='TT' , at line 56 column 5.
_N_=10122
NOTE: Invalid numeric data, rs9939609='AT' , at line 54 column 5.
NOTE: Invalid numeric data, rs9939609='AT' , at line 55 column 5.
NOTE: Invalid numeric data, rs9939609='AT' , at line 56 column 5.
NOTE: Invalid numeric data, rs9939609='TT' , at line 54 column 5.
NOTE: Invalid numeric data, rs9939609='TT' , at line 55 column 5.
NOTE: Invalid numeric data, rs9939609='TT' , at line 56 column 5.
NOTE: Invalid numeric data, rs9939609='AT' , at line 54 column 5.
NOTE: Invalid numeric data, rs9939609='AT' , at line 55 column 5.
NOTE: Invalid numeric data, rs9939609='AT' , at line 56 column 5.
NOTE: Invalid numeric data, rs9939609='AT' , at line 54 column 5.
NOTE: Invalid numeric data, rs9939609='AT' , at line 55 column 5.
NOTE: Invalid numeric data, rs9939609='AT' , at line 56 column 5.
NOTE: Invalid numeric data, rs9939609='TT' , at line 54 column 5.
NOTE: Invalid numeric data, rs9939609='TT' , at line 55 column 5.
NOTE: Invalid numeric data, rs9939609='TT' , at line 56 column 5.
NOTE: Invalid numeric data, rs9939609='TT' , at line 54 column 5.
NOTE: Invalid numeric data, rs9939609='TT' , at line 55 column 5.
NOTE: Invalid numeric data, rs9939609='TT' , at line 56 column 5.
NOTE: Invalid numeric data, rs9939609='TT' , at line 54 column 5.
NOTE: Invalid numeric data, rs9939609='TT' , at line 55 column 5.
NOTE: Invalid numeric data, rs9939609='TT' , at line 56 column 5.
NOTE: Invalid numeric data, rs9939609='TT' , at line 54 column 5.
NOTE: Invalid numeric data, rs9939609='TT' , at line 55 column 5.
NOTE: Invalid numeric data, rs9939609='TT' , at line 56 column 5.
NOTE: Invalid numeric data, rs9939609='AT' , at line 54 column 5.
NOTE: Invalid numeric data, rs9939609='AT' , at line 55 column 5.
NOTE: Invalid numeric data, rs9939609='AT' , at line 56 column 5.
NOTE: Invalid numeric data, rs9939609='AT' , at line 54 column 5.
NOTE: Invalid numeric data, rs9939609='AT' , at line 55 column 5.
NOTE: Invalid numeric data, rs9939609='AT' , at line 56 column 5.
NOTE: Invalid numeric data, rs9939609='TT' , at line 54 column 5.
NOTE: Invalid numeric data, rs9939609='TT' , at line 55 column 5.
NOTE: Invalid numeric data, rs9939609='TT' , at line 56 column 5.
NOTE: Invalid numeric data, rs9939609='TT' , at line 54 column 5.
NOTE: Invalid numeric data, rs9939609='TT' , at line 55 column 5.
NOTE: Invalid numeric data, rs9939609='TT' , at line 56 column 5.
NOTE: Invalid numeric data, rs9939609='AT' , at line 54 column 5.
NOTE: Invalid numeric data, rs9939609='AT' , at line 55 column 5.
NOTE: Invalid numeric data, rs9939609='AT' , at line 56 column 5.
NOTE: Invalid numeric data, rs9939609='TT' , at line 54 column 5.
NOTE: Invalid numeric data, rs9939609='TT' , at line 55 column 5.
NOTE: Invalid numeric data, rs9939609='TT' , at line 56 column 5.
NOTE: Invalid numeric data, rs9939609='TT' , at line 54 column 5.
NOTE: Invalid numeric data, rs9939609='TT' , at line 55 column 5.
NOTE: Invalid numeric data, rs9939609='TT' , at line 56 column 5.
NOTE: Invalid numeric data, rs9939609='TT' , at line 54 column 5.
NOTE: Invalid numeric data, rs9939609='TT' , at line 55 column 5.
NOTE: Invalid numeric data, rs9939609='TT' , at line 56 column 5.
NOTE: Invalid numeric data, rs9939609='TT' , at line 54 column 5.
NOTE: Invalid numeric data, rs9939609='TT' , at line 55 column 5.
NOTE: Invalid numeric data, rs9939609='TT' , at line 56 column 5.
NOTE: Invalid numeric data, rs9939609='AT' , at line 54 column 5.
NOTE: Invalid numeric data, rs9939609='AT' , at line 55 column 5.
NOTE: Invalid numeric data, rs9939609='AT' , at line 56 column 5.
NOTE: Missing values were generated as a result of performing an operation on missing values.
.....When I enter the following code:
54 | if rs9939609 = 44 then rs9939609_new = "TT"; |
55 | if rs9939609 = 14 then rs9939609_new = "AT"; |
56 | if rs9939609 = 11 then rs9939609_new = "AA"; |
Thanks,
Gita
When you use this syntax:
if rs9939609 = 44
SAS will attempt to convert the variable rs9939609 to numeric since you have asked it to be compared to a number, not a character.
The note is saying it can't conver 'TT' to a valid numeric.
The comparison should be
if rs9939609 = '44'
and similar so you compare character value to a character if you don't want the notes.
Hi,
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.
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.
You should also be using if/then/else rather than if/then.
This is the full log:
8 proc FORMAT;
9
9 ! VALUE ELIGFMT
10 1 = "Eligible"
11 2 = "Under age 17"
12 3 = "Ineligible" ;
NOTE: Format ELIGFMT has been output.
13
13 ! VALUE MORTFMT
14 0 = "Assumed alive"
15 1 = "Assumed deceased"
16 . = "Ineligible or under age 17";
NOTE: Format MORTFMT has been output.
17 RUN ;
NOTE: PROCEDURE FORMAT used (Total process time):
real time 0.05 seconds
cpu time 0.00 seconds
18
19 data nyu ;
20 set ahn_final834 ;
21
22 if PEPMNK1R = 888 then PEPMNK1R=. ;
23 if PM10StEYM20MeanW ne . and PEPMNK1R ne .
24 then eligible = 1 ; else eligible = 0 ; * SUBSET ELIGIBLE ;
25
26 if HSSEX=2 then HSSEX=0; * 0=F, 1=M ;
27
28
29 if TGP = 8888 or TGP>1450 then TGP=. ;
30 if TCP = 888 or TCP>600 then TCP=. ; * remove extreme values ;
31
32 if BMPBMI = 8888 then BMPBMI=. ;
33 if 0<BMPBMI<18.5 then bmi=1 ;
34 if BMPBMI>=18.5 and BMPBMI<25 then bmi=4 ;
35 if BMPBMI>=25 and BMPBMI<30 then bmi=2 ;
36 if BMPBMI>=30 then bmi=3 ;
37 if BMPBMI=. or BMPBMI=0 then bmi=0 ;
38
39 if HAR1=2 then smoke=3 ;
40 if HAR1=1 and HAR3=2 then smoke=2 ;
41 if HAR1=1 and HAR3=1 then smoke=1 ;
42 if HAR1=. or HAR1=8 or HAR3=8 then smoke=3 ;
43
44
45 if DMARACER=1 then race=2 ;
46 if DMARACER=2 then race=1 ;
47 if DMARACER in (3,8) then race=0 ;
48
49
50 pm_iqr = PM10StEYM20MeanW / 10.8486 ; * PM10 per IQR ;
51
52 log_TG = log(TGP);
53
54 if rs9939609 = 44 then rs9939609_new = "TT";
55 if rs9939609 = 14 then rs9939609_new = "AT";
56 if rs9939609 = 11 then rs9939609_new = "AA";
57
58
59 if rs515135 = "GG" then snp1 = "wt" ;
60 if rs515135 in ("AG", "AA") then snp1 = "var" ;
61
62 if rs3751812 = "GG" then snp2 = "wt" ;
63 if rs3751812 in ("GT", "TT") then snp2 = "var" ;
64
65 if rs1454626 = "AA" then snp3 = "wt" ;
66 if rs1454626 in ("AC", "CC") then snp3 = "var" ;
67
68 if rs6919346 = "GG" then snp4 = "wt" ;
69 if rs6919346 in ("AG", "AA") then snp4 = "var" ;
70
71 if rs7903146 = 22 then snp5 = "wt" ;
72 if rs7903146 in (24, 44) then snp5 = "var" ;
73
74 if rs9939609_new = "TT" then snp6 = "wt" ;
75 if rs9939609_new in ("AA", "AT") then snp6 = "var" ;
76
77 if rs17366743 = "TT" then snp7 = "wt" ;
78 if rs17366743 in ("CT", "CC") then snp7 = "var" ;
79
80 if rs17782313_A = "TT" then snp8 = "wt" ;
81 if rs17782313_A in ("CT", "CC") then snp8 = "var" ;
82 run;
NOTE: Character values have been converted to numeric values at the places given by: (Line):(Column).
54:5 55:5 56:5
NOTE: Invalid numeric data, rs9939609='TT' , at line 54 column 5.
NOTE: Invalid numeric data, rs9939609='TT' , at line 55 column 5.
NOTE: Invalid numeric data, rs9939609='TT' , at line 56 column 5.
NOTE: Invalid numeric data, rs9939609='TT' , at line 54 column 5.
NOTE: Invalid numeric data, rs9939609='TT' , at line 55 column 5.
NOTE: Invalid numeric data, rs9939609='TT' , at line 56 column 5.
_N_=10122
NOTE: Invalid numeric data, rs9939609='AT' , at line 54 column 5.
NOTE: Invalid numeric data, rs9939609='AT' , at line 55 column 5.
NOTE: Invalid numeric data, rs9939609='AT' , at line 56 column 5.
NOTE: Invalid numeric data, rs9939609='TT' , at line 54 column 5.
NOTE: Invalid numeric data, rs9939609='TT' , at line 55 column 5.
NOTE: Invalid numeric data, rs9939609='TT' , at line 56 column 5.
NOTE: Invalid numeric data, rs9939609='AT' , at line 54 column 5.
NOTE: Invalid numeric data, rs9939609='AT' , at line 55 column 5.
NOTE: Invalid numeric data, rs9939609='AT' , at line 56 column 5.
NOTE: Invalid numeric data, rs9939609='AT' , at line 54 column 5.
NOTE: Invalid numeric data, rs9939609='AT' , at line 55 column 5.
NOTE: Invalid numeric data, rs9939609='AT' , at line 56 column 5.
NOTE: Invalid numeric data, rs9939609='TT' , at line 54 column 5.
NOTE: Invalid numeric data, rs9939609='TT' , at line 55 column 5.
NOTE: Invalid numeric data, rs9939609='TT' , at line 56 column 5.
NOTE: Invalid numeric data, rs9939609='TT' , at line 54 column 5.
NOTE: Invalid numeric data, rs9939609='TT' , at line 55 column 5.
NOTE: Invalid numeric data, rs9939609='TT' , at line 56 column 5.
NOTE: Invalid numeric data, rs9939609='TT' , at line 54 column 5.
NOTE: Invalid numeric data, rs9939609='TT' , at line 55 column 5.
NOTE: Invalid numeric data, rs9939609='TT' , at line 56 column 5.
NOTE: Invalid numeric data, rs9939609='TT' , at line 54 column 5.
NOTE: Invalid numeric data, rs9939609='TT' , at line 55 column 5.
NOTE: Invalid numeric data, rs9939609='TT' , at line 56 column 5.
NOTE: Invalid numeric data, rs9939609='AT' , at line 54 column 5.
NOTE: Invalid numeric data, rs9939609='AT' , at line 55 column 5.
NOTE: Invalid numeric data, rs9939609='AT' , at line 56 column 5.
NOTE: Invalid numeric data, rs9939609='AT' , at line 54 column 5.
NOTE: Invalid numeric data, rs9939609='AT' , at line 55 column 5.
NOTE: Invalid numeric data, rs9939609='AT' , at line 56 column 5.
NOTE: Invalid numeric data, rs9939609='TT' , at line 54 column 5.
NOTE: Invalid numeric data, rs9939609='TT' , at line 55 column 5.
NOTE: Invalid numeric data, rs9939609='TT' , at line 56 column 5.
NOTE: Invalid numeric data, rs9939609='TT' , at line 54 column 5.
NOTE: Invalid numeric data, rs9939609='TT' , at line 55 column 5.
NOTE: Invalid numeric data, rs9939609='TT' , at line 56 column 5.
NOTE: Invalid numeric data, rs9939609='AT' , at line 54 column 5.
NOTE: Invalid numeric data, rs9939609='AT' , at line 55 column 5.
NOTE: Invalid numeric data, rs9939609='AT' , at line 56 column 5.
NOTE: Invalid numeric data, rs9939609='TT' , at line 54 column 5.
NOTE: Invalid numeric data, rs9939609='TT' , at line 55 column 5.
NOTE: Invalid numeric data, rs9939609='TT' , at line 56 column 5.
NOTE: Invalid numeric data, rs9939609='TT' , at line 54 column 5.
NOTE: Invalid numeric data, rs9939609='TT' , at line 55 column 5.
NOTE: Invalid numeric data, rs9939609='TT' , at line 56 column 5.
NOTE: Invalid numeric data, rs9939609='TT' , at line 54 column 5.
NOTE: Invalid numeric data, rs9939609='TT' , at line 55 column 5.
NOTE: Invalid numeric data, rs9939609='TT' , at line 56 column 5.
NOTE: Invalid numeric data, rs9939609='TT' , at line 54 column 5.
NOTE: Invalid numeric data, rs9939609='TT' , at line 55 column 5.
NOTE: Invalid numeric data, rs9939609='TT' , at line 56 column 5.
NOTE: Invalid numeric data, rs9939609='AT' , at line 54 column 5.
NOTE: Invalid numeric data, rs9939609='AT' , at line 55 column 5.
NOTE: Invalid numeric data, rs9939609='AT' , at line 56 column 5.
NOTE: Missing values were generated as a result of performing an operation on missing values.
Each place is given by: (Number of times) at (Line):(Column).
7151 at 50:28 2987 at 52:11
NOTE: There were 20050 observations read from the data set WORK.AHN_FINAL834.
NOTE: The data set WORK.NYU has 20050 observations and 458 variables.
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.
NOTE: DATA statement used (Total process time):
real time 0.17 seconds
cpu time 0.18 seconds
83 proc surveyreg data=nyu;
84 class HSSEX race bmi smoke DMPCREGN;
85 model log_TG = pm_iqr HSAGEIR HSSEX race bmi smoke DMPCREGN / CLPARM SOLUTION;
86 domain eligible*snp1;
87 run;
NOTE: In data set NYU, total 20050 observations read, 15118 observations with missing values are omitted.
NOTE: The PROCEDURE SURVEYREG printed pages 1-5.
NOTE: PROCEDURE SURVEYREG used (Total process time):
real time 1.03 seconds
cpu time 1.03 seconds
88 proc surveyreg data=nyu;
89 class HSSEX race bmi smoke DMPCREGN;
90 model log_TG = pm_iqr HSAGEIR HSSEX race bmi smoke DMPCREGN / CLPARM SOLUTION;
91 domain eligible*snp2;
92 run;
NOTE: In data set NYU, total 20050 observations read, 15429 observations with missing values are omitted.
NOTE: The PROCEDURE SURVEYREG printed pages 6-10.
NOTE: PROCEDURE SURVEYREG used (Total process time):
real time 0.92 seconds
cpu time 0.92 seconds
93 proc surveyreg data=nyu;
94 class HSSEX race bmi smoke DMPCREGN;
95 model log_TG = pm_iqr HSAGEIR HSSEX race bmi smoke DMPCREGN / CLPARM SOLUTION;
96 domain eligible*snp3;
97 run;
NOTE: In data set NYU, total 20050 observations read, 15205 observations with missing values are omitted.
NOTE: The PROCEDURE SURVEYREG printed pages 11-15.
NOTE: PROCEDURE SURVEYREG used (Total process time):
real time 0.92 seconds
cpu time 0.92 seconds
98 proc surveyreg data=nyu;
99 class HSSEX race bmi smoke DMPCREGN;
100 model log_TG = pm_iqr HSAGEIR HSSEX race bmi smoke DMPCREGN / CLPARM SOLUTION;
101 domain eligible*snp4;
102 run;
NOTE: In data set NYU, total 20050 observations read, 15204 observations with missing values are omitted.
NOTE: The PROCEDURE SURVEYREG printed pages 16-20.
NOTE: PROCEDURE SURVEYREG used (Total process time):
real time 0.92 seconds
cpu time 0.92 seconds
103 proc surveyreg data=nyu;
104 class HSSEX race bmi smoke DMPCREGN;
105 model log_TG = pm_iqr HSAGEIR HSSEX race bmi smoke DMPCREGN / CLPARM SOLUTION;
106 domain eligible*snp5;
107 run;
NOTE: In data set NYU, total 20050 observations read, 15097 observations with missing values are omitted.
NOTE: The PROCEDURE SURVEYREG printed pages 21-25.
NOTE: PROCEDURE SURVEYREG used (Total process time):
real time 0.95 seconds
cpu time 0.96 seconds
108 proc surveyreg data=nyu;
109 class HSSEX race bmi smoke DMPCREGN;
110 model log_TG = pm_iqr HSAGEIR HSSEX race bmi smoke DMPCREGN / CLPARM SOLUTION;
111 domain eligible*snp6;
112 run;
NOTE: In data set NYU, total 20050 observations read, 19973 observations with missing values are omitted.
NOTE: All observations were omitted due to missing values or non-positive weights in domain eligible=0 snp6=va.
NOTE: All observations were omitted due to missing values or non-positive weights in domain eligible=0 snp6=wt.
NOTE: The PROCEDURE SURVEYREG printed pages 26-28.
NOTE: PROCEDURE SURVEYREG used (Total process time):
real time 0.69 seconds
cpu time 0.70 seconds
113 proc surveyreg data=nyu;
114 class HSSEX race bmi smoke DMPCREGN;
115 model log_TG = pm_iqr HSAGEIR HSSEX race bmi smoke DMPCREGN / CLPARM SOLUTION;
116 domain eligible*snp7;
117 run;
NOTE: In data set NYU, total 20050 observations read, 15161 observations with missing values are omitted.
NOTE: The PROCEDURE SURVEYREG printed pages 29-33.
NOTE: PROCEDURE SURVEYREG used (Total process time):
real time 0.91 seconds
cpu time 0.92 seconds
118 proc surveyreg data=nyu;
119 class HSSEX race bmi smoke DMPCREGN;
120 model log_TG = pm_iqr HSAGEIR HSSEX race bmi smoke DMPCREGN / CLPARM SOLUTION;
121 domain eligible*snp8;
122 run;
NOTE: In data set NYU, total 20050 observations read, 15118 observations with missing values are omitted.
NOTE: The PROCEDURE SURVEYREG printed pages 34-38.
NOTE: PROCEDURE SURVEYREG used (Total process time):
real time 0.91 seconds
cpu time 0.92 seconds
123 proc surveyreg data=nyu;
124 class bmi HSSEX race smoke DMPCREGN snp1;
125 model log_TG = pm_iqr HSAGEIR HSSEX bmi race smoke DMPCREGN snp1 pm_iqr*snp1 / CLPARM SOLUTION;
126 domain eligible;
127 run;
NOTE: In data set NYU, total 20050 observations read, 15118 observations with missing values are omitted.
NOTE: The PROCEDURE SURVEYREG printed pages 39-41.
NOTE: PROCEDURE SURVEYREG used (Total process time):
real time 0.75 seconds
cpu time 0.74 seconds
128 proc surveyreg data=nyu;
129 class bmi HSSEX race smoke DMPCREGN snp2;
130 model log_TG = pm_iqr HSAGEIR HSSEX bmi race smoke DMPCREGN snp2 pm_iqr*snp2 / CLPARM SOLUTION;
131 domain eligible;
132 run;
NOTE: In data set NYU, total 20050 observations read, 15429 observations with missing values are omitted.
NOTE: The PROCEDURE SURVEYREG printed pages 42-44.
NOTE: PROCEDURE SURVEYREG used (Total process time):
real time 0.81 seconds
cpu time 0.82 seconds
133 proc surveyreg data=nyu;
134 class bmi HSSEX race smoke DMPCREGN snp3 ;
135 model log_TG = pm_iqr HSAGEIR HSSEX bmi race smoke DMPCREGN snp3 pm_iqr*snp3 / CLPARM SOLUTION;
136 domain eligible;
137 run;
NOTE: In data set NYU, total 20050 observations read, 15205 observations with missing values are omitted.
NOTE: The PROCEDURE SURVEYREG printed pages 45-47.
NOTE: PROCEDURE SURVEYREG used (Total process time):
real time 0.74 seconds
cpu time 0.73 seconds
138 proc surveyreg data=nyu;
139 class bmi HSSEX race smoke DMPCREGN snp4;
140 model log_TG = pm_iqr HSAGEIR HSSEX bmi race smoke DMPCREGN snp4 pm_iqr*snp4 / CLPARM SOLUTION;
141 domain eligible;
142 run;
NOTE: In data set NYU, total 20050 observations read, 15204 observations with missing values are omitted.
NOTE: The PROCEDURE SURVEYREG printed pages 48-50.
NOTE: PROCEDURE SURVEYREG used (Total process time):
real time 0.80 seconds
cpu time 0.79 seconds
143 proc surveyreg data=nyu;
144 class bmi HSSEX race smoke DMPCREGN snp5;
145 model log_TG = pm_iqr HSAGEIR HSSEX bmi race smoke DMPCREGN snp5 pm_iqr*snp5 / CLPARM SOLUTION;
146 domain eligible;
147 run;
NOTE: In data set NYU, total 20050 observations read, 15097 observations with missing values are omitted.
NOTE: The PROCEDURE SURVEYREG printed pages 51-53.
NOTE: PROCEDURE SURVEYREG used (Total process time):
real time 0.73 seconds
cpu time 0.74 seconds
148 proc surveyreg data=nyu;
149 class bmi HSSEX race smoke DMPCREGN snp6;
150 model log_TG = pm_iqr HSAGEIR HSSEX bmi race smoke DMPCREGN snp6 pm_iqr*snp6 / CLPARM SOLUTION;
151 domain eligible;
152 run;
NOTE: In data set NYU, total 20050 observations read, 19973 observations with missing values are omitted.
NOTE: All observations were omitted due to missing values or non-positive weights in domain eligible=0.
NOTE: The PROCEDURE SURVEYREG printed pages 54-55.
NOTE: PROCEDURE SURVEYREG used (Total process time):
real time 0.57 seconds
cpu time 0.56 seconds
153 proc surveyreg data=nyu;
154 class bmi HSSEX race smoke DMPCREGN snp7;
155 model log_TG = pm_iqr HSAGEIR HSSEX bmi race smoke DMPCREGN snp7 pm_iqr*snp7 / CLPARM SOLUTION;
156 domain eligible;
157 run;
NOTE: In data set NYU, total 20050 observations read, 15161 observations with missing values are omitted.
NOTE: The PROCEDURE SURVEYREG printed pages 56-58.
NOTE: PROCEDURE SURVEYREG used (Total process time):
real time 0.73 seconds
cpu time 0.73 seconds
158 proc surveyreg data=nyu;
159 class bmi HSSEX race smoke DMPCREGN snp8 ;
160 model log_TG = pm_iqr HSAGEIR HSSEX bmi race smoke DMPCREGN snp8 pm_iqr*snp8 / CLPARM SOLUTION;
161 domain eligible;
162 run;
NOTE: In data set NYU, total 20050 observations read, 15118 observations with missing values are omitted.
NOTE: The PROCEDURE SURVEYREG printed pages 59-61.
NOTE: PROCEDURE SURVEYREG used (Total process time):
real time 0.74 seconds
cpu time 0.74 seconds
163
164
165
166
NOTE: SAS Institute Inc., SAS Campus Drive, Cary, NC USA 27513-2414
NOTE: The SAS System used:
real time 15.65 seconds
cpu time 13.66 seconds
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.
Sorry I'm a newbie to SAS. Can you tell me what you are referring to when you say "notes"?
The item in the log starting with "NOTE:"
which are not errors but generally let you know you may be doing something a tad off from intended.
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.
When you use this syntax:
if rs9939609 = 44
SAS will attempt to convert the variable rs9939609 to numeric since you have asked it to be compared to a number, not a character.
The note is saying it can't conver 'TT' to a valid numeric.
The comparison should be
if rs9939609 = '44'
and similar so you compare character value to a character if you don't want the notes.
Hello Gita,
You can reproduce the error message if you attempt to assign a text value to a numeric variable:
data _null_;
length
rs9939609 8;
rs9939609 = 'TT';
if rs9939609 = 44 then rs9939609_new = 'TT';
run;
Is variable "rs9939609" in data set "ahn_final834" character or numeric?
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."
and "rs9939609" is a character variable.
Okay. Automatic numeric-character conversion is described here:
SAS Variables in Expressions :: SAS(R) 9.4 Language Reference: Concepts, Second Edition
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.