Hi All,
While executing the below query i have got an error as shared in the snapshot. Please let me know where the query had went wrong
QUERY:
PROC SQL; SELECT COUNT(DISTINCT(AUTHORIZEDBY)) INTO: CNT FROM INTIAL; SELECT DISTINCT(AUTHORIZEDBY) INTO : AUT1-: %SYSFUNC(COMPRESS(AUT&CNT)) FROM INTIAL; QUIT; %PUT &AUT1; options MPRINT MLOGIC MERROR SYMBOLGEN;
%MACRO MAI;
%DO I=1 %TO 1; PROC SQL;
CREATE TABLE FIRST AS SELECT DISTINCT(CLOSED_ON), COUNT(CASE WHEN compress(AUTHORIZEDBY)="&AUT&I." THEN 1 END)AS "&AUT&I." FROM INTIAL GROUP BY CLOSED_ON ;
QUIT; %END; %MEND; %MAI;
... View more
