topic Re: Method to get IP from Domain or Domain from IP in SAS? in SAS Programming

Method to get IP from Domain or Domain from IP in SAS?

prolifious — Thu, 20 Sep 2018 19:52:59 GMT

I have a CSV that includes a single column of all IP addresses. I'd like to build another column by determining a domain name from the IPs and filling that new column, with the determined domain name.

I can do this no problem in powershell or a python program, but I can't see to figure out if it's possible with SAS, where i need to do my work.

Is this possible with SAS? I've seen proc http, but i couldn't find any indication that it's possible there.

anything info on here will help, I seem to have hit a wall with this.

thanks

Re: Method to get IP from Domain or Domain from IP in SAS?

ChrisNZ — Fri, 21 Sep 2018 00:11:16 GMT

How do you do it in python? You need to query a DNS somehow don't you?

Re: Method to get IP from Domain or Domain from IP in SAS?

prolifious — Thu, 18 Oct 2018 19:50:42 GMT

this is a python method for getting a domain from an ip:

import socket

try:
a = '52.216.64.218'
b = socket.gethostbyaddr(a)
print(b)
except socket.error:
b = 'No Host Found'
print(b)

it's easy to do it in reverse as well.

So, any update on this? is it possible through PROC HHTP somehow? speaking of which, is there any good documentaiton/whitepapers on PROC HTTP? i could only find limited resources on it.

thanks

Re: Method to get IP from Domain or Domain from IP in SAS?

ChrisHemedinger — Thu, 18 Oct 2018 20:34:37 GMT

PROC HTTP documentation is here. I also have a series of blog articles about various use cases for PROC HTTP.

gethostbyaddr and gethostbyname are functions that are built into the operating system. getnameinfo is actually the preferred method to use now. Some programming languages expose these as functions in their own syntax, but I haven't found where SAS does that.

I think it would be possible to call this using CALL MODULE if you know the external library (DLL) to reference. It's a little tricky to set up, and I don't have a working example handy. It would be different between Linux and Windows.