topic How to convert hexadecimal to character? in SAS Procedures

How to convert hexadecimal to character?

Mike_Davis — Fri, 10 Aug 2012 19:23:12 GMT

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;

;

run;

Re: How to convert hexadecimal to character?

Mike_Davis — Fri, 10 Aug 2012 19:47:19 GMT

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;

Re: How to convert hexadecimal to character?

MikeZdeb — Fri, 10 Aug 2012 19:53:47 GMT

hi ...

data have;

input hex $;

cards;

;

data want;

set have;

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

run;

hex new

4D M

4F O

76 v

28 (

6B k

Re: How to convert hexadecimal to character?

Mike_Davis — Fri, 10 Aug 2012 19:58:59 GMT

Thanks a lot Mike