topic Change value of a string variable while using retain statement? in SAS Programming

Change value of a string variable while using retain statement?

wetman — Wed, 07 Dec 2022 02:39:36 GMT

Hi all,

I'm having trouble trying to assign a value to a string variable while using the retain statement.

I can retain a numeric variable while still being able to assign a new value to it, so that the value is continously evolving while going through each observation, as shown in the below simplified example with the variable "num".

But when I try to do the same with a characteristic variable, the variable seems to have been frozen to its initial value, which in this case, is "Test:".

Data test;
	Length str $ 100;
	retain num 0;	retain str "TEST:";
	set Sashelp.buy;
	if AMOUNT < -1000 then do;
		num = num + 1;
		str = str || "T";
	end;
	else str = str || "F";
run;

The final outcome I'm trying to get is something like: "Test:TFFTTTTTTTF", in the last observation. However this is what I get at the moment using the above code.

The length command in the code was to show that the issue is not caused by issue with length of the string variable.

Thanks!

Re: Change value of a string variable while using retain statement?

mkeintz — Wed, 07 Dec 2022 03:03:57 GMT

The operator "||" does NOT pre-trim the contents of its arguments. So the statement

		str = str || "T";

essentially constructs at string of 101 bytes length (100 for str, and 1 for "T"). It then truncates all characters beyond number 100. Consider using

str=trim(str) || "T";

str=cats(str,"T");

Re: Change value of a string variable while using retain statement?

wetman — Wed, 07 Dec 2022 03:08:23 GMT

Thank you so much! I tried both solutions and they all work for me!