topic Re: Search for datasets to merge in SAS Programming

Search for datasets to merge

TobbeNord — Fri, 17 May 2019 11:41:38 GMT

I have many datasets with the pattern:

T19AA032FELMOVETIMEACTIVITY
T19AA042FELMOVETIMEACTIVITY
T19AA052FELMOVETIMEACTIVITY
T19AA062FELMOVETIMEACTIVITY
T19AA072FELMOVETIMEACTIVITY
T19AA082FELMOVETIMEACTIVITY
T19AA092FELMOVETIMEACTIVITY
T19AA102FELMOVETIMEACTIVITY
T19AA112FELMOVETIMEACTIVITY
T19AA122FELMOVETIMEACTIVITY
T9AA031RTTMOVETIMEACTIVITY
T9AA041RTTMOVETIMEACTIVITY
T9AA051RTTMOVETIMEACTIVITY
T9AA061RTTMOVETIMEACTIVITY
T9AA071RTTMOVETIMEACTIVITY
T9AA081RTTMOVETIMEACTIVITY
T9AA091RTTMOVETIMEACTIVITY
T9AA101RTTMOVETIMEACTIVITY
T9AA111RTTMOVETIMEACTIVITY
T9AA121RTTMOVETIMEACTIVITY

I want to merge the datasets pairwise as following:

T9AA031RTTMOVETIMEACTIVITY with T19AA032FELMOVETIMEACTIVITY

T9AA041RTTMOVETIMEACTIVITY with T19AA042FELMOVETIMEACTIVITY

T9AA051RTTMOVETIMEACTIVITY with T19AA052FELMOVETIMEACTIVITY

You probably see the pattern here, but how do I do this with hundreds of files in a smooth way?

Re: Search for datasets to merge

Onizuka — Fri, 17 May 2019 12:09:53 GMT

If they are named with just a number who changed, you can use a macro using a %DO loop :

Re: Search for datasets to merge

TobbeNord — Fri, 17 May 2019 12:24:23 GMT

I know that, but how?

I'm not used to working with dataset names, only with variables.

Re: Search for datasets to merge

Onizuka — Fri, 17 May 2019 12:30:14 GMT

For example for these 3 :

T9AA031RTTMOVETIMEACTIVITY with T19AA032FELMOVETIMEACTIVITY

T9AA041RTTMOVETIMEACTIVITY with T19AA042FELMOVETIMEACTIVITY

T9AA051RTTMOVETIMEACTIVITY with T19AA052FELMOVETIMEACTIVITY

%Macro merges ;

	%DO i = 3 %TO 5 ;

		Data table_merges_&i ;
			merge 
				T9AA0&i.1RTTMOVETIMEACTIVITY 
				T19AA0&i.2FELMOVETIMEACTIVITY 
			by yourvar ;
		run ;

	%END ;

%Mend merges

Re: Search for datasets to merge

TobbeNord — Fri, 17 May 2019 12:30:15 GMT

Okej, thank you, I can modify that a bit and make it work, I think.

Re: Search for datasets to merge

Onizuka — Fri, 17 May 2019 12:31:27 GMT

This is working if your datasets have the same name but just a number who is changing 🙂