I am using this code for SAS Base and I could pull the data from share drive to the SAS. I need to do the same think for EG.   LIBNAME DMP "C:\9 - DATADMP";   FILENAME PSM "S:\IR-mon\12 Data\RT4\PSID.TXT"; DATA DMP.STT_HS; INFILE PSM LRECL = 80; INPUT @5 FICE $6.; RUN;     ... View more

I have a code as below, i need to take the select max(date) in seperate code. it takes so much time. How can i seperate them This is the code      proc sql; create table aa as select     a.vid,              a.activity_date,              a.hour,              a.from_date,             b.req,           b.perehis_act_date from stg.coa a,         stg.wte  b  where a.EMPLOYEE_PIDM = b.perehis_pidm and b.perehis_act_date = (select max(x.perehis_act_date)                                        from stg.wte x                                        where x.perehis_pidm=b.perehis_pidm                                     and x.perehis_Act_date <= a.from_date ) and datepart(a.from_date) <= (select max(datepart(e.end_date))                                          from stg.comp e                                         where today()GE datepart(e.end_date)+14); quit;     I need this query to simple couple query. Thank you ... View more

I have a table as below:     id        term        table   2          2015      bal   2          2016      bal   2          2016      tas   3          2014      som   3          2015      som  4           2015     som  4           2016     bal  4           2016      cim   i need if same id and same term change the table name as 'BOTH'  like the table as below   id        term        table   2          2015      bal   2          2016      BOTH   3          2014      som   3          2015      som  4           2015     som  4           2016     BOTH     ... View more

I need to compare 2 date : One of them is in character value 20$ and looks "2016-04-01 14:30:29" Other one is numeric datettime20. and looks "05AUG2002:09:15:55"   i will compare them, how can i convert it?   ... View more

I have an example table as below   id     term     subj      prof           hour 20    2016    COM    James         4 20    2016    COM    Henrey        4 30    2016    HUM    Nelly            3 30    2016    HUM    John            3 30    2016    HUM    Jimmy         3 45    2016   CGS     Tim              3   I need to divide hours if the id- term and subj same. There are 2 different prof with same id:20 - term and subj, so i divided hour 2. There are 3 different prof with same id : 30 - term and subj. So i divided hour 3.  So the output should be like this;   id     term     subj      prof           hour 20    2016    COM    James         2 20    2016    COM    Henrey        2 30    2016    HUM    Nelly            1 30    2016    HUM    John            1 30    2016    HUM    Jimmy         1 45    2016   CGS     Tim              3   ... View more

I need to find who has in order A-B-C. Please check the table for example;   id          term        grade      subj      num 10         2002        D            332        1  10         2002        A              333       2 11         2005        C             232       1  11         2005        A             232         2 11         2005        B             232        3 11         2005        C             232       4 15         2010       A              130        1 15         2010       B               130        2 15         2010       C              130        3    What i need fromthis table is  id : 11 AND 15   The output should be like  id   term   subj 11   2005   232 15  2010    130    So i need list the id's that had Grade of 'A' in it then was changed to 'B' then it was changed to 'C' . Num could be in order. It dosen't have to start from 1, it could be 1 or 2 or 3, etc. But it  should be in order A then B then C     ... View more