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.
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.