topic Re: Creating the desired table in SAS Procedures

Creating the desired table

tkallday33 — Wed, 03 Sep 2014 22:41:50 GMT

Hello,

Here is the table I have currently:

1	005	002	005002	005002001	19822	19864	.	.
2	005	002	005002	005002001	.	.	19822	19864
3	016	002	016002	016002001	19843	19864	.	.
4	016	002	016002	016002002	.	.	19843	19843
5	017	002	017002	017002006	19820	19822	.	.
6	017	002	017002	017002006	.	.	19820	19822
7	020	002	020002	020002001	19836	19836	.	.
8	020	002	020002	020002001	.	.	19836	19836
9	021	002	021002	021002001	19824	19824	.	.
10	021	002	021002	021002001	.	.	19824	19824
11	049	002	049002	049002001	19845	19864	.	.
12	049	002	049002	049002003	.	.	19864	19864

I am looking for a way to basically combine two lines into one line... for example, combine obs1 with obs2, obs3 with obs4 etc. The problem is that there are missing values for the different variables. So basically I would like this table to only be 6 rows with all the information accros one straight line. Does anyone know how to do this?

Thanks!

-Tyler

Re: Creating the desired table

Haikuo — Wed, 03 Sep 2014 23:49:36 GMT

Something like this?

data have;

infile cards dlm='09'x;

input v1-v9;

cards;

1 005 002 005002 005002001 19822 19864 . .

2 005 002 005002 005002001 . . 19822 19864

3 016 002 016002 016002001 19843 19864 . .

4 016 002 016002 016002002 . . 19843 19843

5 017 002 017002 017002006 19820 19822 . .

6 017 002 017002 017002006 . . 19820 19822

7 020 002 020002 020002001 19836 19836 . .

8 020 002 020002 020002001 . . 19836 19836

9 021 002 021002 021002001 19824 19824 . .

10 021 002 021002 021002001 . . 19824 19824

11 049 002 049002 049002001 19845 19864 . .

12 049 002 049002 049002003 . . 19864 19864

;

data want;

update have (obs=0) have;

by v2;

run;

Haikuo

Re: Creating the desired table

stat_sas — Thu, 04 Sep 2014 00:48:25 GMT

proc stdize data=have out=want reponly method=median;
by v2;
var v6-v9;
run;

data final;
set want;
by v2;
if first.v2;
run;