Date:         Thu, 30 Mar 2006 19:10:58 +0530
Reply-To:     mohit.b.bhatia@AEXP.COM
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Mohit Bhatia <mohit.b.bhatia@AEXP.COM>
Subject:      Re: mapping
Comments: To: Guido T <cymraegerict@gmail.com>
Content-Type: text/plain; charset=us-ascii

Hi

Actually even variable index is dynamic so it goes from v&start to v&end.
Please suggest a solution.

Thanks,
Mohit





"Guido T" <cymraegerict@gmail.com>
03/30/2006 07:05 PM


        To:     Mohit B Bhatia/JAPA/TRS/AEXP@AMEX
        cc:     SAS-L@listserv.uga.edu
        Subject:        Re: mapping


On 3/30/06, mohit.b.bhatia@aexp.com <mohit.b.bhatia@aexp.com> wrote:
Actually If lets say var4 is 1 i want to know 4 .... I hope i am clear...
anyway to do that  without loop?

Hi Mohit,

Here's a VERY nasty no-loop way ...

data check;
    set test;
    vpos =
indexc(compress(v1||v2||v3||v4||v5||v6||v7||v8||v9||v10||v11||v12),'1');
    put 'The number of the 1 variable is ' vpos;
run;

Lots of numeric conversion notes in the log, assumes single digit values
(or missing) for the variables, but no loop.  It's not good tho'.

What is your data like?  0 and 1 or other values as well?

Regards
++ Guido





American Express made the following
 annotations on 03/30/06, 06:41:26
------------------------------------------------------------------------------
******************************************************************************

"This message and any attachments are solely for the intended recipient and may contain confidential or privileged information. If you are not the intended recipient, any disclosure, copying, use, or distribution of the information included in this message and any attachments is prohibited. If you have received this communication in error, please notify us by reply e-mail and immediately and permanently delete this message and any attachments. Thank you."

American Express a ajouté le commentaire suivant le 03/30/06, 06:41:26

Ce courrier et toute pièce jointe qu'il contient sont réservés au seul destinataire indiqué et peuvent renfermer des renseignements confidentiels et privilégiés. Si vous n'êtes pas le destinataire prévu, toute divulgation, duplication, utilisation ou distribution du courrier ou de toute pièce jointe est interdite. Si vous avez reçu cette communication par erreur, veuillez nous en aviser par courrier et détruire immédiatement le courrier et les pièces jointes. Merci.
******************************************************************************
 =============================================================================