I have a table with two group columns. One is a time variable and the other is just a group like the one below.
Data have(drop=x);
Do x = 1 to 6;
year = 2010;
group = 2;
output;
End;
Do x = 1 to 6;
year = 2020;
group = ceil(x/3);
output;
End;
Run;
I am attempting to calculate the share of observations by year and group in the following manner:
Proc tabulate data=have out=not_want(drop=_type_ _page_ _table_);
Class year / missing;
Class group / missing;
Table group='',year=''*colpctn='';
Run;
The results window shows the desired results, however the output table does not contain the missing value from the year 2010. This is the expected output:
Data want;
year = 2010; group=1; share=100; output;
year = 2010; group=2; share=.; output;
year = 2020; group=1; share=50; output;
year = 2020; group=2; share=50; output;
Run;
Ok. You can use the Printmiss Option in the Table Statement like this.
This will give you a 0 in the output pct, which is more correct than a missing value.
Let me know if this works for you.
Proc tabulate data=have out=not_want(drop=_type_ _page_ _table_);
Class year / missing;
Class group / missing;
Table group='',year=''*colpctn='' / printmiss;
Run;
Is it a requirement to do this with Proc Tabulate?
If there is another solution, which is just as compact and fast then sure, other option can be considered. For example doing this through PROC SQL takes too much time, as my real dataset is quite big.
Ok. You can use the Printmiss Option in the Table Statement like this.
This will give you a 0 in the output pct, which is more correct than a missing value.
Let me know if this works for you.
Proc tabulate data=have out=not_want(drop=_type_ _page_ _table_);
Class year / missing;
Class group / missing;
Table group='',year=''*colpctn='' / printmiss;
Run;
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Select SAS Training centers are offering in-person courses. View upcoming courses for: