Hello experts! I am unsure as to the reason why there is a note of invalid numeric, (shown below) NOTE: Invalid numeric data, temp='20.2' , at line 1306 column 8.
NOTE: Invalid numeric data, hum='47.3' , at line 1307 column 7.
NOTE: Invalid numeric data, pressure='1002.3' , at line 1308 column but the value temp= '20.2' is the one I want to be outputted. This is a sample of what I have. informat no best32.
date ddmmyy10.
time time20.3
negmin best32.
negavg best32.
negmax best32.
posmin best32.
posavg best32.
posmax best32.
state best32.
temp $6.
tempunit $2.
hum $6.
pressure $8. ;
format no best12.
date ddmmyy10.
time time20.3
negmin best12.
negavg best12.
negmax best12.
posmin best12.
posavg best12.
posmax best12.
state best12.
temp $6.
tempunit $2.
hum $6.
pressure $8. ;
input
no
date
time
negmin
negavg
negmax
posmin
posavg
posmax
state
temp
tempunit
hum
pressure
;
if _ERROR_ then call symputx('_EFIERR_',1); /* set ERROR detection macro variable */
run;
data work.class1;
set work.class;
tempc= temp/10 ;
hump= hum/10 ;
press= pressure/10 ;
drop tempunit temp hum pressure;
datetime = dhms(date,0,0,0)+time;
format datetime datetime15.;
run; How do I get the correct output?
... View more