About Caymon

Caymon · ‎09-29-2011

Thanks! this is exactly what I was looking for. This works perfectly. I made only two tiny changes to your code: art297 wrote: data want; set have; array projects(*) q12008--q42009; do i=1 to dim(projects); if projects(i) gt 0 then do; found=i; i=dim(projects)+1; end; j=0; end; do i=found to dim(projects); j+1; projects(j)=projects(i); end; do i=dim(projects)-found+2 to dim(projects); call missing(projects(i)); end; run;

Caymon · ‎09-29-2011

I currently have a dataset that has observations sorted by times going across the top. The observations being at different time periods. project q1 2008 q2 2008 q32008 q42008 q12009 q2009 q32009 q42009 ...... 1 4 5 8 8 9 12 14 16 2 0 0 3 6 5 7 10 8 3 4 3 5 4 3 5 0 3 4 0 0 0 0 5 4 7 10 5 0 0 0 0 0 0 3 2 I would like to rearrange the data so that every observation beings a the same time. Ideally the dataset would like this: project t1 t2 t3 t4 t5 t6 t7 t8 1 4 5 8 8 9 12 14 16 2 3 6 5 7 10 8 . . 3 4 3 5 4 3 5 0 3 4 5 4 7 10 . . . . 5 3 2 . . . . . . Any suggestions would be greatly appreciated. Thanks

Online Status	Offline
Date Last Visited	‎09-01-2015 07:11 AM

Reorder time series data

Reorder time series data

Reorder time series data

Reorder time series data