Is there a sas function that can conactenate all members of a temporary character array using a given seperator? Something like CatX(" ", of myArr) but this doesn't work. Here is a sample code of what I want to accomplish using some function.
Data _null_;
Array myArr {4} $ _temporary_ ("A" "B" "C" "D");
Length catResult $100;
catResult="";
Do i=1 to dim(myArr);
catResult=CatX(" ", catResult,myArr{i});
End;
Put catResult;
Run;
Thanks
Is this you are after?
Data _null_;
Array myArr {4} $ _temporary_ ("A" "B" "C" "D");
Length catResult $100;
catResult="";
/* Do i=1 to dim(myArr);*/
catResult=CatX(" ", of myArr{*});
/* End;*/
Put catResult;
Run;
Haikuo
Is this you are after?
Data _null_;
Array myArr {4} $ _temporary_ ("A" "B" "C" "D");
Length catResult $100;
catResult="";
/* Do i=1 to dim(myArr);*/
catResult=CatX(" ", of myArr{*});
/* End;*/
Put catResult;
Run;
Haikuo
What version of SAS are you using? This should work with temp array V9.2+
catResult=CatX(" ",of myArr{*});
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.