topic missing letters in SAS Programming

missing letters

znhnm — Wed, 28 Dec 2022 17:08:30 GMT

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

Re: missing letters

sbxkoenk — Wed, 28 Dec 2022 17:13:54 GMT

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

Re: missing letters

znhnm — Wed, 28 Dec 2022 17:50:36 GMT

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?

Re: missing letters

sbxkoenk — Wed, 28 Dec 2022 18:01:10 GMT

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

Re: missing letters

znhnm — Wed, 28 Dec 2022 18:11:15 GMT

Hi Koen,

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