Hi,   I would like to create a table from the following data:   data have; length Income $ 10; input ID Income $ Pension; cards;   1 400-500 . 2 300-400 1 3 500- 1 4 200-300 . 5 300-400 . 6 400-500 1 7 300-400 1 8 200-300 . 9 100-200 . 10 500- 1 ; run;   The data i this example concist of 10 individuals belonging to different income groups where som of them have pension payments (Pension=1) and some does not (Pension=.). I have to create a table with proc tabulate that shows (1) the number of people in each income group, (2) the number of people with pension payments in each income group and (3) the percentege of people with pension payments of the total population in each income group.   The following syntax output the answer for the first two questions. I need help with the one regarding the percentege of people with pension payments of the total population in each income group.    proc tabulate data=Have format=comma12. ; class Income ; var ID Pension ; table Income='' All='Total', ID='Total population'*N='' Pension='People with pensions' *sum=''    /box='Income group';    run;   Thanks! ... View more

Hi there,   I need to create a table (se attached Excel file showing how the table should look at the en). I have data (se attached Excel fil representing the data source with the variables I need to analyse).    I think it should work with proc tabulate, but I am not sure how to use it. I the dataset the variable "Vikt" must be use according to the Freq statement.    I will be grateful for your help 🙂   Thanks /MCB ... View more