Date: Fri, 18 Aug 2006 07:48:26 -0700
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
Subject: Re: Individual Freq of multiple columns
Content-Type: text/plain; charset="iso-8859-1"
Thanks for the response.
I'll try and explain a little better.
If i were to write...
proc summary data=info;
This would give me a summary of column1 telling me how many times an
observations had occured in that column.
What i need is this doing to all 100 columns. This is why i came up
with 200. Basically something that looks like this
Column1¦_freq_¦column2¦ _freq_¦ column3¦ _freq_¦
abcd 3 gggg 4 dddd 6
ccvv 2 kkkk 6 eeee 8
bnm 0 aaaa 7 opuu 7
This is what i would ike the output to look like except there would be
many more columns!
Does this explain it a little better?
Thanks for the quick response.
Eric Hoogenboom wrote:
> I am not sure if I understand correctly. Especially the 200 confuses
> me. But let me guess.
> Apparently your columns together form a sort of multiple variable. This
> is a construct that SPSS knows, but SAS does not. You have to transform
> the dataset to a column/value form. It is easy in SAS. Probably you can
> adapt the example code below.
> data one;
> input c1-c5;
> 1 2 1 1 2
> 2 1 2 2 2
> 3 1 3 2 3
> data two (keep=val col);
> set one;
> array cols c1-c5;
> do i=1 to dim(cols);
> col = vname(cols(i));
> val = cols(i);
> proc freq data=two;
> tables val * col / nocum nocol norow nopercent missing;
> email@example.com wrote:
> > Hi,
> > This is probably quite an easy task but i'm not personally able to find
> > a solution!
> > Basically i have a sas dataset that has 100 columns and multiple rows
> > of data.For each column i would like to now the frequency of its
> > observations. This should give me a table that has columns with their
> > frequecies basically 200 columns.
> > Does this make sense? Any help would be much appreciated.
> > Thanks