topic Re: generate multiple text strings on a single record in SAS Programming

generate multiple text strings on a single record

Kyle — Tue, 16 Apr 2013 17:55:08 GMT

Hi everyone -

I am trying to add multiple text strings onto a single record.

From something like this:

ID TEXT_1 TEXT_2

001 aaaaa bbbbb

002 ccccc ddddd

Here is what I'd like to achieve:

ID TEXT_3

001 aaaaa

bbbbb

002 ccccc

ddddd

Any help would be greatly appreciated. Thanks,

Re: generate multiple text strings on a single record

AncaTilea — Tue, 16 Apr 2013 18:00:48 GMT

Can it be like this?

ID TEXT_3

001 aaaaabbbbb

002 cccccddddd

then:

text_3 = compress(text_1,text_2);

or do you want it like this?

ID TEXT_3

001 aaaaa

001 bbbbb

002 ccccc

002 ddddd

proc transpose data = in out = want;

by id;

var text_1 text_2;

run;

data really_want;

set want(rename = (col1 = text_3 ) drop = _NAME_);

run;

Re: generate multiple text strings on a single record

Kyle — Tue, 16 Apr 2013 18:11:45 GMT

Thanks, Anca. Is there a way to get rid of the multiple IDs. I used array to get to the same result as you did with the transpose though.

ID TEXT

001 aaaaa

bbbbb

002 ccccc

ddddd

Re: generate multiple text strings on a single record

AncaTilea — Tue, 16 Apr 2013 18:17:53 GMT

Like this:

data really_want;

set want(rename = (col1 = text_3 ) drop = _NAME_);

by id;

if not first.id then id = "";

run;

Re: generate multiple text strings on a single record

Astounding — Tue, 16 Apr 2013 18:39:54 GMT

Let me suggest that getting rid of the multiple IDs is a bad idea. You don't have to print them, even with PROC PRINT you can try:

proc print;

var text;

by id;

id id;

run;

And you have even more choices if you learn PROC REPORT. But if you get rid of the multiple IDs you will have to jump through hoops if you ever want to sort your data.

Good luck.

Re: generate multiple text strings on a single record

Kyle — Tue, 16 Apr 2013 18:59:30 GMT

Very helpful tips. Thank you!