BookmarkSubscribeRSS Feed
siddiqalimd
Calcite | Level 5

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.

2 REPLIES 2
Kurt_Bremser
Super User

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
Garnet | Level 18

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

 

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 2 replies
  • 749 views
  • 0 likes
  • 3 in conversation