Help using Base SAS procedures

Simple, if var = 1 then restart count

Accepted Solution Solved
Reply
Contributor
Posts: 43
Accepted Solution

Simple, if var = 1 then restart count

Hi, i have a dataset with people rolling a dice, and i need to label them with a game number

I have a varible called trialCount. This goes from 1 to 13, and everytime it equals one, its a new game number.

Basically this is the stucture i have - except for game number:

trialCount     totalTrialCount     gamenumber (Dont have, but want!)

     1                    1                         1

     2                    2                         1

     3                    3                         1

     4                    4                         1

     1                    5                         2

     2                    6                         2

     1                    7                         3

     1                    8                         4

     1                    9                         5

     2                    10                       5

     3                    .                         5

     4                    .                         .

     5                                              .

     6

     7

     .

     .    

So basically what i would like is something conceptually like:

When trialcount = 1

then gamenumber = "some loop that counts what game number we are at, and puts that number in"

until trialcount = 1 again, then start over

I can't really work this out. I can do a simple count + 1, first.count, but that dosen't really work here.

Hope you understand where im coming from!

Thanks

toby


Accepted Solutions
Solution
‎10-29-2012 02:09 PM
PROC Star
Posts: 7,467

Re: Simple, if var = 1 then restart count

Posted in reply to TMorville

why not just?:

if trialCount eq 1 then GameNumber+1;

View solution in original post


All Replies
Solution
‎10-29-2012 02:09 PM
PROC Star
Posts: 7,467

Re: Simple, if var = 1 then restart count

Posted in reply to TMorville

why not just?:

if trialCount eq 1 then GameNumber+1;

Respected Advisor
Posts: 3,156

Re: Simple, if var = 1 then restart count

Exactly, or equally:

Gamenumber+(trialCount eq 1) ;

Haikuo

Contributor
Posts: 43

Re: Simple, if var = 1 then restart count

Posted in reply to TMorville

God i think i had too much coffee this evening.

Thanks for pointing out the obvious.

T

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 211 views
  • 3 likes
  • 3 in conversation