topic Re: Help with re-formatting a table in Enterprise Guide in SAS Enterprise Guide

Help with re-formatting a table in Enterprise Guide

arogers — Thu, 27 Dec 2012 19:32:27 GMT

I have a table with variable names (string values) in column form that come from a user input. There is always 1 column with the header called "Name" but the number of rows in the column is undefined (based on user input, the variable list is currently called by the macro &THRES_VARS).

Example Data:

Name

Variable1

Variable2

Variable3

I need the resulting output to be a 1 column 1 row table that looks like this:

Variable1+Variable2+Variable3

Does anyone know how to produce code/macro to produce the output?

Re: Help with re-formatting a table in Enterprise Guide

Reeza — Thu, 27 Dec 2012 20:05:40 GMT

assuming you literally want it separated by "+"

Here's one way via code. You can change the delimiter as you like as well. Make sure the initial length of the variable is long enough to hold the resulting string.

firstobs is set to 2 so that the name is not included.

data want;

length variable $512;

set have (firstobs=2) end=eof;

retain variable;

variable=catx("+", variable, your_variable);

if eof then output;

run;

Re: Help with re-formatting a table in Enterprise Guide

arogers — Thu, 27 Dec 2012 20:20:43 GMT

That is exactly what I needed. Thanks so much.