recreating a few SAS functions (COMPRESS, CAT, STRIP, TRANWRD) in alteryx

Question

I am trying to figure out what this does in sas so I can replicate it in alteryx.

COMPRESS(CAT(STRIP(n_Attribute_Name),TRANWRD(STRIP(n_Value),STRIP(n_Attribute_Name),"")),"_","KAD")

Here is sample data:

n_Attribute_Namen_ValueApp BOR IDLSTEVENS4RoleRole=88853369 - CSS CSRappUserNameLouis Stevens

Is there a way to replicate the functionality above in alteryx?

Thanks.

Robin_McIntosh · Answer

@wonka1234 - Does this answer your question/solve your issue?

binu_acs · Answer

@wonka1234 similar to @Robin_McIntosh solution

SAS_Funtions_27_06.yxmd

Robin_McIntosh · Answer

Based on the sample data and SAS expression above, the output would be this (new_field).

Within the TRANWRD function, the intent is to keep (modifier K) any underscores "_" and all alphanumeric digits (modifiers AD).

I added lines with underscore to show the SAS result of COMPRESS.

Here's a workflow with two routes to get the same result as SAS.

Discussion_SAS_Convert.yxmd