Function to Split SaS Data-Set Column

[siddiqalimd]

Dear All,

I have Column(OrderDate) Consists of Value in date Format ( 05/10/2017) .

And I wold like to split the data value in three different columns to OrderDay ,OrderMonth,OrderYear 

Can any one help me how can I do this.

[Kurt_Bremser]

If OrderDate is a SAS date variable (days from 01/01/1960), then the functions year(), month() and day() will do the trick.

If it is not, convert it first.

[Shmuel]

to continue @Kurt_Bremser answer -

If the OrederDate is charachter type use function scan:

   day = scan(OrederDate,1,'/');

  mon = scan(OrederDate,2,'/');

  year = scan(OrederDate,3,'/');