Hi, Scott,
Here is an example:
year channel type numloans
1 A 1 100
2 B 1 5
3 C 1 23
4 A 2 7
5 B 2 10
proc summary data=loan_all missing completetypes;
class year channel /preloadfmt exclusive;
var numloans;
output out=test sum=;
format channel $channellbl.;
where type in ('1','2','3');
run;
My output will have every permutation of year and channel for types 1 and 2, but not for 3 because type is not in the class statement and never appears in the data. How can I print 0 for numloans for every permutation of year and channel for type 3? I cannot create a temporary dataset with all 0s because the variables will change each time the program is run.
... View more