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;
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;
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;
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.
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.