topic Re: Function to Split SaS Data-Set Column in SAS Programming

Function to Split SaS Data-Set Column

siddiqalimd — Wed, 10 May 2017 08:13:57 GMT

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 — Wed, 10 May 2017 08:16:23 GMT

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 — Wed, 10 May 2017 08:34:40 GMT

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,'/');