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.
1 2 1 1 2
2 1 2 2 2
3 1 3 2 3
data two (keep=val col);
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;
> 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.