Prev: Urgent Position: (JMP/SAS Expert), San Jose CA 6 months Contract
Next: PROC MIXED for non-normal data
From: Ya Huang on 3 Feb 2010 12:21
One proc tabulate can get what you need, if you don't mind
some extra info:

data have;
input snp1 $ snp2 $ snp3 $;
cards;
a . g
a . h
.. a .
.. a l
b . .
.. b .
.. . k
c . .
c . a
.. b b
;
run;

proc tabulate noseps missing;
class snp1-snp3;
table snp1-snp3, pctn='%';
run;

-------------------------------------
| | % |
|----------------------+------------|
|snp1 | |
| | 50.00|
|a | 20.00|
|b | 10.00|
|c | 20.00|
|snp2 | |
| | 60.00|
|a | 20.00|
|b | 20.00|
|snp3 | |
| | 40.00|
|a | 10.00|
|b | 10.00|
|g | 10.00|
|h | 10.00|
|k | 10.00|
|l | 10.00|
-------------------------------------

On Tue, 2 Feb 2010 21:10:12 -0800, Lance Smith <medicaltrial(a)GMAIL.COM>
wrote:

>Hi
>
>I have a dataset with 50 character variables (SNP1 - SNP50), each of
>which have a certain amount of missing data. I want to create a table
>that will give me the percentage of missing data per variable. Maybe
>something like this:
>
>VARIABLE N %MISSING
>SNP1 2010 2.6%
>.
>.
>.
>.
>.
>SNP50 2010 5%
>
>How do I do this in SAS?
>Thank you for your help.
First  |  Prev  | 
Pages: 1 2
Prev: Urgent Position: (JMP/SAS Expert), San Jose CA 6 months Contract
Next: PROC MIXED for non-normal data