topic Re: substr function in SAS Programming

substr function

cho16 — Fri, 26 May 2017 04:03:17 GMT

Hi,

I have the table that has the column name as "ID". If the ID has 13 characters then it has to be blank. Below are some examples.

000709-W34
000709-W36
000709-W39
002028980-001
002028980-002
002028980-003

Output should be as below:

000709-W34
000709-W36
000709-W39

Thanks in Advance

Re: substr function

Reeza — Fri, 26 May 2017 04:23:51 GMT

I think you want the LENGTH and CALL MISSING functions.

Use length to check the length of the string and call missing to set it to missing, if desired.

Edit: Substr takes a portion of string, I'm not sure how your subject line relates to your question.

@cho16 wrote:

Hi,

I have the table that has the column name as "ID". If the ID has 13 characters then it has to be blank. Below are some examples.

000709-W34
000709-W36
000709-W39
002028980-001
002028980-002
002028980-003

Output should be as below:

000709-W34
000709-W36
000709-W39

.

.

.

Thanks in Advance

Re: substr function

RW9 — Fri, 26 May 2017 08:09:16 GMT

Post test data in the form of a datastep!!

So am just guessing that is a character string here:

data want;
  set have;
  result_var=ifc(lengthn(original_var)=13,".",original_var);
run;

Why would you want the resulting character string to be '.' anyways, that is for numeric data.