Final table has no rows

[Sandun]

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?

[ballardw]

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

[LinusH]

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.