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 c1c5;
datalines;
1 2 1 1 2
2 1 2 2 2
3 1 3 2 3
run;
data two (keep=val col);
set one;
array cols c1c5;
do i=1 to dim(cols);
col = vname(cols(i));
val = cols(i);
output;
end;
run;
proc freq data=two;
tables val * col / nocum nocol norow nopercent missing;
run;
Hth,
Eric
jrdwthomas@hotmail.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
