Hi, need help! got a scenario, where need to populate the same record for above and below the value 1 and value 2 records  until it got the same ID or value 1 or value 2 is not empty ID Date  Value1 Value2 1 14-Oct-17 . . 1 15-Oct-17 . . 1 16-Oct-17 . . 1 17-Oct-17 . . 1 18-Oct-17 . . 1 19-Oct-17 1 2 1 20-Oct-17 . . 1 21-Oct-17 . . 1 22-Oct-17 2 5 1 23-Oct-17 . . 1 24-Oct-17 . . 2 14-Oct-17 . . 2 15-Oct-17 . . 2 16-Oct-17 . . 2 17-Oct-17 4 6 2 18-Oct-17 . . 2 19-Oct-17 . . 2 20-Oct-17 . . 2 21-Oct-17 . . 2 22-Oct-17 . .     I want something like  ID Date  Value1 Value2 1 14-Oct-17 1 2 1 15-Oct-17 1 2 1 16-Oct-17 1 2 1 17-Oct-17 1 2 1 18-Oct-17 1 2 1 19-Oct-17 1 2 1 20-Oct-17 1 2 1 21-Oct-17 1 2 1 22-Oct-17 2 5 1 23-Oct-17 2 5 1 24-Oct-17 2 5 2 14-Oct-17 4 6 2 15-Oct-17 4 6 2 16-Oct-17 4 6 2 17-Oct-17 4 6 2 18-Oct-17 4 6 2 19-Oct-17 4 6 2 20-Oct-17 4 6 2 21-Oct-17 4 6 2 22-Oct-17 4 6 ... View more

Hi, creating some automation report, I need to select only the last 3 columns. for example: If I run in April need to select column Jan, Feb, Mar. If run in  Dec select Sep, Oct, Nov along with ID, etc. ID January February March 1 1 1 4 2 14 12 33 I3 5 3 3 4 1 3 3   Any help is much appreciated  ... View more

Hi, need help!! when assigning macro to proc export, it works in data file i.e Reach_Report_&export  but not in outfile. My macro contains value as 2, it works in data = Reach_Report_2 but not in outfile. Any reasons and how to correct it?   proc export data=Report_2   outfile='\C:\Users\Incremental_Reach_Report_&export.xlsx' dbms = xlsx replace;run;   ... View more

Getting macro error  (Need Help!!!) Basically I tried to run  below     %macro assign;       proc sql noprint;     select count(distinct(Identifier)) into :z     from &Olive_Schema..owner_metadata ;   quit;     %let z = &z;     %do j = 1 %to &z;   %LET Identify = &j;     Data test_& Identify; Set test_&Identify; Run; It was running fine until here, then when  introduced   proc sql noprint;     select count(distinct(weeks)) into :r     from iter1_&Identify ;   quit;     %let r = &r;       proc sql noprint;   select distinct weeks     into :t1 - :t&r.     from iter1_&Identify ;     quit;  %let r = &r;     %do i = 1 %to &r;   %LET ctr_wk = &&t&i;   Data test_&ctr_wk; Set test;run;     %end; %end; %mend; %assign;     WARNING: Apparent symbolic reference R not resolved. ERROR: The text expression &R contains a recursive reference to the macro variable R.  The macro variable will be assigned the null        value.   ERROR: %EVAL function has no expression to evaluate, or %IF statement has no condition. ERROR: The %TO value of the %DO I loop is invalid. ERROR: The macro ASSIGN will stop executing.   ... View more

Hi There, Need help on Macro error   i got min and max week number  as below.. trying to create table based on week number between &min_weeks and &max_weeks but macro showing error with dot (.) instead of actual number   Proc sql ; select min( week_number)  into : MIN_WEEKS from   work.Data quit;   %let MIN_WEEKS = %qtrim(&MIN_WEEKS);   %put &MIN_WEEKS ;   Proc sql ; select max(week_number)  into : MAX_WEEKS from   work.Data; quit;   %let MAX_WEEKS = %qtrim(&MAX_WEEKS); %put &MAX_WEEKS ;   PROC SQL; SELECT   distinct adj_week_number as weeks into work.iter1 from work.Data          WHERE week_number BETWEEN &MIN_WEEKS. AND &MAX_WEEKS.; quit;              But the macro &MIN_WEEKS., &MAX_WEEKS. not working , getting error   “WHERE week_number  BETWEEN . AND . “  not sure why getting dot instead of number (e.g. 1 – min and 5- max)   ... View more