topic Re: Results not displaying as Expected. in SAS Academy for Data Science

Results not displaying as Expected.

Matim — Fri, 19 Feb 2021 20:29:11 GMT

Job Run SuccessfulHello,

I was working on a practice assignment in SAS Data Integration Studio and I have followed all of the instructions to question 05. After executing the job, the results don't appear as expected in the solution. I have attached the pictures below to explain my situation in detail. Question 05 Practice AssignmentOld Orders Selection ConditonRecent Orders Selection ConditonJob Run SuccessfulOld Orders TableRecent Orders Table

Thanks

Re: Results not displaying as Expected.

ballardw — Fri, 19 Feb 2021 21:00:52 GMT

Since your splitter is based on the variable OrderDate it might help to show that column somewhere.

Verify that OrderDate is actually a date value. What is the current format?

Next would be to verify that you have dates before 1Jan2009.

Re: Results not displaying as Expected.

saskyr — Mon, 22 Feb 2021 21:09:36 GMT

When you created the table "DIFT Order Fact", did you name the "new" field OrderDate (you should have created with the function DATEPART)? Did you review the data for the OrderFact table and verify the OrderDate column was populated correctly? My guess is the OrderFact table is where your issue is. Your screen grabs from the Splitter job look perfect.