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!
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.
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!
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.