Data in rows to be delimited by semi-colons and in a tring

[Queryman]

I have a sas data set that has thouands of records, they are approximately 8 characters long, some less, but not more. I need to know how to concatenate them all together in a string separated by semi-colons.
Thanks,



Michael

 

[teralearner]

Try something like this:

data combined;
set separated;
length oneVar $ 10000;
array allvar(*) _character_;
oneVar = allVar(1);
do i = 2 to dim(allvar);
oneVar = trim(oneVar(i)) || ";" || allvar;
end;
run;

I did not test the code. But I think the logic is ok.

 

[Queryman]

Do I have to change my variable name to test this, I am not sure I understand the Onevar & allvar
Thanks,



Michael

 

[teralearner]

Wait a minute, do you have many fields to be concatenated into one field or one field with many rows to be concatenated into one field in one row?

What I had before is for the first case, oneVar is the concatenated variable name.

For second case, proc transpose would convert it into one row many fields. Then this becomes first case.

If you have second case, but want to output to an external file in one long string, you can try the following:

data_NULL_;
set yourSet;
file 'yourpath/yourFile' dsd delimiter = ";";
put yourfield @;
run;

 

[Queryman]

I have the second scenario
Thanks



Michael