Hi I am trying to convert character value to numeric used. this codes
data datachek.mil_lab_2017_A;
set datachek.MIL_LAB_2017;
AZIMICDD = INPUT(AZI_MIC_DD, BEST8.);
DROP AZI_MIC_DD;
RENAME AZIMICDD=AZI_MIC_DD;
RUN;
log did not show any error
51 data datachek.mil_lab_2017_A;
52 set datachek.MIL_LAB_2017;
56 AZIMICDD = INPUT(AZI_MIC_DD, BEST8.);
57 DROP AZI_MIC_DD;
58 RENAME AZIMICDD=AZI_MIC_DD;
59 RUN;
NOTE: There were 2406 observations read from the data set DATACHEK.MIL_LAB_2017.
NOTE: The data set DATACHEK.MIL_LAB_2017_A has 2406 observations and 30 variables.
NOTE: DATA statement used (Total process time):
real time 0.12 seconds
cpu time 0.03 seconds
but the converted data has . value no numbers. Can some tell me why and how can i fix this. Also can I convert from character to numeric and change the length of the variable at once?
I would be so grateful of your help?
I have several variables value that need to be converted from character to numeric, how can i do it once?
Could you please check if there is any missing character data. Because the missing character data when converted to numeric take dot value. it is representation of missing numeric data in SAS.
Could you please check if there is any missing character data. Because the missing character data when converted to numeric take dot value. it is representation of missing numeric data in SAS.
April 27 – 30 | Gaylord Texan | Grapevine, Texas
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.