Announcement

Collapse
No announcement yet.
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • New version of cprdutil on SSC

    Thanks as always to Kit Baum, a new version of the cprdutil package is now available for download from SSC. In Stata, use the ssc command to do this, or adoupdate if you already have an old version of cprdutil.

    The cprdutil package is described as below on my website. The new version now includes a hyperlink in the online help file to my presentation on cprdutil at the 2018 London Stata Conference. (Thanks to Kit for uploading that as well, and all the other Stata Conferences/User Meeting proceedings.)

    Best wishes

    Roger


    -----------------------------------------------------------------------------
    package cprdutil from http://www.rogernewsonresources.org.uk/stata13
    -----------------------------------------------------------------------------

    TITLE
    cprdutil: Utilities for inputting CPRD datasets into Stata

    DESCRIPTION/AUTHOR(S)
    The cprdutil package is a suite of utility programs for inputting
    text datasets produced by the Clinical Practice Research Datalink
    (CPRD), and outputting Stata datasets and/or do-files to create
    value labels. CPRD text datasets may contain XYZ lookup tables,
    non-XYZ lookup tables, non-lookup datasets, or browser-export
    datasets, with one text row for each of a set of things of a kind
    known to the primary-care sector of the British Health Service,
    such as patients, primary-care practices, clinical events or
    prescriptions. All of these may be output into Stata datasets,
    with one output observation per input text row. An XYZ lookup
    table may alternatively be translated into a set of Stata value
    labels, created using a generated do-file, to be assigned to
    variables in other Stata datasets after running the do-file in the
    dataset. The cprdutil package uses the SSC packages keyby,
    addinby, lablist, chardef, and intext, which need to be installed
    for cprdutil to work.

    Author: Roger Newson
    Distribution-Date: 21february2019
    Stata-Version: 13

    INSTALLATION FILES (click here to install)
    cprd_additional.ado
    cprd_batchnumber.ado
    cprd_bnfcodes.ado
    cprd_browser_medical.ado
    cprd_browser_product.ado
    cprd_clinical.ado
    cprd_common_dosages.ado
    cprd_consultation.ado
    cprd_entity.ado
    cprd_immunisation.ado
    cprd_medical.ado
    cprd_nonxyzlookup.ado
    cprd_packtype.ado
    cprd_patient.ado
    cprd_patientobs.ado
    cprd_practice.ado
    cprd_product.ado
    cprd_referral.ado
    cprd_scoremethod.ado
    cprd_staff.ado
    cprd_test.ado
    cprd_therapy.ado
    cprd_xyzlookup.ado
    cprd_additional.sthlp
    cprd_batchnumber.sthlp
    cprd_bnfcodes.sthlp
    cprd_browser_medical.sthlp
    cprd_browser_product.sthlp
    cprd_clinical.sthlp
    cprd_common_dosages.sthlp
    cprd_consultation.sthlp
    cprd_entity.sthlp
    cprd_immunisation.sthlp
    cprd_medical.sthlp
    cprd_nonxyzlookup.sthlp
    cprd_packtype.sthlp
    cprd_patient.sthlp
    cprd_patientobs.sthlp
    cprd_practice.sthlp
    cprd_product.sthlp
    cprd_referral.sthlp
    cprd_scoremethod.sthlp
    cprd_staff.sthlp
    cprd_test.sthlp
    cprd_therapy.sthlp
    cprd_xyzlookup.sthlp
    cprdutil.sthlp
    -----------------------------------------------------------------------------
    (click here to return to the previous screen)


  • #2
    Hi All,

    1,048,576 is the max row limit for excel. So if you have STATA data over this limit and wanted to have it in one excel sheet, how do you export this data to excel?
    I got this from STATA:

    export excel using "H:\ASSTATA\file0916.xlsx", replace firstrow(variables)

    error "observations must be between 1 and 1048576"


    Thanks for the help.
    Regards,
    Tadesse

    Comment

    Working...
    X