Date:         Thu, 11 Jan 2007 12:32:59 -0500
Reply-To:     Wensui Liu <liuwensui@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Wensui Liu <liuwensui@GMAIL.COM>
Subject:      Re: Remove a format via proc sql
Comments: To: Wing9897@hotmail.com
In-Reply-To:  <1168536552.473248.45730@p59g2000hsd.googlegroups.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed

I think SAS says what it means.
you need to put a format after format = .

On 1/11/07, Wing9897@hotmail.com <Wing9897@hotmail.com> wrote:
> Hello, how would one remove a format from a variable within proc sql
> and not within a data step?
>
> The code below gives the error: " Expecting a format name"
>
> proc sql;
> select PersonID Format=, PersonID from v.junk;
> quit;
>
> Thanks.
>


--
WenSui Liu
A lousy statistician who happens to know a little programming
(http://spaces.msn.com/statcompute/blog)