First, if there's an easier way to line up the data and make it readable in this window please tell me because it was lined up where I copied it from elsewhere and then I copied it into here and it was all scrunched up and I had to hit the space bar a bunch to line things up.
But onto the real question. Yesterday I posted this but it turns out I only posted part of the question. Here it is again.
Here's the data.
ID FormSet var_name var_value var_label var_fmt
1 50 x 1 Label of X xfmt 1 50 y 2 Label of Y 1 50 z 3 Label of Z zfmt 1 55 x 4 Label of X xfmt 1 55 y 5 Label of Y 1 55 z 6 Label of Z zfmt 2 60 x 7 Label of X xfmt 2 60 y 8 Label of Y 2 60 z 9 Label of Z zfmt 2 65 x 10 Label of X 2 65 y 11 Label of Y 2 65 z 12 Label of Z
Here is what I wanted to get yesterday in terms of a dataset and that someone here helped me get.
ID FormSet x y z 1 50 1 2 3 1 55 4 5 6 2 60 7 8 9
2 65 10 11 12
Okay, that part is fine. But as you've probably guessed by now, I also would like to use the var_label variable to generate labels for the newly created dataset immediately above as well as use the var_fmt variable to generate formats for it. I didn't put a format on the variable y to illustrate that some variables will have formats and others will not.
My best guess now is that making the formats will have something to do with proc contents cntlin= and making the labels will have something to do with data _null_ but that's as close as I've gotten. But I can imagine having the data like at the top would be a thing people would do for giant datasets since if would save a lot of hassle if you could then easily convert things, which there must be a way to do.
I think in the past I've already done this except that the labels and formats were already on the 2nd (wide) dataset I created rather than on the 1st (long) one.
Any help is appreciated.
... View more