Can parameters be used in a query?

[dbdinc]

Can you use parameters in a query?
Posted: May 16, 2007 11:49 AM
I know parameters can be used in the WHERE and GROUP portions of a query, but am wondering:

Can parameters be used in the "CREATE TABLE..." part of a query, like in the following piece of code:

CREATE TABLE HFA987A AS SELECT
EMPLOYEE.CAMPUS FORMAT=$63.,
&requestingcollege AS REQUESTING_COLLEGE format=$4.,
EMPLOYEE.CAMPUS_DESC FORMAT=$255.,
EMPLOYEE.COLLEGE FORMAT=$63.,

What I am trying to do is to incorporate my parameter data into my table being created. If anyone has an idea or two on how to do this, I would really appreciate hearing from you. Thanks in advance!

 

[ChrisW75]

Yes, you can do this, but add double quotes around the parameter if it is a text field.

Chris
Business Analyst, Code Monkey, Data Wrangler.
SAS Guru.

 

[dbdinc]

Thanks, Chris,

I already got that solution from other sources, but do appreciate you replying. I jusdt couldn't wait several days and therefore researched other sources of information.