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

SAS LASR Analytic Server Loader drops SQL

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 12
Accepted Solution

SAS LASR Analytic Server Loader drops SQL

Hello, I have a SAS DIS job that runs a JOIN and EXTRACT and writes to a new SAS Database table. I need to upload this data table to SAS VA. Using SAS LASR Analytic Server Loader the job completes without errors, but the SAS VA table is incorrect. A WHERE statement that I programmed in the EXTRACT step is being dropped or not being processed and the SAS VA table does not match the SAS Database table. 


Accepted Solutions
Solution
‎03-02-2018 01:45 PM
Occasional Contributor
Posts: 12

Re: SAS LASR Analytic Server Loader drops SQL

I fixed this issue by using the WHERE tab under properties in the Extract function. I was modifying the code directly.

View solution in original post


All Replies
Solution
‎03-02-2018 01:45 PM
Occasional Contributor
Posts: 12

Re: SAS LASR Analytic Server Loader drops SQL

I fixed this issue by using the WHERE tab under properties in the Extract function. I was modifying the code directly.

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 187 views
  • 0 likes
  • 1 in conversation