```Date: Sat, 11 Oct 2003 22:29:43 -0400 Reply-To: Howard Schreier Sender: "SAS(r) Discussion" From: Howard Schreier Subject: Re: Fetch Hexadecimal digits from Character and Convert them to Number Notice that the informat used is HEX, not \$HEX (as speculated by MK). That's because the hex string represents a number. No format is involved. Also, there is just one conversion, not two. Sometimes it helps to remember that hex is nothing more than a compact representation for binary values; anybody who remembers "core dumps" hundreds of pages thick should appreciate that. Hex has no other significance in computer architecture. On Fri, 10 Oct 2003 10:40:22 -0700, shiling zhang wrote: >You are there. Here is the example in your case. > >If the variable values have variable length and last 4 digit is always >as you said, then you can reverse(reverse fuction in SAS) it and take >the first 4 digits and reverse it back. > >num=input(substr(xyz,10,4), hex4.); > >myquery5@yahoo.com (MK) wrote in message news:<266ac6c.0310100544.416afcb1@posting.google.com>... >> Hello, >> >> I have a dataset where a column(say First_Cell) has values like - >> 40497000A041D >> 40497001E14E9 >> 40497003C2399 etc.. >> >> These values are stored as CHARACTER type. The last 4 characters of >> the above string identify HEXADECIMAL number. >> I need to convert these last 4 characters to number. >> >> I think the path I need to follow is - >> 1)Fetch last 4 characters from the string >> 2) Convert them to HEXADECIMAL value >> 3)Convert the HEXADECIMAL to Number type. >> >> Is this approach right? If yes then should I use \$HEXw. FORMAT & >> INFORMATS? How do I go about achieving this? >> >> Is there any other simpler and/or faster approach? >> >> Pls. help. >> >> Thanks >> M.K. ```

Back to: Top of message | Previous page | Main SAS-L page