Check out -contract-. 
Nick 
[email protected] 
Ekaterina Hertog
I have got a table with 4 variables
sex age desir_age freq
female 22 25 16
male 23 20 27
female 23 20 23
male 23 21 2
female 23 21 4
male 23 22 5
and I would like to turn "sex" and "freq" variables into "frequency 
male" and "frequency female" to be able to make a graph.
So the resulting table should look something like that
age desir_age freq_m freq_f
22 25 - 16
23 20 27 23
23 21 2 4
23 22 5 -
I have looked at the -table- command but I cannot quite figure out how 
to do it.
*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/