Hello,
I am new with DataFlux and I am trying to play a little bit to understand better the tool.
I have a csv file, I import it and I create a "work table" as an output. Is it possible to use this work tabel as an input for an sql statement and filter it with "where clauses"?
Thank you for your time!
Hi,
As you have probably already figured out, work tables are used for temporary storage of data so that it can be accessed in other parts of your data job or process job. It can't be used as input for a SQL statement - at least not directly. It would be possible to read values out of a work table and store the values in macro variables that could be used as parameters to an SQL statement in other steps in your job.
If your goal is to read data into your job from a csv file to then subset it in some way, you could read it in directly, skip the work table step, and use the expression node to select/filter the rows that you are interested in.
Ron
Hi,
As you have probably already figured out, work tables are used for temporary storage of data so that it can be accessed in other parts of your data job or process job. It can't be used as input for a SQL statement - at least not directly. It would be possible to read values out of a work table and store the values in macro variables that could be used as parameters to an SQL statement in other steps in your job.
If your goal is to read data into your job from a csv file to then subset it in some way, you could read it in directly, skip the work table step, and use the expression node to select/filter the rows that you are interested in.
Ron
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.
Find more tutorials on the SAS Users YouTube channel.