SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

SAS code in DataFlux

Reply
Occasional Contributor
Posts: 17

SAS code in DataFlux

[ Edited ]

Hello,

 

I have access to SAS table in Data Connections (SAS technical support suggest an ODBC connection and the IT team performs it), how can I access to that data using a SAS Code object (in Process Job>>Data Integration)? Have I to set up special setting in the Settings/Inputs tab?

 

Thank you for your time!

 

 

SAS Super FREQ
Posts: 97

Re: SAS code in DataFlux

It may seem counterintuitive but there are two different data access methods going on here. When you use Data Connections, you are using a Data Management Studio managed data source and by doing so this data will show up in many places like when you build a data job or perform data profiling.

 

In a process job, when you use the SAS code node, you are actually communicating with a SAS workspace server. It won't have knowledge of the connection to SAS you established in Data Management Studio. If you want to access the same SAS table from the SAS code node, it would have to be available to your workspace server through normal means you would use to set up a connection to a data library in SAS.

 

But you don't need to use the SAS code node to work with the data in Data Management Studio. Once you connect to it, you can use any number of the other data quality and data integration nodes to transform the data.

 

Ron

 

Ron

Occasional Contributor
Posts: 17

Re: SAS code in DataFlux

Posted in reply to RonAgresta

Thank you Ron.

 

I would like to use SAS code because I would like to use the SAS programming language. I am learning the EEL, but it could be easier and faster, for the moment, if I could write "in" SAS.

 

Anyway, I am going to try.

 

Thanks again,

Margherita

Occasional Contributor
Posts: 17

Re: SAS code in DataFlux

Posted in reply to RonAgresta

Hi Ron,

 

I get the SAS connection for the SAS code node. I am able to connect to the workspace and to retrive data, but...I am not able to use these data.

 

I tried just a proc sql (I know I can use the sql node, but it was just to try), if I put "create table as..." then I cannot see the output (where does DataFlux put the worktable?), if I do not put anything, the output is weird, it is in lines.

 

Eg:

If the table in the DB is

AAA    BBB
1         smith
2         paul
3         boss

 

then the output is

AAA
BBB

-------------

1
smith

 

2
paul

 

3
boss

 

Thank you for your time!

 

Ask a Question
Discussion stats
  • 3 replies
  • 363 views
  • 0 likes
  • 2 in conversation