nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Creating a Variable of Time

tlsimons

Hello All,

I am relatively new to the JMP world and am trying to work through a dataset.

I am in the midst of trying to create a way to measure time within a trial within my data. To do so I have created a Lag variable, which tells me when a new trial starts. I have now been attempting to create a variable that will give me the number of presentations of the manipulation within each trial so that I can then use this to eventually get the measure of time within each trial. I have set this process up as an if, then statement thinking that would work, but I have had no luck getting to the desired end point yet. The current code is below.

If( :Lag1 == 1, 1,
:Lag1 == 0, Empty () )

I want the new variable to be equal to 1 when the Lag1 variable is equal to 1. When Lag1 is equal to 0 I want it to count up until it gets to the next lag1 == 1, in which is should start over with a new counting sequence. I have tried many different functions within the JMP scripts and have lucked out so far.

Any help is greatly appreciated!

Accepted answers

gzmorgan0

Your data looks sorted. There must be some column that represents a unique trial, the start and the end. If your data looks like the left picture, that is what I meant maybe I should have called it intermixed trials.

If your data looks like the left would row 8 an A trial have a 1? If yes, does that trial last only 1 period or shoudl the count of As continue?

If your data looks like the table on the right, then the function I sent works as you described it, and is displayed in the screenshot

Not sorted by TrialSorted by trials and function

All comments

gzmorgan0

Create a new column, here I called it :Group Order, here is the function. Note JMP has a function called lag() just in case you are not familiar with it.

 If( row()==1 | :Lag1==1, 1,
 	:Lag1==0, lag(:Group Order)+1 
   )

This of course assumes your table is sorted. Here is a script, that starts by changing Big Class to have a layout like your table with :Lag1. Then creates the column with the function above.

Names default to here(1);
dt = Open("$sample_data/big class.jmp");

dt << sort( By(:sex, :age), Replace Table);
//needs to be sorted so 1's and 0's are not mixed

dt << New Column("Lag1", numeric, <<Set Each value(0));

//next 3 steps are just to get this table to look like yours
dt << New Column("Order", numeric, <<Set Each value(row()) );
summarize( _ttt = By(:sex,:age), idx=min(:Order));
//idx will be the rows where a new sequence of sex and age begin
:Lag1[idx]=1;

dt << new column("Group Order", numeric);
dt:Group Order << set each value(
 If(row()==1 | :Lag1==1, 1,
 	:Lag1==0, lag(:Group Order)+1 
 )		
);

tlsimons

I am using a lag function to identify the beginning and ending of each of the trials. Each subject will have 4 trials each, and the 1s and 0s are not separated out from eachother, they are intertwined within the overal subject data. The lenght of each trial will vary depending on the lenght of that specific trial and is not the same for each participant.

Due to this I am not sure that what you have suggested will completly work for the dataset that I have. There is an example of what I mean by my 0s and 1s being intertwined within my dataset, if that is helpful.

Thank you for the reply!

gzmorgan0

If your data looks like the left would row 8 an A trial have a 1? If yes, does that trial last only 1 period or shoudl the count of As continue?

If your data looks like the table on the right, then the function I sent works as you described it, and is displayed in the screenshot

Not sorted by TrialSorted by trials and function

tlsimons

My data was set up like the image on the right and just like you said that script you gave me did work!

Thank you so much for your help. I greatly appreciate it!