topic Re: Inserting value in new column based on existing value in SAS Programming

Inserting value in new column based on existing value

BrighterWay — Fri, 29 Jun 2018 20:38:12 GMT

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!

Re: Inserting value in new column based on existing value

ballardw — Fri, 29 Jun 2018 20:44:35 GMT

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.

Re: Inserting value in new column based on existing value

Reeza — Fri, 29 Jun 2018 20:41:45 GMT

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!