topic Re: dynamic variable naming in SAS Programming

dynamic variable naming

capam — Wed, 18 Oct 2017 14:27:37 GMT

I wish to dynamically name a variable 'leakersN' in the code below. what is the proper code structure for dynamically naming a variable?

%let RN = 3725;
%put RN = &RN;

data has;
	set has;

	if FAULT_CODE = '20-2018' and VEHICLE_NO = "&RN" then
		leakers'&RN' = count(FAULT_CODE,'20-2018');
run;

Re: dynamic variable naming

error_prone — Wed, 18 Oct 2017 14:36:38 GMT

Try leakers&RN = count...

Re: dynamic variable naming

RW9 — Wed, 18 Oct 2017 14:38:15 GMT

Could you give a more concrete example? Dataset structure should remain constant - this is how we are able to program on the data. There is some flexibility in terms of arrays of variables, but rarely will you come across a need to have a column dynamic like that.

Re: dynamic variable naming

capam — Wed, 18 Oct 2017 15:20:30 GMT

Thanks. A simple solution that works.

Re: dynamic variable naming

ballardw — Wed, 18 Oct 2017 22:29:31 GMT

Kind of convoluted way to a value of 1 to a variable...