topic Unable to understand the SAS code node working inside a process flow in SAS Data Management

Unable to understand the SAS code node working inside a process flow

ShikhaAgarwal — Fri, 05 Jun 2020 02:18:15 GMT

Hi All,

I am unable to access the worktables which has my data for profiling through SAS code node.

I have added that table through setting of source bidding.

So my data step contains a file reader and work table writer.

i reference this in process flow as i need to execute some SAS codes.

But SAS code sas the work table doesnt exits

I cant see the work table as active tab while filling the source binding details in input.

Where can i see my SAS libraries in dataflux?

Re: Unable to understand the SAS code node working inside a process flow

SASKiwi — Fri, 05 Jun 2020 03:21:26 GMT

In the DataFlux Data Management Studio Data tab, in the Data panel, right click on Data Connections and select New Data Connection - SAS Data Set Connection. This will enable you to set up a DataFlux connection to an existing or new SAS data library. I've found it is good practice to define DataFlux SAS Data Set Connections with the same name that you use in SAS as your LIBREF (libname MyLibRef "MySASLibraryPath").

Re: Unable to understand the SAS code node working inside a process flow

ShikhaAgarwal — Fri, 05 Jun 2020 03:26:00 GMT

Thanks for you reply SASKiwi.
Can you please also share the documentation page regarding this connection setup as i fail to find much information on the setup

Re: Unable to understand the SAS code node working inside a process flow

SASKiwi — Fri, 05 Jun 2020 04:21:22 GMT

@ShikhaAgarwal - As requested Dataflux Doc Link

The same help doc is available inside DataFlux by selecting Help.

Re: Unable to understand the SAS code node working inside a process flow

ShikhaAgarwal — Fri, 05 Jun 2020 05:07:40 GMT

But this link says "You can use the SAS Data Set Connection dialog to connect to a folder that contains one or more SAS data sets"
I dont have sas datasets. Infact i m trying to convert my Azure SQL DB tables into SAS datasets.
How to do that.
I tried using worktables but i cant see my sas codes finding them.
Where can i see work library.
Either i convert all my Azure table into SAS dataset though Libname or dataflux handles .
But neither of the option works.

LIBNAME Azure ODBC DSN=pocsqldbdhs user=CCCCCC pw=XXXX schema=ABC;
ERROR: The ODBC engine cannot be found.
ERROR: Error in the LIBNAME statement.

the value in the DSN is the windows connection to the server on our local machine.

Even the work table writers and readers are working . Reader is reading only one record at a time while i want it to publish the whole table output to SAS code node.
Kindly suggest.

Re: Unable to understand the SAS code node working inside a process flow

ShikhaAgarwal — Fri, 05 Jun 2020 06:39:52 GMT

cant really get how can i make SAS code node read what it receives from previous node.

A simple

PROC print data=source;

run;

Any help on this will be highly appreciated.

We have a client demo next week and I need to resolve this ASAP.

I am quite new to sas.

Re: Unable to understand the SAS code node working inside a process flow

SASKiwi — Fri, 05 Jun 2020 21:39:02 GMT

The LIBNAME error suggests that the SAS product SAS/ACCESS to ODBC is not installed. You can check what SAS products are installed by running this SAS program:

proc product_status;
run;

However in DataFlux you can also set up a direct ODBC data connection as described the documentation link I sent you. This way does not require SAS/ACCESS to ODBC. As long as you have an installed Azure ODBC driver and a DSN defined it should just work.