BookmarkSubscribeRSS Feed
vanpeltm1785
Obsidian | Level 7

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;

 

2 REPLIES 2
RW9
Diamond | Level 26 RW9
Diamond | Level 26

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;
Ksharp
Super User
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;


SAS INNOVATE 2024

Innovate_SAS_Blue.png

Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.

If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website. 

Register now!

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

Get the $99 certification deal.jpg

 

 

Back in the Classroom!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 2 replies
  • 17584 views
  • 2 likes
  • 3 in conversation