If data is a datetime column, wy don't you do the bwtween based on datetime constants instead, thus ommitting datepart functions in the where clause. Then you could even ommit explict SQL pass through. ... View more

At this point, nobody can tell which 500 observations you want.  In fact, we can't even tell if there are many more than 500 observations that would meet the criteria you are setting up.  Here's a program that will start you in the right direction: proc freq data =new; tables MSW * MSWO / list missing; run; The basic problem is that we can't tell how many observations overlap (both MSW and MSWO = 1).  In fact, it is possible that none of the observations overlap in that way.  So this program will continue your journey of learning about your data so you can make an informed decision about how to proceed. ... View more

I tried running for Non segment and without non segment. Both are showing same results.   1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; NOTE: ODS statements in the SAS Studio environment may disable some output features. 73 74 %macro isblank(var); 75 %if %symexist(&var) %then 1; %*not exist*; 76 %else %if %sysevalf(%superq(&var)=,boolean) %then 1; %*blank*; 77 %else 0; 78 %mend isblank; 79 80 81 data new; 82 input direction $ segment $ acct; 83 datalines;   NOTE: The data set WORK.NEW has 6 observations and 3 variables. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.01 seconds     90 ; 91 run; 92 93 %let Non_segment=; 94 %if %isblank(Non_segment) %then %do; 95 %let obs=1 ; 96 %end; 97 98 %let dir =A; 99 100 %let linear=1; 101 %if &linear %then %do; 102 ods excel options(sheet_name="vol"); 103 proc print data=new (obs=&obs.); 104 id direction segment; 105 var acct; 106 run;   NOTE: There were 1 observations read from the data set WORK.NEW. NOTE: PROCEDURE PRINT used (Total process time): real time 0.11 seconds cpu time 0.12 seconds     107 %end; 108 %else %do; 109 ods excel options(sheet_name="vol"); 110 proc print data=new; 111 var direction segment acct; 112 run; %end; 113 114 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 127   ... View more

Your plan needs a little correction first.  It's not possible to have two variables called NAME in the same data set.  And the values for SEX for bb look like they should be 0 1 0, not 1 0 1.   At any rate, if both data sets contain the same number of observations for aa and bb, you could use:   data z k; set p; set L; if name='aa' then output z; else output k; run;   Variations in the code might depend on how many NAME values exist, but this program at least works for the data you provided. ... View more

2017-01-12 used as a date parameter will be evaluated as 2004 (2017 minus 1 minus 12), which means 2004 days after 01jan1960. Use a proper informat as @novinosrin suggests. Hint: macro variables to be used as dates should contain raw date values (5-digit numbers as of now); human-readable form is not needed. Makes everything easier. ... View more

What if macros are given quotes %let begin=‘20170101’; %let end =‘20170501’; How does loop works ? ... View more