Please have a look at the following code: FILENAME newemail EMAIL TO="xxx@xxx.com" SENDER="xx" SUBJECT="Place to go"; %MACRO sender;   %DO i=1 %TO 5;     Timer=SLEEP(2); /*Wait for 20 mins*/     DATA _NULL_;       SET work.place(WHERE=(min=minute(timepart(datetime()))));       FILE newemail;       PUT "Now go to: " place;     RUN;   %END; FILENAME newemail CLEAR; %MEND; %sender Because of the RUN statement, SAS produced the following error message: 9              Timer=SLEEP(2);                -----                180 MPRINT(SENDER):   Timer=SLEEP(2); ERROR 180-322: Statement is not valid or it is used out of proper order. If the RUN statement is removed, then it worked perfectly. Why this happened? ... View more

Hi sir, I am thinking to run a piece of code every one hour, up to 5 times. I tried to use the wakeup function, but not worked. Do you know to achieve this task? Thanks a lot.  ... View more

Hi, Can I merge two files using indexes which is said to be quicker than sort? As an example, if I need to merge two files based on variables sex and agegrp. The following is wrong: PROC DATASETS LIBRARY=work; MODIFY file01; INDEX CREATE sex agegrp; MODIFY file02; INDEX CREATE sex agegrp; RUN; DATA work.file03;      MERGE work.file01 work.file02;      BY sex agegrp; RUN; ... View more

Hi Sir, sorry to bother. I really like to understand the default coding method used in the LOGISTIC procedure. SAS manual said the default one is 'Effect coding'. I used this default setting and got the results as below. Note the model has an interaction term age*use. My questions are: 1) how to interpret the coefficents of the interaction term? 2) how to calculate the coefficents for the other groups of the interaction term? Age has the other group 'M', and use has the other group 'T'. So I want to get the coefficents for age='D' & use='T', age='G' & use='T', age='O' & use='T', age='M' & use='T'. I spent a lot of time searching on the internet about 'effect coding', interaction, but cannot find any useful learning resources. Any recommendation of textbooks? Many thanks a lot for help. The LOGISTIC Procedure                 Analysis of Maximum Likelihood Estimates                                  Standard          Wald Parameter       DF    Estimate      Error    Chi-Square    Pr > ChiSq Intercept       1     -3.5735      0.0138    66945.2041        <.0001 age     D       1     -0.1990      0.0171      136.2082        <.0001 age     G       1      0.0993      0.0245       16.3795        <.0001 age     O       1      0.2356      0.0284       68.8867        <.0001 use     B       1      0.0716      0.0162       19.6340        <.0001 use     C       1     -0.4513      0.0245      338.7862        <.0001 age*use D B     1     0.00122      0.0200        0.0037        0.9514 age*use D C     1     -0.0115      0.0301        0.1474        0.7010 age*use G B     1      0.0727      0.0287        6.4342        0.0112 age*use G C     1     -0.0459      0.0444        1.0681        0.3014 age*use O B     1     -0.0953      0.0333        8.2016        0.0042 age*use O C     1      0.0834      0.0500        2.7795        0.0955 ... View more

SAS said there is syntax error for &j: %MACRO calnum;   %DO j=1 %TO 2;   %DO i=1 %TO 10;      PROC UNIVARIATE DATA=work.data&j;        VAR diff;        OUTPUT OUT=work.pctile&j%SYSFUNC(PUTN(&i,z2.)) PCTLPRE=P&j_ PCTLPTS=1 to 100 BY 1;      RUN;   %END;   %END; %MEND; It seemed that the use of work.data&j is fine, but it is error to specify it as: PCTLPRE=P&j_   How can I put this right? ... View more