Prev: Date Time Informat Query
Next: Put with @ column pointer
From: Gary on 18 Mar 2010 04:33
Hi all,

I have a char variable with length 32, format and informat $32.

Essentially, I am trying to create a flag based on the value of this
variable. However, whilst I can clearly see that there are values
which should be flagged, SAS can't seem to pick them up.

I have used functions like strip and compress, but to no avail. There
seems to be something else rather than blank spaces that's trailing
the value, but are clearly not visible.

Does anyone have ideas on what else I should try?

Thanks,
G
From: Patrick on 18 Mar 2010 05:09
Compress together with appropriate modifiers should do the job:
http://support.sas.com/onlinedoc/913/getDoc/en/lrdict.hlp/a000212246.htm

I believe the following should remove all non visible whitespace
characters:
VarPrintableChars=compress(variable, ,'kw');

If this doesn't help then the issue must be somewhere else and you
should post your code and log.

HTH
Patrick
 | 
Pages: 1
Prev: Date Time Informat Query
Next: Put with @ column pointer