SAS output when prompt value is not located

[Lewinda]

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:

Year	Total
2010	25
2011	50
2012	30

This is not what I want.

I want a table like this...

OUTPUT:

Year	Total
2010	0
2011	0
2012	0

Any help would be greatly appreciated!!

Lewinda