topic Re: Final table has no rows in SAS Data Management

Final table has no rows

Sandun — Tue, 06 Oct 2020 05:40:12 GMT

I have a table. I extracted data from it using some conditions. Then the target table has no records. I used sum() expression to get my final output with a hard quoted column. but in the final table I cant see even that hard quoted column

eg: expected result

name total

"John"

result gives by DI studio

name total

How to get that expected result?

Re: Final table has no rows

ballardw — Tue, 06 Oct 2020 08:10:37 GMT

Actual example data in the form of data step that will replicate your data set.

The entire data step code you ran. Copy the code that you ran from the LOG including the entire data step and any notes, warnings or messages. Paste on the forum into a code box opened with the </> to preserve formatting of the log text so any diagnostic messages SAS provides are preserved properly. The main message windows on this forum will reformat pasted text and what you post may not be what was actually in the log.

It may also help to tell us exactly how you checked on the results.

Most likely it means that no records in your data met the conditions you set. Common issues could be

1) Attempting to match without considering the case of letters such as "john" with "John", "j" is not the same as "J" so not a match.

2) Calculations with missing values

3) "Less than" or "greater than" comparisons with character values. These can work but in general without a fair amount of experience the results are not as expected/ desired: "41" is less than "9" in character comparisons for example.

4) using values for comparisons that you expect but do not actually exist in the data

Re: Final table has no rows

LinusH — Wed, 13 Jan 2021 08:43:43 GMT

As @ballardw states, we need more information in order to help.

I think this might be a transformation configuraton issue.

A screen shot on the mapping tab might help.

Verify your configuration by looking at the step code, as well the log after execution.