How to convert char to numeric

Monimo — Sat, 09 Feb 2019 09:42:29 GMT

Given dataset : all char value, I need do convert this char value into numeric value using LIkert scale:

Corrisponde esattamente =5 
Corrisponde molto =4 
Corrisponde moderatamente=3          
Corrisponde poco= 2 
Non corrisponde =1

Oss mot_01 mot_02 mot_03

used proc format

proc format;

value $mot
'Corrisponde molto' = 4
'Corrisponde moderatamente'= 3
"Corrisponde esattamente"= 5
"Non corrisponde per nulla"= 1
"Corrisponde poco"= 2 ;

run;

Now how can I change the type from char to numeric?

Re: How to convert char to numeric

Kurt_Bremser — Sat, 09 Feb 2019 09:59:35 GMT

To convert character to numeric, you need the input() function and therefore an informat.

Define your informat with the invalue statement, and make it numeric (no $).

Monimo — Sat, 09 Feb 2019 10:47:25 GMT

It worked, thank you.