asebobr.blogg.se

Converting excel to stata in stat transfer
Converting excel to stata in stat transfer









converting excel to stata in stat transfer

> (separate) into stata and I'm using stat transfer (version 8) for > I'm trying to convert a SAS file (V 9.1) with date and time variables You need to look really closely at the data in SAS and in Stata. > On this information, my only guess is that time (presumably time of day, up to 24hr) is being converted to fraction of a day. Dates and times seem simple in principle but can be very awkward in practice. > I wouldn't assume much in this territory. I can convert it as a csv file and then get it into stata It's weird considering that the conversion to excel works If you need more help, please provide log files. You are using an old version of Stat/Transfer. I guess this is why the conversion results surprised you. Stat/Transfer does not support conversions between any of the numeric Leny, what is weird? Nick (and others, including Bill Gould) gave youĪ reasonable explanation to the problem and useful advice. Just to cheer people up at what is for many a holiday Alexandersson varies between software, and the subtle differences can be just as puzzling as the stark differences. To be fair, the meaning of "type", "format", etc.

converting excel to stata in stat transfer

(c) there's a prevailing misimpression that formats define storage or how data are held, but they define only how data are displayed.

#CONVERTING EXCEL TO STATA IN STAT TRANSFER SOFTWARE#

(b) dates are intelligible as such within Stata given appropriate formats and manipulation using appropriate functions, but neither has anything much to do with the way that other software sees the same data (a) dates are not a distinct type (meaning storage type) in Stata they are just held as some kind of integer type, but that doesn't define them as dates The conversion to Stata dates is often made even difficult to understand because, even though the facts are explained in the documentation, exact details of precisely what was done (for example, I don't know what precisely "conversion to excel" means). expertise on A, B, C and D (not many of us qualify)Ģ. RE: st: RE: converting SAS file to stata using stat transfer-date and time variablesĪdvising on exactly what happens when you want to transfer from A to D using B and/or C (here SAS, Stata, Stat/Transfer and MS Excel) would seem to requireġ. Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at.











Converting excel to stata in stat transfer