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!
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.