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:Multiple Dataset Options
When multiple dataset options are applied to a single statement, then the order of execution matters. The rule of thumb is that they are executed according to the lexicographical(alphabetical) order of their names. That is, a drop option is executed before a keep, and a keep before a rename. A logical consequence is that you have to use the old (before being renamed) variable names in your keep and drop options. Another is that you cannot keep a variable, if dropped.
Now, given also that the variable number is decided by the order of first-appearance in the data step, can you guess the output of the code snippet below? The answer can be found in the discussion page.
data one; set sashelp.class(rename=(name=eman) keep=age sex name drop=age); run; /* check */ proc contents data=one varnum; run;
Submitted by Chang Y. Chung. Contact me at my Discussion Page.