10-07-2014 11:16 AM
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)
This is not what I want.
I want a table like this...
Any help would be greatly appreciated!!