I am wondering how I can transpose data based on one variable, then keep all of the additional variables, but without transposing them?
SAS Enterprise Guide 7.1
PROC TRANSPOSE DATA=WORK.NON_ENR_PROV_NPI_LIST OUT=PROV_TEST(DROP=_NAME_ _LABEL_);
/* Here are the columns I want to keep, but not transpose by
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;
proc transpose data=inter out=t_inter;
merge have t_inter;
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.