Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: st: RE: converting SAS file to stata using stat transfer-date and time variables
From
Sergiy Radyakin <[email protected]>
To
[email protected]
Subject
Re: st: RE: converting SAS file to stata using stat transfer-date and time variables
Date
Tue, 21 Dec 2010 11:50:25 -0500
Leny,
perhaps you could use Stat\Transfer to cut the data (to keep just one
observation, or just one variable with dates), then post the file somewhere
to an accessible location, where we can examine it?
Best,
Sergiy Radyakin
On Mon, Dec 20, 2010 at 3:40 PM, Leny Mathew <[email protected]> wrote:
> Thanks Nick. It's weird considering that the conversion to excel works
> fine. I can convert it as a csv file and then get it into stata
> without any issue.
>
> On Fri, Dec 17, 2010 at 12:07 PM, Nick Cox <[email protected]> wrote:
>> I wouldn't assume much in this territory. Dates and times seem simple in principle but can be very awkward in practice.
>>
>> On this information, my only guess is that time (presumably time of day, up to 24hr) is being converted to fraction of a day. You need to look really closely at the data in SAS and in Stata.
>>
>> Nick
>> [email protected]
>>
>> Leny Mathew
>>
>> I'm trying to convert a SAS file (V 9.1) with date and time variables
>> (separate) into stata and I'm using stat transfer (version 8) for
>> this. During the conversion, the date variable comes across fine, but
>> all the time variable values are between 0 and 1. stat transfer reads
>> the SAS file without any problem, it looks fine in the viewer and it
>> converts into excel without any problem. I didn't have to format the
>> date variable within stata, so I'm assuming that I don't have to do
>> any formatting for the time variable either. Has anyone had this issue
>> before?
>> Any comments are much appreciated. I'm using stata 10.1
>>
>> *
>> * For searches and help try:
>> * http://www.stata.com/help.cgi?search
>> * http://www.stata.com/support/statalist/faq
>> * http://www.ats.ucla.edu/stat/stata/
>>
>
> *
> * For searches and help try:
> * http://www.stata.com/help.cgi?search
> * http://www.stata.com/support/statalist/faq
> * http://www.ats.ucla.edu/stat/stata/
>
*
* For searches and help try:
* http://www.stata.com/help.cgi?search
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/