Please join your peers on either March 26 (8pm GMT) or March 28 (8am GMT) to watch as user extraordinaire and forum legend @"lindsay.stevens" demonstrates OpenClinica Insight.

See preview and register at https://openclinica.com/insight-webinar

Insight makes it easy to ask questions of ALL of your clinical and operational data and visualize answers via interactive reports and dashboards. The idea is simple, but the results are powerful: ask your questions, choose your visualizations, then return often for updated, interactive results that link you to all of the underlying data.

Working with Stata

Hi everyone,

I think I'm not the only one working with Stata and I will really appreciate if anyone of the OC community could share the script they use to transpose, reshape the data before analysis.
It will be very helpful.

Thanks !

Comments

  • bbaumannbbaumann Posts: 105 admin
    via Email
    Here's a converter from SPSS to STATA. Perhaps it might help?

    https://community.openclinica.com/extension/data-extract-stata

    On Wed, Nov 23, 2016 at 6:07 AM, RCHENU <
    [email protected]> wrote:

    > OpenClinica https://forums.openclinica.com/
    > RCHENU started a new discussion: Working with Stata
    >
    > Hi everyone,
    >
    > I think I'm not the only one working with Stata and I will really
    > appreciate if anyone of the OC community could share the script they use to
    > transpose, reshape the data before analysis.
    > It will be very helpful.
    >
    > Thanks !
    >
    > --
    > To manage your email notifications, please visit:
    > https://www.openclinica.com/forums#/profile/preferences
    >
    > Reply to this email directly or follow the link below to check it out:
    > https://forums.openclinica.com/discussion/16123/working-with-stata
    >
    > Check it out: https://forums.openclinica.com/discussion/16123/working-
    > with-stata
    >
  • RCHENURCHENU Posts: 195
    Thanks.
    Yes I'm using it, but I'm talking once data are imported into Stata.

    Romain.
  • lindsay.stevenslindsay.stevens Posts: 403 ✭✭✭
    The community datamart generates variable and value labelling code for Stata, if that is the kind of thing you're looking for.

    Maybe best if you ask a specific question, because all the Stata code beyond that tends to be specific to a study and an analysis purpose.
  • RCHENURCHENU Posts: 195
    edited November 2016
    Thanks @lindsay.stevens

    I downloaded directly the stata_output.zip from the premade_demo_files to see how it looks like but I can't open the .dta in Stata.
    I have this error: file ....dta not Stata format
    Do you know why ?

    Thanks.

    Post edited by RCHENU on
  • lindsay.stevenslindsay.stevens Posts: 403 ✭✭✭
    I generated those files with Stata version 14.1. My guess is that you have a Stata version older than that. I've just pushed up to GitHub a copy of the files in Stata 11 format, which is the oldest that the "saveold" command would let me do :)
  • RCHENURCHENU Posts: 195
    Thanks @lindsay.stevens unfortunaltly, I can't open the zip file... Error messsage says that this is an invalid zip file :-)
  • lindsay.stevenslindsay.stevens Posts: 403 ✭✭✭
    D'oh. I was changing line endings from CRLF to LF in the repository and accidentally broke that zip file in the process. I've re-made it and pushed a working copy up.
  • RCHENURCHENU Posts: 195
    Thanks Lindsay, it's working now.
    Do I have to go all through the install of the data mart to use only this Stata tool or do you see another way ?
    Or maybe do you have already some scripts which do that directly in Stata, after using the SPPS script to import in Stata ? That will be awsome !

Sign In or Register to comment.