Hi Team,  Advance thanks for your help. Need help.  IN below code i want to create month variable as datetype but i am able to create it. i have tried to used input, i have tried " "d but failed. Please suggest %MACRO APP(); %LET X="01JAN2017"D; %DO I = 0 %TO 11; %LET A1=%SYSFUNC(INTNX(MONTH,&X.,&i.,B),date11.); %LET A2=%SYSFUNC(INTNX(MONTH,&X.,&i.,E),date11.); %LET A1_=%SYSFUNC(INTNX(MONTH,&X.,&i.,E),ddmmyyd10.); %LET A4=%SYSFUNC(INTNX(MONTH,&X.,&i.,B),DATE9.); %LET A3=%SYSFUNC(SUBSTR(&A1_,4)); PROC SQL; CONNECT TO ORACLE (PATH= USER= PASSWORD= CREATE TABLE ADHOC6_E.APPLIED_&A4._(COMPRESS=YES) AS SELECT * FROM CONNECTION TO ORACLE (SELECT DISTINCT %bquote('&A4.') as Month, STUD_ID, COUNT(CHARGE_CODE) AS CT_PENMC_APPLIED, SUM(TOTAL_PRICE) AS PENMC_AMT_APPLIED FROM table WHERE PERIOD=%bquote('&A3.') AND SCHM_TYPE='CAA' AND CHARGE_CODE in ('ABCD') GROUP BY STUD_ID ORDER BY STUD_ID ); DISCONNECT FROM ORACLE; QUIT;   %END; %MEND; %APP;   Regards . ... View more

 Hi All,   I need to rank my data.   id var1 var2 var3 1 10      5      24 2 20      7      32 3 30      20     62 4 30      30    98 5 30      30    63 6 40       45    21 7 40       75    33 8 50      60     90      My challage is : I need to rank the data base on priotize variable  example first priority variable is var1  but if var1 is duplicate then need to check var2 if var2 also duplicate then need to check var3   priority level is var1 then var2 then var3   i would be very thankful for ur help.       ... View more

Hi team,  we need help in sas macro  if we can use below  data test; do i = 2, 5, 7 ; x=i; output; end; run;   so what we can not use    %macro x(); %do i=3,6,8; statements; %end; %mend; %x; ... View more