missing letters

[znhnm]

Hi,

I am creating a new column called "group" in my dataset based on the value of another column. The real code I run has many more if conditions but the "group" column has only 3 values; indeterminate, not performance, performance. 

In the output, I have "not performan" rather than "not performance". Why do I have the last 2 letters dropped and how do I fix it?

data mydata;
set mydata;
	if reason = "asd asd asd" then group = "indeterminate";
	if reason = "abc abc abc" then group = "indeterminate";
	if reason=" xxx" then group="not performance"; 
    if reason=" yy " then group="performance"; 
	 else cancellation_grouping = "other";
run;

Thanks

[sbxkoenk · Accepted solution]

Hello,

Length of GROUP variable is decided upon when GROUP gets its first value.

If first value assigned is 'ABC' then length becomes 3 and all other values (assigned later) are truncated as from the 4th position.

You can change the way length is determined by explicitly specifying the length yourselves for GROUP variable, like here :

data mydata;
 LENGTH group $ 15;
 set mydata;
	if reason = "asd asd asd" then group = "indeterminate";
	if reason = "abc abc abc" then group = "indeterminate";
	if reason=" xxx" then group="not performance";     if reason=" yy " then group="performance"; 
	 else cancellation_grouping = "other";
run;
/* end of program */

Koen

[znhnm]

Hello, thank you so much!

When I try it, I have an error saying:

Expecting an arithmetic operator.

What could be the reason of it?

[sbxkoenk]

Hello,

Can you post the LOG?

Copy the LOG , click on the </> icon in the toolbar on top when replying , then paste LOG in pop-up window!

Also, you might want :

if ; else if ; else if ; else if ; else ;

instead of 4 times if + an else ?

Thanks,

Koen

[znhnm]

Hi Koen,

I realized that I made a typo. Sorry about it. Your suggestion works perfectly. Appreciated your help!