Inserting value in new column based on existing value

[BrighterWay]

I'd like to transform table from :

Name        PlanType     PlanNum  

David        PlanA          10101

David        PlanB          20202  

David        PlanC          30303

to:

Name    PlanA_Num     PlanB_Num   PlanC_Num

David       10101             20202             30303

any thoughts? using proc sql; or data steps.. 

Thanks!

[ballardw]

Proc Transpose will handle this generally:

proc transpose data=have
     out=want;
by name;
var plannum;
id PlanType;
run;

If you data isn't sorted by the name you either should sort the data or use By NOTSORTED  name.

If you really want the variables to end with _NUM then you can add a Suffix='_num' to the proc statement.

If plan type is duplicated per name though there'll be errors.

[Reeza]

PROC TRANSPOSE

---

@BrighterWay wrote:

I'd like to transform table from :

Name        PlanType     PlanNum  

David        PlanA          10101

David        PlanB          20202  

David        PlanC          30303

to:

Name    PlanA_Num     PlanB_Num   PlanC_Num

David       10101             20202             30303

any thoughts? using proc sql; or data steps.. 

Thanks!

---