As the first step in the decommissioning of sasCommunity.org the site has been converted to read-only mode.
Here are some tips for How to share your SAS knowledge with your professional network.
Tips:Check if a variable exists in a dataset
From sasCommunity
Have you ever needed to know if a given variable is in a SAS data set? This macro returns 1 if a variable exists in a data set, and 0 if not.
%macro VarExist(ds, var); %local rc dsid result; %let dsid = %sysfunc(open(&ds)); %if %sysfunc(varnum(&dsid, &var)) > 0 %then %do; %let result = 1; %put NOTE: Var &var exists in &ds; %end; %else %do; %let result = 0; %put NOTE: Var &var not exists in &ds; %end; %let rc = %sysfunc(close(&dsid)); &result %mend VarExist; /* Usage */ %put %VarExist(sashelp.class, name); %put %VarExist(sashelp.class, aaa);
Submitted by Adrien VALLEE. Contact me at my Discussion Page.
