Date: Thu, 12 Mar 2009 21:37:37 -0400
Reply-To: Gordon Cox <gordon.cox@GMAIL.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Gordon Cox <gordon.cox@GMAIL.COM>
Subject: Re: select into with quotes
In-Reply-To: <6A5C8013-A4B7-4148-A8A5-8D39C61980DF@gmail.com>
Content-Type: text/plain; charset=us-ascii; format=flowed; delsp=yes
Select quote(variable) into :macrovar
Paper by john zhang on into:host. Sorry can't paste link from phone.
Sorry if this is a redundant/unusable answer.
>
>
> On Mar 12, 2009, at 7:47 PM, Dianne Rhodes
> <diannerhodes@COMCAST.NET> wrote:
>
>> Actually, what I wanted to do was create a macro variable from a
>> select from
>> a lookup table. There are only 218 accounts and they can be in many
>> different groups, with overlaps. It is pretty interesting what
>> comes over
>> the fax machine sometimes. "We are not able to finance your mortgage
>> because we could not substantiate your 11,000 a month income."
>> What the
>> heck are they buying?
>>
>>
>>
>> Dianne
>>
>>
>>
>> _____
>>
>> From: Mary [mailto:mlhoward@avalon.net]
>> Sent: Tuesday, March 10, 2009 5:40 PM
>> To: ./ ADD NAME=Data _null_;; SAS-L@LISTSERV.UGA.EDU;
>> diannerhodes@COMCAST.NET
>> Subject: Re: Re: select into with quotes
>>
>>
>>
>> Data Null,
>>
>>
>>
>> Yes, I'm getting better at that; thanks for noticing!
>>
>>
>>
>> Considering Dianne works at Freddie Mac, if her IN clause is the
>> two million
>> people seeking refinancing or something like that, all of those
>> people might
>> not fit into a macro variable...
>>
>>
>>
>> -Mary
>>
>> ----- Original Message -----
>>
>> From: ./ ADD NAME=Data <mailto:iebupdte@GMAIL.COM> _null_;
>>
>> To: SAS-L@LISTSERV.UGA.EDU
>>
>> Sent: Tuesday, March 10, 2009 4:30 PM
>>
>> Subject: Re: select into with quotes
>>
>>
>>
>> On 3/10/09, Mary <mlhoward@avalon.net> wrote:
>>> Why not simply create your IN clause as a select from the other
>>> table?
>>
>> Thank you for providing the correct answer not just the answer to the
>> question.
| 
