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
Formatting in the command: generate _registration_date = date(registration_date, "DMY")Hi, I have a string variable for the registration data and I am trying to destring it. I am running…
Using -KHB- in mediation analysis & results don't matchHi everyone, I am using the KHB command to conduct mediation analysis for a probit model. Previousl…
Observe the jumps of (number of) observations and drop the outliersHello, I'ma beginner in Stata and I have some questions on observing the jumps of number of observ…
More than one change point in interrupted time-seriesDear colleagues the data below is a subset of my data that I am intending to analyse using interrupt…
Data ManipulationI want to replace the missing observations in HSCode variable with the previous HScode. I use the fo…
Subscribe to:
Post Comments (Atom)
0 Response to Changing structure of Data set
Post a Comment