Thanks a lot, it works, but i need to create this x table again n again like i have 10 conditions on diff diff variables i need to check every variable with conditions for each row. By this i wont be able to create x dynamicly. I need to pick 1st row for 1st condition , 2nd row for 2nd condition, i need to call same macro recursively. Thanks again ... View more

Same is working , diff is not proc sql to create macro varible; Code: %GLOBAL FLAG; %MACRO TEST(); %LET VAR=NAME; %LET SEX=M; %LET COND= =; %IF &VAR &COND %BQUOTE('&SEX') %THEN %LET FLAG=Y; %ELSE %LET FLAG=N; %MEND; DATA NEW; SET SASHELP.CLASS; CALL EXECUTE('TEST();'); FLAG=CALL SYMGET('FLAG'); RUN; Its working fine. Plz help ... View more

Apology, I have a table with conditions I have created macrovariables for conditions where macro variable A is column name and Macro variable b is value. While calling inside datastep condition need to check with row. And want to all flag. Its only step. If condition get true i will pick another variable as reference to pick another condition as macro variable and will check again untill last node. My problem is here when macro variable are resolving correct value as per data why my condition is not getting true ... View more

Not able to understand, u call macro outside of datastep it will run only 1 time, and u r getting Flag value Y? ... View more

As my example i have only one character to check. LIKE 1 2 3 4 5 A B C D These flags which i need to check , provided is just an example. But going through always false and Flag is being assign as N ... View more

Its just an example, i need to use it with big data by checking multiple conditions and need to call macro recursivly untill i reach my end node Is there any solution? ... View more

getting error :   ERROR: ORACLE prepare error: ORA-00923: FROM keyword not found where expected. SQL statement: SELECT DISTINCT '01JAN2018'd as Month, COUNT(CASE WHEN (CHARGE_CODE='AVBAL') THEN CHARGE_CODE END) AS AVBAL_CHG_CT_REC, COUNT(DISTINCT CASE WHEN (CHARGE_CODE='AVBAL') THEN FORACID END) AS AVBAL_ACC_CT_REC, SUM(CASE WHEN (CHARGE_CODE='AVBAL') THEN APPROPRIATED END) AS AVBAL_AMT_REC, COUNT(CASE WHEN (CHARGE_CODE='CCNNA') THEN CHARGE_CODE END) AS CCNNA_CHG_CT_REC, COUNT(DISTINCT CASE WHEN (CHARGE_CODE='CCNNA') THEN FORACID END) AS CCNNA_ACC_CT_REC, SUM(CASE WHEN (CHARGE_CODE='CCNNA') THEN APPROPRIATED END) AS CCNNA_AMT_REC, COUNT(CASE WHEN (CHARGE_CODE='CHQRT') THEN CHARGE_CODE END) AS CHQRT_CHG_CT_REC, COUNT(DISTINCT CASE WHEN (CHARGE_CODE='CHQRT') THEN FORACID END) AS CHQRT_ACC_CT_REC, SUM(CASE WHEN (CHARGE_CODE='CHQRT') THEN APPROPRIATED END) AS CHQRT_AMT_REC, COUNT(CASE WHEN (CHARGE_CODE NOT IN ('AVBAL','CCNNA','CHQRT')) THEN CHARGE_CODE END) AS OTHERS_CHG_CT_REC, COUNT(DISTINCT CASE WHEN (CHARGE_CODE NOT IN ('AVBAL','CCNNA','CHQRT')) THEN FORACID END) AS OTHERS_ACC_CT_REC, SUM(CASE WHEN (CHARGE_CODE NOT IN('AVBAL','CCNNA','CHQRT')) THEN APPROPRIATED END) AS OTHERS_AMT_REC FROM table_name WHERE SCHM_TYPE='CAA' AND (RECOVER_DATE BETWEEN '08-2012' AND '08-2012'). ... View more

HI Sir,   Thanks for your reply.   I think i was not able to discribe my question   suppose  %let A=09DEC2017 now i want to create a date variable month in my date set . in normal sql what i am using simply "&A."d as month format date9. but at the same time when i using same code inside oracle passthrough its not working. to get the only vaule i can use single quote like '&A.' but i want it as datetype. how can i do that.   Please suugest ... View more