Hi Guys. Thanks for all the advices. I truly understand about the learn from basics part. Currently i will have to settle my works on my hand first. I talked to my senior and just like what some of you all mentioned, SAS can execute the code straight after removing %put. I tried to put double quote wrapping like : "&comma. &&cwcolumn&k.." (previously i never wrap it with double quote) However, I am getting error for all the resolved variable: May i know if there is any special handling when it is actually resolving a proc sql statement? proc sql;
create table
CDSSTG.CSTG_ACTIVITY_CONCERN_AREA as(
select
NOTE: Line generated by the macro variable "CWCOLUMN1".
386 " ACTION_DATE
______________
180
ERROR 180-322: Statement is not valid or it is used out of proper order.
NOTE: Line generated by the macro variable "CWCOLUMN2".
386 ", ACTION_PARTY
________________
180
ERROR 180-322: Statement is not valid or it is used out of proper order.
NOTE: Line generated by the macro variable "CWCOLUMN3".
11 The SAS System 15:40 Tuesday, July 11, 2017
386 ", ACTION_REQUIRED
___________________
180
ERROR 180-322: Statement is not valid or it is used out of proper order.
NOTE: Line generated by the macro variable "CWCOLUMN4".
386 ", ACTIVITIES
______________
180
ERROR 180-322: Statement is not valid or it is used out of proper order.
NOTE: Line generated by the macro variable "CWCOLUMN5".
386 ", OFFLINE_DATE
________________
180
ERROR 180-322: Statement is not valid or it is used out of proper order.
NOTE: Line generated by the macro variable "CWCOLUMN6".
386 ", PLATFORM_CD
_______________
180
ERROR 180-322: Statement is not valid or it is used out of proper order.
NOTE: Line generated by the macro variable "CWCOLUMN7".
386 ", REMARKS
___________
180
ERROR 180-322: Statement is not valid or it is used out of proper order.
NOTE: Line generated by the macro variable "CWCOLUMN8".
386 ", REPORT_DT
_____________
180
ERROR 180-322: Statement is not valid or it is used out of proper order.
NOTE: Line generated by the macro variable "CWCOLUMN9".
386 ", STATUS
__________
180
ERROR 180-322: Statement is not valid or it is used out of proper order.
NOTE: Line generated by the macro variable "CWCOLUMN10".
386 ", TARGET_DATE
_______________
180
ERROR 180-322: Statement is not valid or it is used out of proper order.
NOTE: Line generated by the macro variable "CWCOLUMN11".
386 ", WF_COACT
____________
12 The SAS System 15:40 Tuesday, July 11, 2017
180
ERROR 180-322: Statement is not valid or it is used out of proper order.
NOTE: Line generated by the macro variable "CWCOLUMN12".
386 ", WF_DEL_DATE
_______________
180
ERROR 180-322: Statement is not valid or it is used out of proper order.
NOTE: Line generated by the macro variable "CWCOLUMN13".
386 ", WF_PHASE
____________
180
ERROR 180-322: Statement is not valid or it is used out of proper order.
NOTE: Line generated by the macro variable "CWCOLUMN14".
386 ", WF_STATUS
_____________
180
ERROR 180-322: Statement is not valid or it is used out of proper order.
NOTE: Line generated by the macro variable "CWCOLUMN15".
386 ", WF_TXNID
____________
180
ERROR 180-322: Statement is not valid or it is used out of proper order.
NOTE: Line generated by the macro variable "CWCOLUMN16".
386 ", WF_USERID
_____________
180
ERROR 180-322: Statement is not valid or it is used out of proper order.
NOTE: Line generated by the macro variable "CWCOLUMN17".
386 ", WF_USERMODDATE
__________________
180
from CDSSTG.CSTGT_ACTIVITY_CONCERN_AREA);
ERROR 180-322: Statement is not valid or it is used out of proper order. May i know if the double quote wrap here is wrongly used or there is something missing from it.
... View more