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, statalist.org is already up and running.


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

st: counting and immediately creating a new variable


From   "S.H. Former" <S.H.Former@uvt.nl>
To   statalist@hsphsun2.harvard.edu
Subject   st: counting and immediately creating a new variable
Date   Wed, 14 Sep 2011 11:19:45 +0200

Dear reader,
 
I have a question concerning counting data and representing this count immediately in a new cell. The design of my dataset looks as follows:
 
 
patent            value          complexity                   company           
3930280         34                               15              10679134                   
3930282         16                                8              10577942                    
3930283         12                               15             10577942                    
3930292          7                                20             10151655                    
3930294          4                                10             10680932                    
3930294          4                                10             10680932                    
3930297          34                               23           10105812                     
3930297          34                               23           10105812                     
3930299          1                                 5             10204962                    
3930304          58                               14           10046713                     
3930304          58                               14           10046713                     
3930304          58                               14           10046713                     
3930308          6                                 4              10140808                    
3930308          6                                 4              10140808                    
3930308          6                                 4              10140808                    
3930325          8                                 8              10446448                    
3930339          14                               4              10120593                    
3930344          9                                 8              10030344                    
3930359          5                                 3              10107775                    
3930367          21                               14            10446448                    
3930367          21                               14            10446448                    
3930367          21                               14            10446448                    
3930367          21                               14            10446448                    

Now I want to create a new variable where the number a patent is included in the database is counted. So it should look like this:
 
patent            value          complexity          company   New Variable       
3930280         34                        15          10679134                    1
3930282         16                         8           10577942                    1
3930283         12                         15         10577942                    1
3930292          7                          20         10151655                    1
3930294          4                          10         10680932                    2
3930294          4                          10         10680932                    2
3930297          34                        23         10105812                    2
3930297          34                        23         10105812                    2
3930299          1                           5         10204962                     1
3930304          58                         14        10046713                    3
3930304          58                         14        10046713                    3
3930304          58                         14        10046713                    3
3930308          6                          4          10140808                     3
3930308          6                          4          10140808                     3
3930308          6                          4          10140808                     3
3930325          8                          8           10446448                    1
3930339          14                         4          10120593                    1
3930344          9                           8          10030344                    1
3930359          5                           3          10107775                    1
3930367          21                         14        10446448                    4
3930367          21                         14        10446448                    4
3930367          21                         14        10446448                    4
3930367          21                         14        10446448                    4
 
So for example take patent 3930294, you can see that there are two patents with this number so the new variable should give 2!
 
Could please anyone help me with this problem?
 
thanks in advance,
 
Sytze



*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/


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