Date:         Tue, 6 Jan 2004 11:05:06 +0000
Reply-To:     Graeme.Kirton@FILCS.COM
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Graeme Kirton <Graeme.Kirton@FILCS.COM>
Subject:      Proc SQL :list help
Content-type: text/plain; charset=us-ascii

Hi folks, I've an SQL question.

I've created a macro list:

4020   %put parm_list=&parm_list;

parm_list=Cds_PM_RF, Cgd_PM_RF, Cgs_PM_RF, Cpd_PM_RF, Cpg_PM_RF,
Gmax02_PM_RF, Gmax10_PM_RF,
Gmax20_PM_RF, Gmax30_PM_RF, Id_PM_RF, Ig_PM_RF, Lpd_PM_RF, Lpg_PM_RF,
Lps_PM_RF, MERR, Rd_PM_RF,
Rds_PM_RF, Rg_PM_RF, Ri_PM_RF, Rs_PM_RF, Vd_PM_RF, Vg_PM_RF, Vp_PM_RF, Zg,
fK_PM_RF, fT1_PM_RF,
g21_1_PM_RF, gm0_PM_RF, tau_PM_RF

I want to create a dataset with parameters based on this list.

proc sql feedback noprint;
select parameter into :parm_list separated by ', '
from limits.cl010_limsrf;
create table selecter as
select X,Y,&parm_list
from datapart;
quit;

Problem is, if any of the parameters in the list arn't in the dataset
"datapart" it errors out and doesn't create the output table "selecter"

ERROR: The following columns were not found in the contributing tables:
Cpd_PM_RF, Cpg_PM_RF,
       Lpd_PM_RF, Lps_PM_RF, MERR, Vp_PM_RF.

Is there a way round this, or another way???????????

Any help? Appreciated.

Thanks

--------------------------------------------------------------
Graeme Kirton
IT Developer
Filtronic Compound Semiconductors Ltd



"IMPORTANT NOTICE

This email may contain confidential information and will be protected by
copyright.
It is intended only for the use of the person(s) to whom it is addressed
and any unauthorised
use (including forwarding or dissemination the contents) may be unlawful.
If you receive this email by mistake, please advise the sender immediately
by using the reply facility on
  your email software and delete the email from your computer.

Opinions, conclusions and other information in this email that do not
relate to the official business
of this organisation shall be understood as neither given nor endorsed by
it.

If this message forms part of a quotation for the supply of goods, the
quotation is an invitation to treat only.   No contract will come into
effect until the Company issuing such quotation (or Filtronic plc or one of
its subsidiaries on its behalf) issues an acknowledgment of order for the
supply of such goods.  The contract will be on the terms of such
acknowledgment of order.


Website address: http://www.filtronic.com"