I have an excel data set in the format having first Column as Date, and following Columns have daily returns of different companies number around 500 to 600. Each column is labelled with individual company name. The worksheet contains one year of daily returns data. I want to transform this data set into cross sectional format showing first column for Company Name, Second for Date and Third for Returns.
Kindly guide about the code.
Related Posts with Changing structure of Data set
Computing accuracy score on StataSay we have Stata variables "yBestPred", "sp" and "compliance": Code: list yBestPred 1. 1 2. 0…
Stata 15 v 16 for latent class analysis (aka profile analysis)I want to identify discrete personality profiles for parenting styles. For example: I have 5 persona…
cox proportional hazard ratio with time varying covariateDear Stata community, I am struggling with cox proportional hazard ratio. I was wondering if you c…
Number of firms by different countriesHi STATA experts, I am try to generate a descriptive statistics table that showing the number of fi…
Chi square tests on many variables in a panel datasetDear all, I have a panel dataset and I am trying to do simple chi-square tests by sex on about 140 v…
Subscribe to:
Post Comments (Atom)
0 Response to Changing structure of Data set
Post a Comment