topic Re: table name contains period causing errors in New SAS User

table name contains period causing errors

jayvisw11 — Fri, 22 Oct 2021 15:39:29 GMT

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!

Re: table name contains period causing errors

Reeza — Fri, 22 Oct 2021 16:09:36 GMT

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?

Re: table name contains period causing errors

jayvisw11 — Fri, 22 Oct 2021 20:48:46 GMT

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!

Re: table name contains period causing errors

jayvisw11 — Mon, 25 Oct 2021 17:06:00 GMT

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