Prev: Siebel or Oracle CRM on Demand - NC& MA - 10+months
Next: Simple hack to get $500 to your home.
From: Zintie on 13 Jul 2010 22:01
Hi All,

Am trying to figure this problem out:

my ds:

PT Visits score
-----------------------------------------
101 V0 5
101 V1 10

my desire output:

PT VO V1
-----------------------------------------
101 5 10


currently am splitting the ds into 2 and then merging back..but am
sure there more advanced way of doing it..


Thanks in advance!

Z
From: Ya on 13 Jul 2010 22:37
On Jul 13, 7:01 pm, Zintie <raisin...(a)yahoo.com> wrote:
> Hi All,
>
> Am trying to figure this problem out:
>
> my ds:
>
>  PT       Visits      score
> -----------------------------------------
>  101       V0             5
>  101       V1             10
>
> my desire output:
>
> PT         VO            V1
> -----------------------------------------
> 101        5               10
>
> currently am splitting the ds into 2 and then merging back..but am
> sure there more advanced way of doing it..
>
> Thanks in advance!
>
> Z

proc transpose data=have out=want;
by pt;
var score;
id visits;
run;

From: Zintie on 14 Jul 2010 12:30


Thanks!!
 | 
Pages: 1
Prev: Siebel or Oracle CRM on Demand - NC& MA - 10+months
Next: Simple hack to get $500 to your home.