Date: Fri, 2 Mar 2007 10:24:27 -0600
Reply-To: SAS_learner <proccontents@GMAIL.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: SAS_learner <proccontents@GMAIL.COM>
Subject: How to create multiple macros using Into : operator ??
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
I am trying to rewrite some part of code in sql for example but I don not
get what is wrong with SQL code , by the way in the process of writing code
I have noticed that I can't use distinct in second part of sql statement
proc sql ;
select pt , distinct ( itt) .................
at this point SAS complains about distinct part why ??
set derive.header (keep = itt);
where &population = '1';
proc freq data=header noprint;
tables itt / missing out=freq0(keep=itt count );
call symput("atot1","(N = "||trim(left(put(count,3.)))||")");
%put &tot1 ;
713 proc sql noprint ;
714 select distinct(count(itt)) as itt_t ,
NOTE: SCL source line.
715 "(N= "!!caliculated itt_t !!")"
ERROR 22-322: Syntax error, expecting one of the following: !, !!, &, (, *,
**, +, ',', -, '.', /, <, <=, <>, =, >, >=, ?,
AND, BETWEEN, CONTAINS, EQ, EQT, GE, GET, GT, GTT, LE, LET,
LIKE, LT, LTT, NE, NET, OR, ^=, |, ||, ~=.
ERROR 76-322: Syntax error, statement will be ignored.
716 into : tot1_test ,
717 : atot1_test
719 from derive.header
720 where &population = '1' ;
SYMBOLGEN: Macro variable POPULATION resolves to itt
722 %put total is &tot1_test ;
SYMBOLGEN: Macro variable TOT1_TEST resolves to 161
total is 161
723 %put total_n is &atot1_test ;
WARNING: Apparent symbolic reference ATOT1_TEST not resolved.
total_n is &atot1_test
724 quit ;
Thanks for help