About Nsas

Nsas · ‎06-19-2017

@RW9: Thanks. In your code the increment from time=0 to time=1 by 0.1 works but not the time=1 to time=3 by 0.5. not sure why?

Nsas · ‎06-19-2017

I'm trying to create additional rows based on time variable. from time=0 to time=1, additional rows to be created with an increment of 0.1 from time=1 to time=3, additional rows to be created with an increment of 0.5. Please find the input and output datasets below. DATA HAVE; INPUT ID TIME D1 D2 E1; DATALINES; 1 -0.25 . . 0 1 0 . . 1 1 3 . . 0 1 672.25 . . 0 2 0 . . 0 2 0 . . 1 2 3 21300 9.966 0 2 669.5 2760 7.923 0 2 670.0833 . . 1 2 673.25 31400 10.355 0 2 1509.1667 3760 8.232 0 2 1509.1667 . . 1 2 1512.1667 24100 10.09 0 2 2181.4167 4170 8.336 0 2 2181.5 . . 1 2 2184.5333 26900 10.2 0 2 2853.5 . . 1 2 3525.7917 . . 1 2 3981.5 9310 9.139 0 ; DATA WANT; INPUT ID TIME D1 D2 E; DATALINES; 1 -0.25 . . 0 1 0 . . 1 1 0.2 . . 0 1 0.4 . . 0 1 0.6 . . 0 1 0.8 . . 0 1 1 . . 0 1 1.5 . . 0 1 2 . . 0 1 2.5 . . 0 1 3 . . 0 1 672.25 . . 0 2 0 . . 0 2 0 . . 1 1 0 . . 1 1 0.2 . . 0 1 0.4 . . 0 1 0.6 . . 0 1 0.8 . . 0 1 1 . . 0 1 1.5 . . 0 1 2 . . 0 1 2.5 . . 0 2 3 21300 9.966 0 2 669.5 2760 7.923 0 2 670.0833 . . 1 2 673.25 31400 10.355 0 2 1509.1667 3760 8.232 0 2 1509.1667 . . 1 2 1512.1667 24100 10.09 0 2 2181.4167 4170 8.336 0 2 2181.5 . . 1 2 2184.5333 26900 10.2 0 2 2853.5 . . 1 2 3525.7917 . . 1 2 3981.5 9310 9.139 0 ;

Nsas · ‎06-19-2017

@PeterClemmensen: this is to perform some sort of simulation. Thanks for catch with increment values. Increment is 0.5 from time=1 to time=3.

Nsas · ‎06-19-2017

DATA HAVE; INPUT ID TIME D1 D2 E1; DATALINES; 1 -0.25 . . 0 1 0 . . 1 1 3 . . 0 1 672.25 . . 0 2 0 . . 0 2 0 . . 1 2 3 21300 9.966 0 2 669.5 2760 7.923 0 2 670.0833 . . 1 2 673.25 31400 10.355 0 2 1509.1667 3760 8.232 0 2 1509.1667 . . 1 2 1512.1667 24100 10.09 0 2 2181.4167 4170 8.336 0 2 2181.5 . . 1 2 2184.5333 26900 10.2 0 2 2853.5 . . 1 2 3525.7917 . . 1 2 3981.5 9310 9.139 0 ; DATA WANT; INPUT ID TIME D1 D2 E; DATALINES; 1 -0.25 . . 0 1 0 . . 1 1 0.2 . . 0 1 0.4 . . 0 1 0.6 . . 0 1 0.8 . . 0 1 1 . . 0 1 1.5 . . 0 1 2 . . 0 1 2.5 . . 0 1 3 . . 0 1 672.25 . . 0 2 0 . . 0 2 0 . . 1 1 0 . . 1 1 0.2 . . 0 1 0.4 . . 0 1 0.6 . . 0 1 0.8 . . 0 1 1 . . 0 1 1.5 . . 0 1 2 . . 0 1 2.5 . . 0 2 3 21300 9.966 0 2 669.5 2760 7.923 0 2 670.0833 . . 1 2 673.25 31400 10.355 0 2 1509.1667 3760 8.232 0 2 1509.1667 . . 1 2 1512.1667 24100 10.09 0 2 2181.4167 4170 8.336 0 2 2181.5 . . 1 2 2184.5333 26900 10.2 0 2 2853.5 . . 1 2 3525.7917 . . 1 2 3981.5 9310 9.139 0 ; I'm trying to create the dummy rows using the time variable. for instance, from time=0 to time=1, dummy rows will be created with an increment of time value by 0.2. Also, from time=1 to time=3, dummy rows will be created with an increment of 0.5. for each dummy record created D1and D2 will be set . and E1 will be set to 0. Any help to create this output data is greatly appreciated. Thanks

Nsas · ‎02-11-2017

Count would be: 1 . 1 1 . 2 2 2 2 2

Nsas · ‎02-11-2017

I wanna count the consecutive rows (>=3) with RUN=0 between rows with RUN=10. Have: data have; input ID day run; datalines; 1 0 0 1 2 10 1 2 0 1 3 10 1 4 0 1 4 0 1 5 0 1 7 0 1 7 0 1 10 0 1 11 10 1 12 0 1 14 0 1 15 0 1 16 10 1 17 0 1 18 0 1 19 0 1 20 0 1 21 10 1 22 0 1 23 0 1 24 0 1 25 0 1 26 10 1 27 0 1 28 0 1 29 10 1 30 0 ;; want: ID DAY RUN COUNT 1 0 0 1 1 2 10 . 1 2 0 1 1 3 10 . 1 4 0 2 1 4 0 2 1 5 0 2 1 7 0 2 1 7 0 2 1 10 0 2 1 11 10 . 1 12 0 3 1 14 0 3 1 15 0 3 1 16 10 . 1 17 0 4 1 18 0 4 1 19 0 4 1 20 0 4 1 21 10 . 1 22 0 5 1 23 0 5 1 24 0 5 1 25 0 5 1 26 10 . 1 27 0 1 1 28 0 1 1 29 10 . 1 30 0 1 I do appreciate any tips to get this output. Note: All consecutive rows with RUN=0 and day <10 will be assigned the same value.

Online Status	Offline
Date Last Visited	‎06-19-2017 03:15 PM

Re: Adding additional rows based on time variable

Adding additional rows based on time variable

Re: Create dummy rows based on time variable

Create dummy rows based on time variable

Re: Find consecutive rows

Find consecutive rows