Subscribe Bookmark RSS Feed

Create new table where column values are outputted to multiple rows

poulravn

Community Trekker

Joined:

Jan 25, 2012

Hi, this questions pertains to the taks of emulating what SAS does like this:

data mydata1(drop=x1 x2 x3 . . );set mydata;

x=x1; output mydata1; /* x1 is a variable in mydata ;

x=x2; output mydata1;
x=x3; . . .

This creates a variable, x, which holds the x1, x2, x3 etc.

Hence there are as many times observations in mydata1 compared to mydata as the number of x's that are outputted.

This I want to do in JMP Script.

Regards Poul

1 REPLY
pmroz

Super User

Joined:

Jun 23, 2011

Take a look at the STACK command.  Should do what you want.