Date:         Tue, 24 Sep 2002 14:45:46 +0200
Reply-To:     Jim Groeneveld <J.Groeneveld@ITGROUPS.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Jim Groeneveld <J.Groeneveld@ITGROUPS.COM>
Subject:      Re: 4GL manual? and a question on variable
Comments: To: zbiggy <zbiggy@poczta.onet.pl>
Content-Type: text/plain

Hi Zbig,

I ment my second proposal (in which I also explicitly asked for your name)
in which you could either refer to &&Country&I for your text values, or to
&Country (corresponding to a certain &I in a loop). Thus while you have
numeric &I's you at the same time have the country codes, referred to as the
country list with a numeric index, somewhat similar to an array (that is why
my first method als is called a "macro array", which officially does not
exist).

There is even a third method if you accept combined macro and data step
code:

%LET Countries = 'UK', 'US', 'SK', 'FR';

DATA Country;
   DO Country = &Countries; * Refer to single country as Country;
      OUTPUT;
   END;
RUN;

PROC PRINT DATA=Country; RUN;

Regards - Jim.
--
Y. (Jim) Groeneveld, MSc    IMRO TRAMARKO         tel. +31 412 407 070
senior statist./data man.   P.O. Box 1            fax. +31 412 407 080
J.Groeneveld@ITGroups.com   5350 AA BERGHEM, NL   www.imrotramarko.com

My computer does what I tell it to do; I do tell myself to believe that.

Notice of confidentiality: this e-mail may contain confidential information
intended for the addressed recipient only.
If you have received this e-mail in error please delete this e-mail and
please notify the sender so that proper delivery
can be arranged.

> -----Original Message-----
> From: zbiggy [SMTP:zbiggy@poczta.onet.pl]
> Sent: Tuesday, September 24, 2002 2:19 PM
> To:   Jim Groeneveld
> Subject:      Re: 4GL manual? and a question on variable
>
> Hello Jim,
> I tested your proposal and my prediction came true: what I got iterating
> is
> numbers 1 - &M  and I would rather have strings 'US', "UK', 'PL'
>
> I have invented another way of bypassing my problem: in MS Excel, 1 column
> with the country abbreviations and one with formula including them into
> the
> "proc sql".
> Then copy and paste it to the EG :)) and it works (I tried)
>
> Regards
> Zbig
>
>
> ----- Original Message -----
> From: "Jim Groeneveld" <J.Groeneveld@ITGroups.com>
> To: "'zbiggy'" <zbiggy@poczta.onet.pl>
> Sent: Tuesday, September 24, 2002 1:45 PM
> Subject: RE: 4GL manual? and a question on variable
>
>
> Hi Zbig,
>
> All right, thanks, your name initially looked like some fake name as well.
> I
> did not know you could post with a fake email address. Isn't there some
> check, verifying your (valid) email address before able to post to
> newsgroups?
>
> Could you use one of my suggestions for "numbering" the country codes and
> looping through them?
>
> Regards - Jim.
> --
> Y. (Jim) Groeneveld, MSc    IMRO TRAMARKO         tel. +31 412 407 070
> senior statist./data man.   P.O. Box 1            fax. +31 412 407 080
> J.Groeneveld@ITGroups.com   5350 AA BERGHEM, NL   www.imrotramarko.com
>