SAS | Cookbook

Handling data

Split fields

%let _TMPLIB=%scan(&_TMPDSN., 1, '.');
%let _TMPTAB=%scan(&_TMPDSN., 2, '.');

Data Cleaning

Filter out by value of an entry

if prxmatch('/^(TST|TEST|ek-test-)/', USERNAME) then
   output &_TSTDSN.;            
else
   output &_OUTDSN.;