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
... View more