Hi,
I've started using Stata17 and never experienced the following problem with past version:
I am importing an excel sheet which contains a column with dates (in a "Date" format in excel) in the following form:
"2020-10-14 11:11:10 AM"
"2020-10-14 4:15:30 PM"
...
Only the date (and not the time) is displayed in excel. When importing the file, Stata automatically imports the column in a %td format, though when tabulating the data, the table contains a different row per observation, as if it imported the data in %tC format. Moreover, when converting the column to %tC format (or %tc format), I get the following column instead:
"01jan1960 00:00:22"
"01jan1960 00:00:22"
...
Again, I get a different row per observation when tabulating.
In the past, date variables would be imported in strings - it would then be easy to convert them into %td and %tC variables. Unsure if it's do to the Stata version or if there's an issue with my Excel file. I was able to import the same Excel sheet without an issue with Stata15.
Thanks
Related Posts with Issue importing time
Descriptive analysisHello, i am suppose to run a descriptive analysis on a varialbe called ' General health'. When i sum…
Creating Percent Change VariableHello, I am doing a secondary data analysis of pre and post-surveys for a falls prevention program.…
Margins dxdySo I need to calculate the partial effect at the average and the average partial effect of a probit …
How to make stata show the "Yes" answers in graphs insted of "No"Hi, I've been trying to graph some data but Stata keeps represent the group who answered no to the …
Help replicate a simple Bayesian modelHello everyone, I'm trying to replicate a simple example of Bayesian Analysis as in the Federal Fun…
Subscribe to:
Post Comments (Atom)
0 Response to Issue importing time
Post a Comment