7035_en-US

liliconcom

Create new table where column values are outputted to multiple rows<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />

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

Re: Create new table where column values are outputted to multiple rows

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