Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

selecting fields with spaces and slashes

Status
Not open for further replies.

sap1958

Technical User
Oct 22, 2009
138
US
I am attempting to select some SAS fields. One has a space in it and one has a slash

proc sql;
create table project as
select Provider Number, Provider/Address
from Project1
quit;

How can I avoid the syntax errors when dealing with spaces and / (slashes) between field names
 
These should be no physical SAS columns, they look like column labels of a table view. Spaces, slashes etc are surely invalid (SAS) name characters. You have to get the column names and make the query, then it'll work.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top