cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • JMP will suspend normal business operations for our Winter Holiday beginning on Wednesday, Dec. 24, 2025, at 5:00 p.m. ET (2:00 p.m. ET for JMP Accounts Receivable).
    Regular business hours will resume at 9:00 a.m. EST on Friday, Jan. 2, 2026.
  • We’re retiring the File Exchange at the end of this year. The JMP Marketplace is now your destination for add-ins and extensions.

Discussions

Solve problems, and share tips and tricks with other JMP users.
Choose Language Hide Translation Bar
jswislar
Level III

How do I assign a start date?

I have a longitudinal study with sites entering on different dates. To make them comparable, I need to assign each entry date as "1" and the second data collection point as "2" and so on. The data are in long format and there are a lot of missing data (missed data collection)

  

The data look like this, I want to generate "Count":

ID    Date   Var1  Count

001  Jan-1   .          .

001  Feb-1   .          .

001  Mar-1   10       1

001  Apr-1    13       2

002  Jan-1    8         1

002  Feb-1   10        2

002  Mar-1   .           .

 

I used a JRP formula, but it counts every line whether the first measure is missing or not.

10 REPLIES 10
jswislar
Level III

Re: How do I assign a start date?

Thanks!
I've been trying to learn JMP programming and this interaction helps, especially when odd requests aren't in the books.

Recommended Articles