^=, |, ||, ~=.
=========================================================================
Date:         Wed, 19 Feb 2003 00:14:41 +0800
Reply-To:     conjecture <christopher@WEBMININGPRO.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         conjecture <christopher@WEBMININGPRO.COM>
Organization: IMS Netvigator
Subject:      Re: using macro in sas access to teradata ( Urgent !! )
Content-Type: text/plain; charset=us-ascii

I need to resolve a macro variable in the proc sql and run it in the
teradata. The example just a simple case for me to illutrate.


On Tue, 18 Feb 2003 09:39:33 -0600, Rodney Sparapani
<rsparapa@mcw.edu> wrote:

>statistics wrote:
>
>>proc sql;
>>      connect to teradata as gdw (user=xxx password=xxx tdpid=prd
>>database=PRDSTDVIEW);
>>
>>      execute(
>>      insert into prdcrmtemp.merch_spdg
>>      select d.posting_acct_nbr,a.merch_nbr
>>,a.event_activity_type_code,a.event_desc,
>>      case
>>              when upper(substr(a.event_desc,1,7)) in ('ULFERTS') and b.event_date
>>between '20020802' and '20020816' then ('ULFERTS_prec')
>>              when upper(substr(a.event_desc,1,7)) in ('ULFERTS') and b.event_date
>>between '20020817' and '20020831' then ('ULFERTS_camp')
>>              when upper(substr(a.event_desc,1,7)) in ('ULFERTS') and b.event_date
>>between '20020901' and '20020915' then ('ULFERTS_post')
>>      end as merch,
>>
>>a.event_amt_hke, b.event_date,  a.event_id
>>from  cr_card                 a,
>>      consumer                        b,
>>      cr_card_acct                    d
>>where a.event_id=b.event_id
>>
>>) by gdw;
>>      execute (commit) by gdw;