Date: Tue, 6 Jan 2004 11:05:06 +0000
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,
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,
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 ', '
create table selecter as
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:
Lpd_PM_RF, Lps_PM_RF, MERR, Vp_PM_RF.
Is there a way round this, or another way???????????
Any help? Appreciated.
Filtronic Compound Semiconductors Ltd
This email may contain confidential information and will be protected by
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
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"