SAS: Storing Macro Variable Values to a Dataset

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;

Spread the Word!
Share Share Tweet

About Author:
Deepanshu Bhalla

Deepanshu founded ListenData with a simple objective - Make analytics easy to understand and follow. He has over 10 years of experience in data science. During his tenure, he worked with global clients in various domains like Banking, Insurance, Private Equity, Telecom and HR.

While I love having friends who agree, I only learn from those who don't
Let's Get Connected Email LinkedIn

SAS: Storing Macro Variable Values to a Dataset

Post a Comment