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 at the end of May, and its replacement, statalist.org is already up and running.


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

Re: st: getting the nth column name


From   Joerg Luedicke <joerg.luedicke@gmail.com>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: getting the nth column name
Date   Tue, 6 Nov 2012 14:25:17 -0600

You can use -ds- (-help ds-) to create a variable list and put the
name of the third variable in a local macro (-help extended_fcn-) for
further usage:

*----------------------
clear
sysuse auto
qui ds
local third : word 3 of `=r(varlist)'
sum `third'
*----------------------

Joerg


On Tue, Nov 6, 2012 at 1:22 PM, Pradipto Banerjee
<pradipto.banerjee@adainvestments.com> wrote:
> I want to write a code to read the 3rd column from a few different datasets. My issue is that the 3rd column can have different names in different datasets. Is there any function or command that returns the name of the Nth column ?
>
> For instance, suppose file F1 has the 3rd column as F1xyz and F2 has the 3rd column as F2abc, I want a generic way to refer to F1xyz and F2abc with an -ado- program?
>
> Thanks
>
>  This communication is for informational purposes only. It is not intended to be, nor should it be construed or used as, financial, legal, tax or investment advice or an offer to sell, or a solicitation of any offer to buy, an interest in any fund advised by Ada Investment Management LP, the Investment advisor.  Any offer or solicitation of an investment in any of the Funds may be made only by delivery of such Funds confidential offering materials to authorized prospective investors.  An investment in any of the Funds is not suitable for all investors.  No representation is made that the Funds will or are likely to achieve their objectives, or that any investor will or is likely to achieve results comparable to those shown, or will make any profit at all or will be able to avoid incurring substantial losses.  Performance results are net of applicable fees, are unaudited and reflect reinvestment of income and profits.  Past performance is no guarantee of future results. All!
  f!
>  inancial data and other information are not warranted as to completeness or accuracy and are subject to change without notice.
>
> Any comments or statements made herein do not necessarily reflect those of Ada Investment Management LP and its affiliates. This transmission may contain information that is confidential, legally privileged, and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is strictly prohibited. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format.
>
> *
> *   For searches and help try:
> *   http://www.stata.com/help.cgi?search
> *   http://www.stata.com/support/faqs/resources/statalist-faq/
> *   http://www.ats.ucla.edu/stat/stata/

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


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