Hi, guys! I got a problem, find the reason, but do not know how to fix it. Here it is: The sas data is read by using IMPORT procedure. Here is the data look like: Notice that the last variable GPRS_FLUX is character. So I want to convert it to numeric. I use these code:
data work.test;
set data.sas_info_20140512173730(rename=(gprs_flux=tp_0));
gprs_flux=input(tp_0,best12.);
drop tp_:;
run;
Unfortunately, the log told me that the convertion is failed!!! Here is the Log: It said the argument of the INPUT function is invalid at row 20, col 12. I really cannot find which is invalid. It tortured me half an hour. Finally I export the data to TXT file, I realize the problem. Here is the exported text file: It got a quotation marks! How does this happen???? Why I can't see it in EG???? So the problem is caused by the quotation marks, so how to convert it to numeric? Note: the data is in the remote SAS server, so don't tell me to read the data again. Because there are lots of data is automatically read, and the data's column is not same at each time, so must use the IMPORT procedure.
... View more
