topic how to change the length of the variable for multiple datasets? in SAS Programming

how to change the length of the variable for multiple datasets?

Babloo — Wed, 23 Jan 2019 11:06:03 GMT

Appericiate if someone of you guide me with the program to change the length of the variable for multiple datasets from one library?

Assume the variable name is ID (numeric) and it has different lengths and this variable is located in multiple datasets and those datasets are in one library. Now I want to change the length of ID variable to 8 in all the datasets from all those libraries in one shot.

Re: how to change the length of the variable for multiple datasets?

PeterClemmensen — Wed, 23 Jan 2019 11:38:50 GMT

You would have to recreate every relevant data set. Once a variable length is set, it can not be changed.

How do you know which data sets you want to perform this action for?

Re: how to change the length of the variable for multiple datasets?

Kurt_Bremser — Wed, 23 Jan 2019 11:39:15 GMT

ID variables should not be kept as numbers, but as character.

Anyway, you find the datasets by searching for the variable name in sashelp.vcolumn, and create the code from that with call execute().

Re: how to change the length of the variable for multiple datasets?

Reeza — Wed, 23 Jan 2019 15:45:15 GMT

1. Figure out how to do it for one data set

2. Find the list of all data sets you need to do this to (been answered in previous questions)

3. Use CALL EXECUTE to run it for every data set needed.

Example of turning this into a macro is here:

https://github.com/statgeek/SAS-Tutorials/blob/master/Turning%20a%20program%20into%20a%20macro.md

If you need further help post your code.

@Babloo wrote:

Appericiate if someone of you guide me with the program to change the length of the variable for multiple datasets from one library?

Assume the variable name is ID (numeric) and it has different lengths and this variable is located in multiple datasets and those datasets are in one library. Now I want to change the length of ID variable to 8 in all the datasets from all those libraries in one shot.

Re: how to change the length of the variable for multiple datasets?

ErikLund_Jensen — Wed, 23 Jan 2019 17:56:53 GMT

Hi Babloo

I Think the following macro does the trick. It changes datasets overwriting the original datasets. Write me back if you have any questions.


%macro changelength(folder);
	* Assign folder as TMP-library;
	libname tmp "&folder";

	* Get content of TMP-library;
	proc contents data=tmp._all_ out=w noprint;
	run;

	* Get member names - only members where variable ID exists as numeric with length not 8;
	proc sql noprint; 
		select distinct memname into :memlist  separated by ' ' from w 
		where lowcase(name) = 'id' and type = 1 and length ne 8;
	quit;

	* Copy to same member, Length statement PRECEDES Set statement to change length;
	%do i = 1 %to &sqlobs;
		%let mem = %scan(&memlist,&i,%str( ));
		data tmp.&mem; length id 8; set tmp.&mem; 
		run;
	%end;

	libname tmp clear;
%mend;
%changelength(c:\tmp);
%changelength(c:\etc);