Convert IP address to text

mikegia5 — Wed, 17 Feb 2016 19:16:49 GMT

Hi,

I'm a long time SAS user (since 1997) but this is my first time using this forum and submitting a request for an enhancement!

I would like to take a 32 bit IPV4 or 128 bit IPV6 binary IP address and convert to text as dotted notation. For example, an IPV4 is stored in binary as 4 bytes as x'0a0b0c01' and the text is up to 15 bytes "010.011.012.001". While I don't have a requirement right now to go the other way, that may be useful as well (i.e., convert a char(15) field from 10.11.12.1 back into a 4 byte binary).

The equivalent functions in unix are inet_ntop (numeric to presentation) and inet_pton (presentation to numeric).

My goal right now is to read in a binary number and display it as dotted notation. I can work out the SAS code to do this myself, but I really think a function or informat/format would be useful. For example:

input @1 ipv4addr pib4.

put @1 ipv4addr $ipv4.;

The length would be implied to be either char15 if IPV4 or char35 if IPV6.

A function would work too - whichever makes sense.

Thank you,

Mike Giaquinto

Principal Engineer

Wells Fargo

Re: Convert IP address to text

PGStats — Wed, 17 Feb 2016 20:22:49 GMT

You can write your own function or function-based format with proc FCMP and then use it just like any SAS function or SAS format in data steps and SQL.

Re: Convert IP address to text

ChrisHemedinger — Thu, 18 Feb 2016 15:30:13 GMT

Here's an example that might help:

Using SAS to convert IP addresses into numerical IP values

Chris

topic Re: Convert IP address to text in SAS Programming

Convert IP address to text

Re: Convert IP address to text

Re: Convert IP address to text