Announcement

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

  • Creating a single table from tabulation of many similar variables using asdoc

    I have a dataset that has similar responses to different questions. For example Q1, Q2, Q3, ... Qn have all have coded responses of 1 for strongly disagree, 2 for disagree, 3 for agree, and 4 for strongly agree. I want to tabulate all these questions in one table using asdoc (available on SSC). Is there any option available in asdoc to do this?

  • #2
    This feature was added to asdocx (more details on asdocx are here). Here is an example where I use tabmany , which is asdocx's sub-command.

    Code:
     First Create an example dataset
    clear
    input str3 id int(i1 i2 i3 i4 i5)
    " 1" 1 4 2 3 5
    " 2" 1 3 3 2 4
    "3"   1 1 1 1 1
    "4"   2 2 2 2 2
    "5"   3 3 3 3 5
    "6"   1 1 1 1 1
    "7"   5 5 5 5 5
    "9"   4 1 5 4 4
    "10"  5 5 5 5 5
    "11"  2 1 4 2 1
    "12"  2 2 2 2 2
    end
    label values i1 responsesets
    label values i2 responsesets
    label values i3 responsesets
    label values i4 responsesets
    label values i5 responsesets
    label def responsesets 1 "Strongly Disagree", modify
    label def responsesets 2 "Disagree", modify
    label def responsesets 3 "Neutral", modify
    label def responsesets 4 "Agree", modify
    label def responsesets 5 "Strongly Agree", modify
    * Send to Excel
    Code:
    asdocx tabmany i1-i5
    Click image for larger version

Name:	Capture.JPG
Views:	1
Size:	54.0 KB
ID:	1586320


    Regards
    --------------------------------------------------
    Attaullah Shah, PhD.
    Associate Professor of Finance, Institute of Management Sciences Peshawar, Pakistan
    www.FinTechProfessor.com
    If you use MS Word, do check my asdoc program that easily sends Stata output to MS Word

    Comment


    • #3
      There is a small update to asdocx's tabmany sub-command. It now accepts [if] and [in] qualifiers. The latest version of asdocx is
      Code:
      Sep 14, 2021: Version 1.8.3
      Regards
      --------------------------------------------------
      Attaullah Shah, PhD.
      Associate Professor of Finance, Institute of Management Sciences Peshawar, Pakistan
      www.FinTechProfessor.com
      If you use MS Word, do check my asdoc program that easily sends Stata output to MS Word

      Comment


      • #4
        Thanks you professor for the update. I have used many programs to manage results and tables. asdocx is super-easy and versatile. It exports to Word and Excel with no hassle.

        Comment

        Working...
        X