Bookmark and Share

Notice: On March 31, it was announced that Statalist is moving from an email list to a forum. The old list will shut down on April 23, and its replacement, is already up and running.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: st: routine for matching of a str-variable

From   Thomas Zimmermann <>
Subject   Re: st: routine for matching of a str-variable
Date   Thu, 12 May 2011 10:41:46 +0200

Am 11.05.2011 um 19:19 schrieb Nick Cox:

Even better, -tab, generate()- will do it for you in one line!

thx for your advice, nick.
sorry for being a bit too imprecise.

i have 2 tables: table 1 (dataset) with some variables incl. one variable
"atc-code" with 700+ agents (14000+ rows). for counting that, the "tab,
gen()-thing" is perfectly suitable.

but: i have table 2, a specific subset of agents (200+) and their atc- code,
one agent = one row.

my working question: how many times is any of the agents in table 2
represented in the variable atc-code in table 1.

hope, i sort of disentangled the problem a bit.


Dr. Thomas Zimmermann
Institut f. Allgemeinmedizin
Universitätsklinikum Hamburg-Eppendorf
Martinistr. 52
20246 Hamburg
040 7410 56066

Pflichtangaben gemäß Gesetz über elektronische Handelsregister und Genossenschaftsregister sowie das Unternehmensregister (EHUG):

Universitätsklinikum Hamburg-Eppendorf
Körperschaft des öffentlichen Rechts
Gerichtsstand: Hamburg

Prof. Dr. Jörg F. Debatin (Vorsitzender)
Dr. Alexander Kirstein
Joachim Prölß
Prof. Dr. Dr. Uwe Koch-Gromus

*   For searches and help try:

© Copyright 1996–2015 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   Site index