As the first step in the decommissioning of the site has been converted to read-only mode.

Here are some tips for How to share your SAS knowledge with your professional network.


From sasCommunity
Jump to: navigation, search


Welcome to

A collaborative online community for SAS® users worldwide. is an ongoing global community effort—created by SAS users for SAS users. This site is a place to find answers, share technical knowledge, collaborate on ideas and connect with others in the worldwide SAS Community. Get started now by creating a UserID.

Follow Us
For daily SAS Tips, Web updates & more.


sasCommunity Blogs

Recent SAS user blog entries:

...view more

sasCommunity Content

Recent articles:

...view more
...create an article

run;submit Questions:

Top SAS user questions on

...view more

SAS Discussion Forums

Top SAS user threads on

...view more

sasCommunity Tip of the Day

As part of the decommissioning effort for this article/tip has been migrated to

The new home for this article/tip is LainieH/sandbox10/main (

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;
    %else %do;
        %let result = 0;
        %put NOTE: Var &var not exists in &ds;
    %let rc = %sysfunc(close(&dsid));
%mend VarExist;
/* Usage */
%put %VarExist(sashelp.class, name);
%put %VarExist(sashelp.class, aaa);

Submitted by Adrien VALLEE. Contact me at my Discussion Page.

Feel free to comment on this tip.

Check out the Tip of the Day page for details about this effort.

Featured Members

imagine modified list with just image and name Recent contributors appear at top of the list. Opt in to appear on list.

9,514 UserIds have been created on!
View the Web-site usage statistics and the definition of terms.

Join Get Involved Sasopedia Events User Groups