Bookmark and Share

Notice: On March 31, it was announced that Statalist is moving from an email list to a forum. The old list will shut down on April 23, and its replacement, statalist.org is already up and running.


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: st: Data structure - left adjusted - numeric variable


From   Matthew White <mwhite@poverty-action.org>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: Data structure - left adjusted - numeric variable
Date   Tue, 3 Apr 2012 19:55:25 -0400

Hi Danny,

Maybe Mata would be easiest here?

clear
input id f1 f2 f3 f4 f5 f6
1 . 12 23 . . 56
2 . 62 . . . .
3 881 . 453 34 55 .
4 . 92 . . . .
5 . 62 . . . .
6 . . . . . 67
7 91 . . . 87 .
8 . . . 66 . .
9 . . 53 . . 76
end

mata:

X = st_data(., .)'
Y = J(rows(X), 0, .)
missing = X :== .
n = 1::rows(X)
for(i = 1; i <= cols(X); i++) {
	Y = Y, X[order((missing[., i], n), 1..2), i]
}
Y = Y'

st_store(., ., Y)

end

Best,
Matt

On Tue, Apr 3, 2012 at 6:20 PM, Danny <danny@hsc.org.nz> wrote:
> Dear all,
>
> I would like to re-structure my panel data which currently sit in the fixed column format (looks like the 1st part of my syntax) to left adjusted format (looks like the 2st part of my syntax).
>
> It would be much appreciated if anyone knows any easy syntax or program can handle it?.
>
> **1st part
> clear
> input id f1 f2 f3 f4 f5 f6
>  1  . 12 23  .  . 56
>  2  . 62  .  .  .  .
>  3 881  . 453 34 55  .
>  4  . 92  .  .  .  .
>  5 . 62  .  .  .  .
>  6  .  .  .  .  .  67
>  7 91  .  .  .  87  .
>  8  .  .  .  66  .  .
>  9  .  . 53  .  . 76
>  End
>
>
> **2nd part
> clear
> input id t1 t2 t3 t4 t5 t6
>  1  12 23  56 . . .
>  2  62  .  .  .  . .
>  3 881 453 34 55  . .
>  4  92  .  .  .  . .
>  5  62  .  .  .  . .
>  6  67 .  .  .  .  .
>  7 91 87  . .  .  .
>  8  66  .  . .  .  .
>  9  53  76 .  .  .  .
>  End
>
>
> Danny
>
> Data Analyst
> Health Sponsorship Council
> New Zealand
>
>
> *
> *   For searches and help try:
> *   http://www.stata.com/help.cgi?search
> *   http://www.stata.com/support/statalist/faq
> *   http://www.ats.ucla.edu/stat/stata/



-- 
Matthew White
Data Coordinator
Innovations for Poverty Action
101 Whitney Avenue, New Haven, CT 06510 USA
+1 434-305-9861
www.poverty-action.org

*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/


© Copyright 1996–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   Site index