This tutorial explains how to store macro variable values to a data set in SAS.
The following SAS macro selects the names of numeric columns from the SASHELP.CLASS dataset, stores them in a list and then outputs the list to a dataset named "output".
%macro storemacroval; proc sql noprint; select name into: nvar separated by " " from dictionary.columns where LIBNAME = "SASHELP" and MEMNAME = "CLASS" and type = "num"; quit; %let cntvar = %sysfunc(countw(&nvar)); data output; length List $ 32; %do i=1 %TO &cntvar.; %let varN =%scan(&nvar,&i); List = "&varN"; output; %end; run; %mend; %storemacroval;
Share Share Tweet