Date: Thu, 24 May 2007 22:44:35 -0700
Reply-To: David L Cassell <davidlcassell@MSN.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: David L Cassell <davidlcassell@MSN.COM>
Subject: Re: How can I make a Set Statement with an "Iterative Read" of
Content-Type: text/plain; format=flowed
>Greetings (again), I've been busting my brain over this one. There is
>probably a very easy fix. How can I read in the first observation from
>the "INSET" dataset on the first iteration of the %DO loop and the
>second observation on the second ineration and so on?
>%macro process (it=);
>%do n=1 %to ⁢
>data temp ; set inset (firstobs=???) ;
>if flag_combo='Y' and flag_freq='Y' then do;
> call symput("pricepoint",
>data logit.upholstery_regression; set test_set;
>category = "&prodcategory" and pricepoint = "&pricepoint"
>&categorypricepoint = 1; else &categorypricepoint = 0;
>data %process (it=4);run;
IIRC, you have 1.6 millions records. So you really don't want a macro loop
that will slow things down even more.
I am just not sure what you're after based on your code, but it looks like
you would be better off carefully explaining what you really want to do,
It looks like you might be a lot better off with a hash in a data step, or
perhaps a SQL solution.
David L. Cassell
3115 NW Norwood Pl.
Corvallis OR 97330
Catch suspicious messages before you open themówith Windows Live Hotmail.