Solved: compress(name,'!','A') ?

ybz12003 · Posted 06-30-2017 06:18 PM

Hello:

Could someone let me know what the '!' stand for? Thanks.

SASKiwi · Posted 06-30-2017 07:14 PM

This statement says remove all alphabetic characters plus exclamation marks from the variable NAME. Refer to the documentation:

http://support.sas.com/documentation/cdl/en/lefunctionsref/69762/HTML/default/viewer.htm#n0fcshr0ir3...

The second parameter lists the characters to remove, the third parameter modifies the list of characters to remove. It would be stating the obvious that removing all alphabetic characters from NAME doesn't make much sense.

View solution in original post

SASKiwi · Posted 06-30-2017 07:14 PM

This statement says remove all alphabetic characters plus exclamation marks from the variable NAME. Refer to the documentation:

http://support.sas.com/documentation/cdl/en/lefunctionsref/69762/HTML/default/viewer.htm#n0fcshr0ir3...

The second parameter lists the characters to remove, the third parameter modifies the list of characters to remove. It would be stating the obvious that removing all alphabetic characters from NAME doesn't make much sense.

Reeza · Posted 06-30-2017 07:21 PM

RTM.

http://documentation.sas.com/?cdcId=pgmmvacdc&cdcVersion=9.4&docsetId=lefunctionsref&docsetTarget=n0...

compress(name,'!','A') ?

Re: compress(name,'!','A') ?

Re: compress(name,'!','A') ?

Re: compress(name,'!','A') ?

compress(name,'!','A') ?

Re: compress(name,'!','A') ?

Re: compress(name,'!','A') ?

Re: compress(name,'!','A') ?

The 2025 SAS Hackathon has begun!

SAS Training: Just a Click Away