Hi All, I wanna rename my variables in PROC PRINT, what i did was to add a label in my PROC PRINT at first, but it didnt work(show no changes). I then create a new data set and put label again, didnt work. I then show you all my PROC CONTENTS in this post.:
Need your advice to help me to label my variables.
proc sort data=WORK.QUERY_FOR_FILTER_FOR_CASE_U_0000;
by ROW_NO;
RUN;
proc transpose data=WORK.QUERY_FOR_FILTER_FOR_CASE_U_0000 out=WORK.TRANSPOSED;
id UDF_NM;
var UDF_VALUE;
by ROW_NO CASE_RK;
run;
PROC PRINT DATA=WORK.TRANSPOSED (DROP=CASE_RK _NAME_);
TITLE 'PRINT TRANSPOSED';
label X_AAG_BONUS ='Bonus'
X_AAG_SALARY = 'Salary';
SUM X_AAG_BONUS X_AAG_SALARY;
RUN;
PROC CONTENTS DATA=WORK.TRANSPOSED;
RUN;
Ok guys, i foudn the solution myself, i have to add label in proc print statement
PROC PRINT data=WORK.TRANSPOSED label;
label xxxx = 'yyy';
run;
Ok guys, i foudn the solution myself, i have to add label in proc print statement
PROC PRINT data=WORK.TRANSPOSED label;
label xxxx = 'yyy';
run;
I would suggest move to proc report, it has a lot more functionality.
Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.
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.
Ready to level-up your skills? Choose your own adventure.