Hello,
I am getting the path and file name using a unix command.
Then I would like to get the month (see two string examples below)
/.../prod1010.saa1fm.data/polices_sep2013.sas7bdat
/.../pa.pxbtxax.sabtxfaa.dec2013.data/pa.pxbtxax.sabtxfaa.data/police.sas7bdat
In the first example the month is equal to sep while into the second example the month is dec.
I could use the find function as below
data test1;
set text1;
if find(text, 'jan') gt 0 then month='jan'
...
if find(text, 'sep') gt 0 then month='sep'
...
if find(text, 'dec') gt 0 then month='dec'
run;
I wonder if there is a more efficient way to do that if I have the following month:
jan, fev, mar, avr, mai, jun, jui, aou, sep, oct , nov, dec.
... View more