SAS code in DataFlux

[margautz]

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!

[RonAgresta]

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

[margautz]

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

[margautz]

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!