How to convert hexadecimal to character?

[Mike_Davis]

Hello everyone,

I have a data set  has a hexadecimal variable,I want to convert it  into character,please advise.(for example 6B should convert to k)

for your reference,the following website list the ralationship of hex and character.

http://www.asciitable.com/

Thanks

Mike.

data have;

input hex $;

cards;

4D

4F

76

20

28

6B

;

run;

[Mike_Davis]

here is my ugly method:

please advise

I hope there is a function could be use directly.

Thanks

data table;
      do ascii=0 to 255;
            char=byte(ascii);
            put ascii= char=;
            hex=put(char,$HEX.);
   output;
      end;
run;
data have;
input hex $;
cards;
4D
4F
76
23
20
28
24
47
6B
52
;
run;

proc sql noprint;
create table want as
select a.*,b.char
from have as a
left join table as b
on a.hex=b.hex
;
quit;

[MikeZdeb · Accepted solution]

hi ...

data have;

input hex $;

cards;

4D

4F

76

20

28

6B

;

data want;

set have;

new = byte(input(hex,hex.));

run;

hex    new

4D      M

4F      O

76      v

20

28      (

6B      k

[Mike_Davis]

Thanks a lot Mike