converting a character data with colon to numeric data

desireatem — Wed, 09 Jan 2019 22:25:50 GMT

Hello-,

I have this data where the observations are in character with colon in the names:

hc_education Associate's degree
hc_education Associate's degree
Bachelor's degree
Graduate degree
High school diploma/GED
I attended 12th grade but did not receive a diploma
I completed 10th grade (11 years of school)
I completed 11th grade (12 years of school)
I completed 6th grade (7 years of school)
I completed 9th grade (10 years of school)
I completed high school and graduated or received a GED (13 years of school)
I completed less than 6th grade (less than 7 years of school)
I completed some college or received an associate's degree
I received a bachelor's degree (4 years of college)
I received a graduate degree or studied beyond a bachelor's degree
Less than high school
Some college
Frequency Missing = 9

Some of the observations such as : Associate's degree , Bachelor's degree etc have colon (') before s. Once I apply this code to change this to number:

data first1;
set BMII;
if hc_education in ('I attended 12th grade but did not receive a diploma','I completed 10th grade (11 years of school)',
'I completed 11th grade (12 years of school)','I completed 6th grade (7 years of school)','I completed 9th grade (10 years of school)',
'I completed less than 6th grade (less than 7 years of school)','Less than high school') then edu=1; else if hc_education in
('I completed high school and graduated or received a GED (13 years of school)','High school diploma/GED', 'Some college')then edu=2;
else if hc_education in ('I received a graduate degree or studied beyond a bachelor's degree','Associate's degree','Bachelor's degree','Graduate degree'')
then edu=3;

run;

I got error:

104 else if hc_education in ('I received a graduate degree or studied beyond a bachelor's
-----------------------------------------------------------
---
----------
---
49 49
49
49
-
22
-
76
104! degree','Associate's degree','Bachelor's degree','Graduate degree'')
NOTE 49-169: The meaning of an identifier after a quoted string might change in a future SAS
release. Inserting white space between a quoted string and the succeeding identifier
is recommended.

ERROR 22-322: Syntax error, expecting one of the following: a quoted string, a numeric constant,
a datetime constant, a missing value, iterator, (, ), ','.

ERROR 76-322: Syntax error, statement will be ignored.

105 then edu=3;

Please How do I fix this in the code. I cannot change in the Data set.

Re: converting a character data with colon to numeric data

novinosrin — Wed, 09 Jan 2019 22:30:19 GMT

Have you tried wrapping with double quotes?

if hc_education in ("I received a graduate degree or studied beyond a bachelor's degree","Associate's degree","Bachelor's degree","Graduate degree'')

If the value has embedded single quote, wrap it with double quotes and vice versa

Re: converting a character data with colon to numeric data

Reeza — Wed, 09 Jan 2019 22:30:22 GMT

You should try using a format instead. It makes things like this much easier to work with.

topic Re: converting a character data with colon to numeric data in SAS Programming

converting a character data with colon to numeric data

Re: converting a character data with colon to numeric data

Re: converting a character data with colon to numeric data