About GA_Mike

GA_Mike · ‎06-10-2014

Ok. I found the reason for cats(count(*)) in my notes. If I only used count(*) in the third PROC SQL the definition of the macro variable RV errors due to leading spaces. proc sql; select DISTINCT RV into :RV1-:RV&MAXRV. <-- So right here instead of resolving to into :RV1-:RV10 it does this into :RV1-:RV 10 and errors. from work.tempRV; quit;

GA_Mike · ‎06-10-2014

They do run if they are outside of the macro. work.tempRV does contain records. I can't remember why I switched from count(*) to cats(count(*)). There was something in the data that was causing an issue and that is how I resolved it. By similar what I mean is that I changed the permanent library names to 'work' just to try to avoid confusion.

GA_Mike · ‎06-10-2014

Hello, My code looks similar to this: %Macro CFT(PGM,ID); PROC SQL; CREATE TABLE work.tempRV AS SELECT DISTINCT RV from work.SPECS a WHERE a.Revision = &ID.; PROC SQL; SELECT cats(count(*)) into :MAXRV FROM work.tempRV; proc sql; select DISTINCT RV into :RV1-:RV&MAXRV. from work.tempRV; quit; %Mend; When the macro is called, the first PROC SQL runs as expected but the second and third do not execute. Any help would be greatly appreciated. Thanks,

Online Status	Offline
Date Last Visited	‎05-01-2018 11:45 AM

Re: Problem using PROC SQL within a Macro

Re: Problem using PROC SQL within a Macro

Problem using PROC SQL within a Macro

Re: Problem using PROC SQL within a Macro

Re: Problem using PROC SQL within a Macro

Problem using PROC SQL within a Macro

SAS Global Forum 2018