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:
Any help would be greatly appreciated!!
Lewinda