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!
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.