table name contains period causing errors

[jayvisw11]

Hi,

I am trying to run a query to join two tables in a database using proc fedsql. One of the column names in table1 contains period (column name: event.eventid). While trying to run the query this I am seeing an error that event table is not found in from clause where as the table name is table1. Can anyone help me with resolving this issue? Thank you!

[Reeza]

Try referencing it using this type of notation:

"event.eventid"n or can you run a proc contents on the file to see how SAS is displaying that name?

[jayvisw11 · Accepted solution]

I tried to run using the name literal too but it didn't work. Finally, typing the column name within ' ' worked for me. Thank you!

[jayvisw11]

Small correction to my above comment, typing the column name within " " worked for me. Thank you!