DATA Step, Macro, Functions and more

substr function

Reply
Contributor
Posts: 30

substr function

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

Super User
Posts: 17,840

Re: substr function

[ Edited ]

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


 

Super User
Super User
Posts: 7,407

Re: substr function

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.

Ask a Question
Discussion stats
  • 2 replies
  • 120 views
  • 0 likes
  • 3 in conversation