Help using Base SAS procedures

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

Accepted Solution Solved
Reply
Contributor
Posts: 37
Accepted Solution

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

My data is like:

IDclass
ACDC1
ABCD2
ADCB.
ACBD.
ACCD2
ABBB2
AAAB1
ACDA2

 

Proc freq give me output like:

ClassFrequencyPercentCumulative FrequencyCumulative Percent
1233.33%233.33%
2466.67%6100.00%
Frequency missing=2  

 

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

ClassFrequencyPercent
1225.00%
2450.00%
.225.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;

View solution in original post


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