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
Practicum due soon/autocorrelation unbalanced panel data: xtreg, cluster, xtregar, xtpcse??Hi all! I am struggling a bit to figure out which is the best command to use for OLS on unbalanced …
Stratified Wilcoxon Mann Whitney Generalised Odds Ratios for Repeated Measures DataDear Statalist, Hope you're all well. I have a dataset with repeated measures of the modified Rank…
Creating categorical variables for hypertensionHello, I am trying to complete a homework assignment for a coding class where I have to "use bpsyst…
Two part model with instrumental variableHi: I am using a two part model with a binary dependent variable and a binary endogenous regressor.…
SEM - insignificant direct path vs. significant indirect pathsDear Forum, I am conducting SEM analysis in Stata and I have specified a well-fitting measurement m…
Subscribe to:
Post Comments (Atom)
0 Response to Changing structure of Data set
Post a Comment