About Andy891

Andy891 · ‎07-20-2022

Hi Tom, Many thanks for your quick reponse. I try to give more details I´ve made this simplified version (the goal program perform different task, I´ve tried to make an example easier) of goal.sas and I put into the macro, the objective is from example dataset use the variables to filter one different dataset and then append to one which contain the data validated. I understand your approach but I´m doing something wrong defining the macro (I´m not a user of macro language) %macro goal(code); CREATE TABLE Append_dataset AS SELECT Global.*, FROM SAS.Global WHERE Global.Code = "&CODE"; QUIT; proc append base=SAS.Global_ok data=Append_dataset force; run; %mend ; Could you kindly check what it´s wrong with the syntax? P.S It´s possible to achieve the same solution using this approach+ another piece of code? proc sql noprint; select code into :varname1- from example; %let nrows=&sqlobs; quit; Thanks for your help!

Andy891 · ‎07-19-2022

Dear Community, I have the following dataset in SAS (let´s call Example) Code abh45d bno873r 132gbv4 cvb67f3 xw32nu7 722gbv5 ilk89f7 qwe12d4 rhg73k98a For each code on the dataset I need to run a SAS Program (let´s call goal.sas) which use the variable &code to run. What I have thought was first define a list of variables options mprint; %macro varlist; data _NULL_; if 0 then set WORK.Example nobs=n; call symputx('nrows',n); stop; run; %put nobs=&nrows; proc sql noprint; select variables into: varname1-:varname&nrows from WORK.Example ; quit; %do i = 1 %to &nrows; %global &&varname&i; %end; %mend varlist; %varlist; And once I have defined the list make a loop for each variable contained in example call goal.sas (take into consideration that goal.sas need to use &code as a parameter) Many thanks for your help

Online Status	Offline
Date Last Visited	‎07-21-2022 06:17 AM

Re: LIST VARIALES+LOOP?

LIST VARIALES+LOOP?

Re: LIST VARIALES+LOOP?

LIST VARIALES+LOOP?