How to connect and read a SAS dataset in Datastage
Posted: Mon May 13, 2019 1:15 am
Hi,
So far we were downloading SAS datasets manually and using them as input in Datastage jobs. Going forward we have to connect to SAS server and pull data from Datasets directly. There is very limited information available on this online. Can you of you provide your thoughts on this?
I have my server name (let's say ABCD01), port (1234), User ID and Password. I see all the Libraries which have the Datasets. So considering I have Server Name, Port, User ID, Passsword, Library(Lets say 'Maps') and Dataset Names(Lets say 'Country'), how do I call this dataset in Datastage?
Thanks in advance. Any help is appreciated.
So far we were downloading SAS datasets manually and using them as input in Datastage jobs. Going forward we have to connect to SAS server and pull data from Datasets directly. There is very limited information available on this online. Can you of you provide your thoughts on this?
I have my server name (let's say ABCD01), port (1234), User ID and Password. I see all the Libraries which have the Datasets. So considering I have Server Name, Port, User ID, Passsword, Library(Lets say 'Maps') and Dataset Names(Lets say 'Country'), how do I call this dataset in Datastage?
Thanks in advance. Any help is appreciated.