You mean in the range of +/- 3 month , NOT out of the range ? data want; merge have have(where=(b='SCREEN') rename=(visit_date=_date)); by id; if b eq: 'MONTH' then do;    if intnx('month',_date,-3,'s') le visit_date le intnx('month',_date,3,'s') then do;   flag=ifc(visit_date gt _date ,'BELOW','ABOVE'); end; end; run; Xia Keshan ... View more

DATA HAVE; REMAINING_MONTHS=62; OUTPUT; RUN; PROC SQL; CREATE TABLE WANT AS   SELECT     REMAINING_MONTHS,CATS((REMAINING_MONTHS / 12), "YEARS") AS YEARS FROM HAVE; QUIT; PROC PRINT; RUN; ... View more

Base SAS(R) 9.2 Procedures Guide ... View more

For running in batch see: http://support.sas.com/documentation/cdl/en/hostwin/67279/HTML/default/viewer.htm#n0yfzk61sv9f2wn1o2rieqr5jlt6.htm The crux is using a windows script (.bat .cmd), similar as a scheduler does. The log should be save so you can see that after it has been run. For email-usage to an email provider see: http://support.sas.com/documentation/cdl/en/lesysoptsref/67465/HTML/default/viewer.htm#p1v9dr6zep9p9en1prhl6tdy3igx.htm There are several of those. There must be en emailproivider Exchange server  (not your localhost) to serve that. ... View more

try to run it in a macro, so you can build TITLE statement %MACRO DO_IT;   %LET A=05;   %LET B=02;   filename MAILBOX EMAIL  TO=("herman.jacobs@axa.be") TYPE='text/html' SUBJECT='test test' ;   %if &a GE &b %then %let text=' A >= B';   %else              %let text=' A <= B';   title;   title ">>>> &text";   ODS HTML BODY=MAILBOX RS=NONE ;     proc FREQ DATA=sashelp.class ;     TABLES sex;   RUN;   ODS HTML CLOSE; %MEND; %DO_IT; HERMAN ... View more

Hi, Try this... data have; input PROMOTION $25. TOTALS ; cards; TOTAL RECORDS             3329  TOTAL RECORDS ACCEPTED    3089 TOTAL RECORDS REJECTED     240 ; proc transpose data=have out=test; id promotion; var totals; run; data final; set test; Ratio=TOTAL_RECORDS_REJECTED/TOTAL_RECORDS_ACCEPTED; run; proc transpose data=final out=tt; run; Thanks, Shiva ... View more

Hi Sharmas, Try this..Hope it helps.. data have1(drop=date); input Date $ Identifier Value; date1 = mdy( substr(date,1,2),            1, substr(date,3,4) ); format date1 monyy7.; cards; 011980 3424 2.4 021980 3543 4.3 031980 432  5.5 121980 4332 011981 423 ; run; proc sort data=have1 ; by Identifier ; run; data have2(drop=date i); input Date Identifier Value; do i=1 to 12; date1=intnx('month',input(compress('Jan'||date),monyy7.),i); output; end; format date1 monyy7.; cards; 1979 432  4.2 1980 4332 1.2 1981 423  2.2 ; run; proc sort data=have2 ;by identifier ;run; data want; merge have1(in=a) have2(in=b); by identifier ; if b and a; run; Thanks, Shiva ... View more

PROC SQL is a procedure where as MERGE is a data step. PROC SQL takes longer time to run than MERGE when performing joins on large data sets. PROC SQL provides other potential advantages for communicating outside the SAS as SQL query is the standard method for specifying data requests from one database to another. PROC SQL is particularly appealing because of its simplicity and readability. ... View more