I am trying to convert a character variable to numeric
I have a column of data with the following attributes:
Data Set Name: woleaim1
Variable: age
Type: Char
Len: 3
Format: $3.
Informat: $3.
These data are formatted as character and I want to convert it to numeric. I tried the following command
data woleaim1;
age_num = input(age, $3.);
run;
This is the error message below:
NOTE: Numeric values have been converted to character values at the places given by: (Line):(Column).
588:23
NOTE: Variable age is uninitialized.
NOTE: The data set WORK.WOLEAIM1 has 1 observations and 2 variables.
Thanks!
data have;
input age $;
cards;
12
15
43
;
data want;
set have ;
newage=input(age,8.);
run;
data have;
input age $;
cards;
12
15
43
;
data want;
set have ;
newage=input(age,8.);
run;
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 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.