Help using Base SAS procedures

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

Reply
New Contributor
Posts: 4

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

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;

 

Super User
Super User
Posts: 9,599

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

Posted in reply to vanpeltm1785

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;
Super User
Posts: 10,784

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

Posted in reply to vanpeltm1785
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;


Ask a Question
Discussion stats
  • 2 replies
  • 779 views
  • 1 like
  • 3 in conversation