Desktop productivity for business analysts and programmers

SAS output when prompt value is not located

Reply
New Contributor
Posts: 2

SAS output when prompt value is not located


Hi all,

I have a dataset that included information for employers. I have created a prompt to create an employer specific table that sums up all the data for that employer by year. The problem I having is that:

When the employer entered into the prompt (numeric - user enters code) is not contained in the dataset, SAS returns a table that sums up all employers.  This is not what I want.  I want a table that shows zeros in my cells.

For example:   Prompt: Employer code = 1234 (not found in data set)

OUTPUT:

YearTotal
201025
201150
201230

This is not what I want.

I want a table like this...

OUTPUT:

YearTotal
20100
20110
20120

Any help would be greatly appreciated!!

Lewinda

Ask a Question
Discussion stats
  • 0 replies
  • 192 views
  • 0 likes
  • 1 in conversation