topic concatenating all observations in single in SAS Programming

concatenating all observations in single

forumsguy — Wed, 05 Jun 2013 08:45:20 GMT

Hi All,

Following is my dataset

data have;

input var1 $20;

cards;

robert

boss

;

run;

Now , i want to have one single macro variable which would resolve to robert is my boss

In short, I want to concatenate all obseervations in one single macro. Catch is not to use Proc sql. I know below single statement would have solved my purpose, but I have to use datastep and not proc sql.

proc sql; select var1 into :macvar1 separated by " " from have;

Any help would be highly appreciated

Re: concatenating all observations in single

LinusH — Wed, 05 Jun 2013 09:12:01 GMT

Why not SQL?

One should chose whatever tool seems best/easiest for each task...

Anyway, concatenate your vaues into a retained value, and the call symput when the data step reaches the last record/EOF (I guess that your real life data is not provided in datalines)

Re: concatenating all observations in single

forumsguy — Wed, 05 Jun 2013 09:17:10 GMT

Agree Linus, but that's what my client's requirement is. They are insisting on data steps as they previously had experienced that having mixed macro variables (few from datastep and few from proc sql) tend to create problems in their environment. Anyways, can you please elaborate on your approach (EOF and retain). I tried using that as well , however it could not work.

Re: concatenating all observations in single

Keith — Wed, 05 Jun 2013 09:20:04 GMT

I had the same idea as . Here is the code I wrote

data _null_;

set have end=last;

length result $200;

retain result;

call catx(" ",result,var1);

if last then call symput('macvar1',result);

run;

%put &macvar1.;

Re: concatenating all observations in single

forumsguy — Wed, 05 Jun 2013 09:35:17 GMT

Thanks keith... that worked .. I had used retain earlier in sum but never thought it could be applied to char variables as well