Solved
Contributor
Posts: 37

# Proc freq percentage with full N(missing and non-missing)

My data is like:

 ID class ACDC 1 ABCD 2 ADCB . ACBD . ACCD 2 ABBB 2 AAAB 1 ACDA 2

Proc freq give me output like:

 Class Frequency Percent Cumulative Frequency Cumulative Percent 1 2 33.33% 2 33.33% 2 4 66.67% 6 100.00% Frequency missing=2

I need output(percent based on entire N of the dataset):

 Class Frequency Percent 1 2 25.00% 2 4 50.00% . 2 25.00% Total 100.00%

Please help-thanks in advance!

Accepted Solutions
Solution
2 weeks ago
SAS Super FREQ
Posts: 4,239

## Re: Proc freq percentage with full N(missing and non-missing)

Posted in reply to pmpradhan
``````proc freq data=Have;
tables class / missing;
run;``````

All Replies
Super User
Posts: 6,754

## Re: Proc freq percentage with full N(missing and non-missing)

Posted in reply to pmpradhan

You'll need to add the MISSING option to your program:

tables class / missing;

Contributor
Posts: 37

## Re: Proc freq percentage with full N(missing and non-missing)

Posted in reply to Astounding

Thank you very much!

Solution
2 weeks ago
SAS Super FREQ
Posts: 4,239

## Re: Proc freq percentage with full N(missing and non-missing)

Posted in reply to pmpradhan
``````proc freq data=Have;
tables class / missing;
run;``````
Contributor
Posts: 37

## Re: Proc freq percentage with full N(missing and non-missing)

Thank you very much!
☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
• 4 replies
• 84 views
• 2 likes
• 3 in conversation