I was working on SAS and One of the variable or column names is a macro. But When I am using this in PROC REPORT its giving me an error. Can I know How to use macros as column name while using proc report. The macros are as below. %let name2= "DATE_%sysfunc(putn(%sysfunc(today())-2,date9.))"n; %let name1="DATE_ %sysfunc(putn(%sysfunc(today())-1,date9.))"n; %let name="DATE_ %sysfunc(putn(%sysfunc(today()),date9.))"n; PROC REPORT DATA=FINAL_DST_REPOT_TABLE nowd spanrows style(report)=[JUST=CENTER OUTPUTWIDTH=95% CELLSPACING=2 BORDERCOLOR=BLACK BORDERWIDTH=2] STYLE(HEADER)={BORDERCOLOR=BLACK FOREGROUND=WHITE BACKGROUND=MAROON FONT=("zurich BT",11pt)} STYLE(COLUMN)={TAGATTR="WRAP" JUST=CENTER FONT=("zurich BT",08pt) OUTPUTWIDTH=0.05IN BACKGROUND=LIGHTYELLOW FOREGROUND=BLACK BORDERCOLOR=BLACK}; TITLE FONT="Zurich BT" bold height=6 "<U>DST REPORT</U>" JUSTIFY=CENTER; TITLE2 FONT="Zurich BT" bold height=2 "<U>Report Run Date: &sysdate. Time: &SYSTIME</U>" JUSTIFY=RIGHT; column AM AM_CODE TL TL_CODE Emp_Code Emp_Name &name2 &name1 &name DRR Target APPROVED ASSIGNED RESEND UNASSIGNED TOTAL_MTD_DEPLOYED DEC22_LMTD_APPROVED GAP APP_LOGIN ACTIVE_JAN2023 INACTIVE_JAN2023 ACTIVE_DEC2022 QR_APPROVED_DEC2022 APP_LOGIN_DEC2022; define AM/"AM" order order=data style(column)=[font=("zurich BT",9pt)]; define AM_CODE/"AM Code" order order=data style(column)=[font=("zurich BT",9pt)]; define TL/"TL Name" order order=data style(column)=[font=("zurich BT",9pt)]; define TL_Code/"TL Code"order order=data style(column)=[font=("zurich BT",9pt)]; define Emp_Code/"Emp Code" style(column)=[font=("zurich BT",9pt)]; define Emp_name/"Employee Name" style(column)=[font=("zurich BT",9pt)]; define &name2/"&name2" style(column)=[font=("zurich BT",9pt)]; define &name1/"&name1" style(column)=[font=("zurich BT",9pt)]; define &name/"&name" style(column)=[font=("zurich BT",9pt)]; define DRR/"DRR" style(column)=[font=("zurich BT",9pt)]; define Target/"TARGET" style(column)=[font=("zurich BT",9pt)]; define APPROVED/" " style(column)=[font=("zurich BT",9pt)]; define ASSIGNED/"ASSIGNED" style(column)=[font=("zurich BT",9pt)]; define RESEND/"Resend" style(column)=[font=("zurich BT",9pt)]; define UNASSIGNED/"UNASSIGNED" style(column)=[font=("zurich BT",9pt)]; define TOTAL_MTD_DEPLOYED/"TOTAL_MTD_DEPLOYED" style(column)=[font=("zurich BT",9pt)]; define DEC22_LMTD_APPROVED/"DEC22_LMTD_APPROVED" style(column)=[font=("zurich BT",9pt)]; define GAP/"GAP" style(column)=[font=("zurich BT",9pt)]; define APP_LOGIN/"APP_LOGIN" style(column)=[font=("zurich BT",9pt)]; define ACTIVE_JAN2023/"ACTIVE_JAN2023" style(column)=[font=("zurich BT",9pt)]; define INACTIVE_JAN2023/"INACTIVE_JAN2023" style(column)=[font=("zurich BT",9pt)]; define ACTIVE_DEC2022/"ACTIVE_DEC2022" style(column)=[font=("zurich BT",9pt)]; define QR_APPROVED_DEC2022/"QR_APPROVED_DEC2022" style(column)=[font=("zurich BT",9pt)]; define APP_LOGIN_DEC2022/"APP_LOGIN_DEC2022" style(column)=[font=("zurich BT",9pt)]; RUN; ERROR: Please, help. Thanks ... View more

Can anyone suggest or know a function which could search a word or a string from a data. for eg: Kirito is interested in SAS And SAS is Amazing. SAS uses proc sql. I am a new user of SAS. SAS made analysis of data easier.  Now I want to know how many times SAS occurred in the paragraph above. What function should I use? Thank in advance for all the contributors. ... View more

So I was working on SAS and I was using proc SQL, the code provided below. PROC SQL; CREATE TABLE TO2A AS SELECT DISTINCT(FIN_EMP_CODE), COUNT(count) AS 'today2'n FROM to2 GROUP BY FIN_EMP_CODE; QUIT; But, I want to name the column name as today()-2 means the column name should be named 16/01/2023, something like that instead of today2. I have a fade idea of how to do it like we can use macros but I think we can use macros within proc sql. What should I do, what should be my approach? Can anyone guide...... Thanks ... View more

I am working on proc tabulate and I want to fill all the null entry cell with zeros what should I do. Following is the code and ss of the result while i used proc tabulate. proc tabulate data=DST_EMP3 out= F1 (drop=_TYPE_ _PAGE_ _TABLE_); class EMP_CODE DATE_OF_APPROVAL; table EMP_CODE, DATE_OF_APPROVAL; run; I want where data is showing .(dot) it should be replaced by 0(zero).   Thanks ... View more