Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>"String labels" here is informal; Stata does not support value labels for string variables. However, what is wanted here is that the distinct values of a string variable become variable labels on reshaping. </p> <p>Various work-arounds exist. Here's one: put the information in the variable name and then take it out again. </p> <pre><code>clear input entityID str4 indicator str14 indicatordescr indicatorvalue 1 gdp "Gross Domestic" 100 1 pop "Population" 15 1 area "Area" 50 2 gdp "Gross Domestic" 200 2 pop "Population" 10 2 area "Area" 300 end gen what = indicator + "_" + subinstr(indicatordescr, " ", "_", .) keep entityID what indicatorvalue reshape wide indicatorvalue , i(entityID) j(what) string foreach v of var indicator* { local V : subinstr local v "_" " ", all local new : word 1 of `V' rename `v' `new' local V = substr("`V'", strpos("`V'", " ") + 1, .) label var `new' "`V'" } renpfix indicatorvalue </code></pre> <p>EDIT If the length of variable names bites, try another work-around: </p> <pre><code>clear input entityID str4 indicator str14 indicatordescr indicatorvalue 1 gdp "Gross Domestic" 100 1 pop "Population" 15 1 area "Area" 50 2 gdp "Gross Domestic" 200 2 pop "Population" 10 2 area "Area" 300 end mata : sdata = uniqrows(st_sdata(., "indicator indicatordescr")) keep entityID indicator indicatorvalue reshape wide indicatorvalue , i(entityID) j(indicator) string renpfix indicatorvalue mata : for(i = 1; i &lt;= rows(sdata); i++) stata("label var " + sdata[i, 1] + " " + char(34) + sdata[i,2] + char(34)) end </code></pre> <p>LATER EDIT Although the above is called a work-around, it is a much better solution than the previous. </p>
    singulars
    1. This table or related slice is empty.
    1. POCarrying string labels of string variable after reshape
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USNick Cox
    1. USNick Cox
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POCarrying string labels of string variable after reshape
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    1. COThank you this does work. However, it is worth noting that doing so will prevent to carry over long labels. The algorithm above requires use variable names to carry variable+label information. And the reshape will only be successful if variable names are 32 characters or less. Is there a way that uses local macros in order to overcome that shortcoming?
      singulars
      1. PO
      1. USPeutch
    2. COThe EDIT worked perfectly. Thank you!
      singulars
      1. PO
      1. USPeutch
    3. COQuick question: is it necessary to clear the mata or sdata from memory once the algorithm has run, and if so, how?
      singulars
      1. PO
      1. USPeutch
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload