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
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.
Here's an example that might help:
Using SAS to convert IP addresses into numerical IP values
Chris
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.