For each ID, it has year, month, and day observations.  I want to get the five largest numbers within each month for each ID. How to get it? I can use "proc sort; by ID year month obs" to rank the obs within each month, but I do not know how to get only the five largest numbers. Thanks! ... View more

How to convert the following Charater to Date format?   For example, raw variable DATE "01 MAR 2013 00:00:02.358". The length is 24. There are space between '01' and 'MAR' and '2013' and '00'.   How to seperate it into two column '03/01/2013' + 'hh:mm:ss:sss' or 'hh:mm:ss'. Both are date format. Thanks!   ... View more

Hello, I have a set of time series of date data (see below). But the type of data is 'Numerical', the Format is 'Best12.' and informat is 12.''. When I use the code 'year(date)', I get wrong outcome. How to manipulate these date data if I want to get '1960 for year and 01 for month of first obs' using codes 'year(date) and month(date)'? Thanks date 196001 196002 196003 196004 ..... ..... ... View more

I have the following dataset. I want to merge the amount of IID in the same day for each ID. How to convert the data in the left into the data in the right? It does not matter for IID. Thanks   ID               Date         Volume   IID        Amount                  ID               Date            Volume   IID        Amount 1001      01/12/1980        50000    01         10000                 1001          01/12/1980        50000     ?         14200 1001      01/12/1980        50000    03          200                    1001          02/13/1980        55000     ?         14123 1001      01/12/1980        50000    02          4000        ==>     .... 1001      02/13/1980        55000    01         10009                  1009          01/12/1980        70000    ?         10200 1001      02/13/1980        55000    03          234                     1009          02/13/1980       79000     ?         10243 1001      02/13/1980        55000    02          3880 .... 1009      01/12/1980        70000    01         10000 1009      01/12/1980        70000    03          200 1009      02/13/1980        79000    01         10009 1009      02/13/1980        79000    03          234 ..... ... View more

I already use the 'proc rank' to rank data based on criteria A, for example, stocks are ranked into 10 groups based on returns. Then I want to further rank the data within each group based on criteria B. How to rank such way in a dataset? Thanks   ID        DATE     A     B 109                      1     1 678                      1     2 567                      1     3 ..... 189                      2     1 608                      2     2 597                      2     3 ..... 489                      3     1 408                      3     2 997                      3     3 ..... ... View more

I want to delete the data in 01/14/2005, format is MMDDYY10. I use the following code 'if date=01/14/2005 then delete; run;', but it does not work. How to delete it? Is any special code to delete date data? I succeed in deleting data in other format. Thanks ... View more