[Patrick Donkor]

Andrew Musau Gradually gradually, I'm progressing! After strictly following your codes to append the dataset, I've been able to create the year variable and append all the columns but the rows keep doubling upon appending.

For instance, I have 6 cross sectional dataset (2015-2020) and each dataset has 3520 observations. After strictly following your codes to append the dataset, the total number of observations becomes 21,120 (i.e. 3520×6)

So kindly check the rows too for me if perhaps there is a way for me to append and get the total observations to remain at 3520, thanks.

[Andrew Musau]

In #1, you stated that

Now I want to plot a graph of Income against Time where the Income (6, 4, 2, 3, 5, 7) will be at the Y-axis whiles the Time (2015-2020) will be at the X-axis.

Please is there a way to plot such graph for a cross sectional data?

and the suggestion by Nick in #2 was to append the datasets to achieve this.

For instance, I have 6 cross sectional dataset (2015-2020) and each dataset has 3520 observations. After strictly following your codes to append the dataset, the total number of observations becomes 21,120 (i.e. 3520×6)

This is what I would expect. Now you should be able to generate your graph. Why do you think that you need 3250 observations?

[Patrick Donkor]

Andrew Musau, yeah you're perfectly right, I will be able to generate the graph I'm looking for but I thought the increased in the number of my observations would actually affect the graph....

In your own opinion, can't it affect the graph? Thanks.

[Andrew Musau]

Have you tried creating the graph and found something amiss?

[Patrick Donkor]

No, the graph was ok and so there was nothing amiss. Thank you so much for all efforts.

[Patrick Donkor]

Andrew Musau, Please one more question, after using the collapse function to find the mean of the variables for 6years, how do I export the result table to be used in my presentation?

[Andrew Musau]

Do you need to export the data to Excel? After collapse,

export excel using myfile, replace firstrow(var)

Then find the file "myfile.xls" saved in your current directory.

[Patrick Donkor]

Yeah exporting the data to excel is ok for me but please is there a way to export it to word or image format?
I mean I'm looking for a way to extract the result which is in tabular form....

[Andrew Musau]

As this is different from the focus of this thread, start a new thread and provide a reproducible example explaining what you need.

[Patrick Donkor]

Andrew Musau, Ok, I will do that.
Thanks so much for all your efforts and time, I'm very grateful.