sas dis - Conditionally skip transformations in SAS DIS -
i wondering if possible use conditional start transformation in sas dis conditionally bypass transformation based on whether given table empty (no rows). this link seems indicate condition must based on value of parameter variable.
one idea had create parameter value in user written code transformation, , assign different values depending on state of table, seems elaborate , inelegant, , i'm not sure work. there simpler way?
much gratitude
to done without adding user written transformation , perhaps elegantly can try use. first, copy numobs macro posted @cmjohns ( https://stackoverflow.com/a/5664379/4653284 ) , add precode of jobflow. after go starting transformation needs skipped based on observation , right click properties tab of transformation. goto "precode , postcode" tab , add following code:
%macro dummy; %if %nobs(&syslast) gt 0 %then %do;
after done, goto transformation last transformation skipped basis observation count , right click properties of transformation , goto precode postcode tab , add following code:
%end; %mend dummy; %dummy;
if 1 transformation needs skipped can add post code , precode provided above in same precode , post code tab of single transformation skip based on observation count.
note: sas di studio 4.8 has conditional transformations can solve same problem. di studio version before have code conditional exclusion of transformation(s).
Comments
Post a Comment