Table of strings

[Giorgio Di Stefano]

I have a panel of 48 countries, for which I need to create an academic table of which countries I have in my sample. In the countries then there is a classification into groups. These groups are Advanced, Emerging, and Developing, according to the IMF Beyond the countries, over time, there is a category they belong to, either red or green. This status let's say for some countries changes for some in time. I have to do an academic table for publication, which should list the countries as a whole, then list the countries by the IMF classification, then whether the countries are red or green. The main thing however is to indicate in a quote in the red or green classification if the country changes category over time with the new category in parentheses e.g. If Australia is red and e.g. became green, in the report in the red
Australia (green from year). The equivalent in another country that is green and turns to red.
I hope it is understandable.

You can think of a list of countries in panels. There is no data to give an example. Note finally that I have a dummy for each case ==1 red, green as well as for grouping by IMF if that helps somehow. The layout in panels is id year

Thank you for your help in advance!

[Hemanshu Kumar]

I don't quite understand why you say "there is no data to give an example". Please provide example data with dataex, so that we have a clear sense of what we are working with. It would also be helpful for you to make a dummy table showing exactly how your final table should look. I suspect the absence of these is why no one has come forward to help until now.

[Giorgio Di Stefano]

I don't quite understand why you say "there is no data to give an example". Please provide example data with dataex, so that we have a clear sense of what we are working with. It would also be helpful for you to make a dummy table showing exactly how your final table should look. I suspect the absence of these is why no one has come forward to help until now.

The set up is a panel with Id year

Here is possible layout .It should be placed into columns

Countries
List countries

Advanced
country list


Emerging
Country list

Development
country list

Red
County list
if a country has enter or left the group it should be noted in parenthesis the new group and the year ie. Australia( red or green from 1988)

Green

County list
if a country has enter or left the group it should be noted in parenthesis the new group and the year ie. Australia (red or green from 1988 )

I do not have numerical data for this. I only have strings. Countries are in strings in panel data format. Same goes for the other groups. They are in strings. The only difference or addition is the dummy variables I have created =1 based on the string group. In short, I'm looking to create a table of strings in order to be able present it in as the country sample and their classification according to the group

For the dummies normal dummies are present. red =1, green =1. Same goes for the other groups.

[Hemanshu Kumar]

I did not ask for numerical data. Please do not provide descriptions, they are nowhere near as helpful as the data itself. Please show us an example of the data you have (string, numeric, whatever) in tabular form, and show us the corresponding table you want to produce from it.

[Nick Cox]

Data here certainly includes string variables, which to Stata are respected citizens in any dataset just like numeric variables.

I agree strongly with Hemanshu Kumar as I looked at #1 but without examples it wasn't clear enough to tempt me to try to work out what you want and how to get it. I didn't want to say that, but you don't seem to be taking note of #2. A lengthy word description that seems perfectly clear to whoever writes it can be too much for anyone else to grasp easily.