Frequency table of multiple columns variables

[Felix Kork]

Sorry, I am a physician and not a programmer. Thank you for your help in advance, but a cumbersome internet search has not led to a solution.

I have a data matrix with 102 columns (and 46 million rows). the columns are called robot (0 or 1) and ko1 to ko101 (strings). I would like to know, which strings are how often (I don't know the possibilities) in the columns ko1 through ko101 AND in the rows in which robot == 1 (approx. 185,000 rows). All tests with tab1, table, tabulate did not work.

Has anyone an uncomplicated physisican-proof idea?

Many thanks in advance
Felix

[Mike Lacy]

We'd need to know more than "did not work" to help you here. (That's the Stata analogue of a patient who only says "I don't feel good." It makes diagnosis and treatment difficult <friendly grin> ).

To get some help, please do this: 1) Please show us in in a followup posting here exactly what command(s) you gave and exactly what Stata responded. You can copy/pasterom your Stata results window ; 2) Show us a sample of your data, using the -dataex- command, as requested in the StataList FAQ for new members. Something like the following should be enough:

dataex robot ko1 ko2 ko3, count(10)

If there are issues of confidentiality that prohibit you from presenting this data, perhaps you can do the preceding and replace the example data values from -dataex- with "fake" data. Another helpful thing to do there would be to present the results of -describe robot ko1 ko2 ko3-