Date:         Wed, 29 Oct 2003 12:02:48 -0800
Reply-To:     Art <artshen@HOTMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Art <artshen@HOTMAIL.COM>
Organization: http://groups.google.com
Subject:      How to deal with column name with a space in SAS SQL
Content-Type: text/plain; charset=ISO-8859-1

Hi,
  I need to create a SAS dataset from a SQL Server table. However, the
column headers of that table have space in it. eg. [customer
number],[customer name]. In SQL server itself, you can put column name
between "[" and "]" . But it doesn't work in SAS code. Anyone has the
same problem and have it solved?

/****the following code doesn't work *****/
proc sql;
  create table tab1
  as
  select cust.[customer number], cust.[customer name]
  from cust;
quit;



Thanks

Art