topic PROC Transpose - Transpose one variable, and keep all other variables in SAS Procedures

PROC Transpose - Transpose one variable, and keep all other variables

vanpeltm1785 — Fri, 20 Oct 2017 14:10:48 GMT

Hello all,

I am wondering how I can transpose data based on one variable, then keep all of the additional variables, but without transposing them?

Thanks,

Matt

SAS Enterprise Guide 7.1

PROC TRANSPOSE DATA=WORK.NON_ENR_PROV_NPI_LIST OUT=PROV_TEST(DROP=_NAME_ _LABEL_);

BY MEMBER_ID;

VAR PRESCRIBER_NPI; 

/* Here are the columns I want to keep, but not transpose by
PROV_LAST_NAME 
PROV_FIRST_NAME 
prov_location_city 
prov_location_state 
prov_location_POSTAL_CODE*/

RUN;

Re: PROC Transpose - Transpose one variable, and keep all other variables

RW9 — Fri, 20 Oct 2017 14:27:46 GMT

Sorry, could you provide an example, with datastep test data and required output. Your post doesn't really make sense. You mean you have a dataset where you want to pull out some variables, transpose them and then merge back onto your original data? If so:

proc sort data=have out=inter (keep=member_id prescriber_npi);
  by member_id prescriber_npi;
run;
proc transpose data=inter out=t_inter;
  by member_id;
  var prescriber_npi;
run;
data want;
  merge have t_inter;
  by prescriber_id;
run;

Re: PROC Transpose - Transpose one variable, and keep all other variables

Ksharp — Sat, 21 Oct 2017 13:30:01 GMT

Check COPY statement.


PROC TRANSPOSE DATA=WORK.NON_ENR_PROV_NPI_LIST OUT=PROV_TEST(DROP=_NAME_ _LABEL_);

BY MEMBER_ID;

VAR PRESCRIBER_NPI; 

copy

PROV_LAST_NAME 
PROV_FIRST_NAME 
prov_location_city 
prov_location_state 
prov_location_POSTAL_CODE;

RUN;