Hi guys,  I have a data set with dates in really really all types of "formats" like: 01/1/2001, 1/1/2001, 1/01/2001, 1/1/00, 01/1/00, 1/01/00. Is there a quick way to format all these exceptions in dd/mm/yyyy?  Thank you very much. If I use for example: format date*, does it will take all the exceptions? The records are really many and so I cannot check for each single case. I must be sure that all the dates are in the same file format.   Thank you in advance ... View more

Hi guys,  suppose to have the following:      data DB1; input ID :$20. (Start End)(:date9.) Absence_reason :$20.; format Start End date9.; cards; 0001 01JAN2015 06FEB2015 vacation 0001 02JAN2015 02JAN2015 vacation 0001 13APR2015 31DEC2015 sick leave 0002 01JAN2017 12JUL2017 vacation 0002 12JUN2017 18JUN2017 vacation ...;   I would like to remove records having the same (!)  "absence reason" when the period falls into a larger one. For example for 0001, the row 02JAN2015 -  02JAN2015 should be removed because already in 01JAN2015 - 06FEB2015. The same for 0002 relative to 12JUN2017  -  18JUN2017. It is clearly an error in the file I received to perform the analysis.    Desired output:      data DB1; input ID :$20. (Start End)(:date9.) Absence_reason :$20.; format Start End date9.; cards; 0001 01JAN2015 06FEB2015 vacation 0001 13APR2015 31DEC2015 sick leave 0002 01JAN2017 12JUL2017 vacation ...;   ... View more

Hi guys,  suppose to run a proc freq with an output that looks like this:      ID     Freq    Perc     .. 0001    .....      ..... 0002    .....      ..... 0008    .....      ..... 0005    .....      ..... .......     .....      .....            Suppose also to have a data set that looks like this:      ID     Value1    Value2    .. 0001    .....      ..... 0002    .....      ..... 0003    .....      ..... 0004    .....      ..... .......     .....      .....               Is there a way to remove from the data set the IDs that appear in proc freq output?  Desired output:    ID     Value1    Value2    .. 0003    .....      ..... 0004    .....      ..... .......     .....      .....             Thank you in advance ... View more

Hi, how can I add suffix to Ids based on a column? Suppose to have: Id suffix 0001 1 0001 1 0001 2 0002 2 0002 2 0002 1 Desired output Id 0001_1 0001_1 0001_2 0002_2 0002_2 0002_1 Thank you in advance ... View more

Hi guys, suppose to have:          Id               Place         A                Hosp1        A                Hosp2        B                Hosp1        B                Hosp1        C                Hosp3        C                Hosp4   I would like the following:        Id                Place         C                Hosp3        C                Hosp4   So I if Place =Hosp1 delete not only the single record but instead the entire Id. Basically I would like to remove Ids containing Hosp1. Can anyone help me please? Thank you very much ... View more

suppose to have the following: Value 1 1 1 2 2 2   How can I say/indicate: the last 1 before 2 and the first 2 after the last 1? Thank you in advance ... View more