topic Re: Converting EURDFDD10. to DATE9. using Enterprise Guide in SAS Programming

Converting EURDFDD10. to DATE9. using Enterprise Guide

J_squared — Thu, 07 May 2015 14:46:59 GMT

Hello!

I have a .csv file that is an extract from SAP. The all dates have the following format: dd.mm.yyyy. I would like to properly convert this to DATE9. format using EG. Any suggestions?

-Joshua

Re: Converting EURDFDD10. to DATE9. using Enterprise Guide

ballardw — Thu, 07 May 2015 15:19:15 GMT

Read the variable(s) using the ddmmyy format and assign the date9. format.

And you aren't "converting" but creating a SAS date valued variable. Then you can display and manipulate the variables with many formats or date functions.

data test;
informat date ddmmyy10.;
input date;
format date date9.;

datalines;
15.04.2012
;
run;

Re: Converting EURDFDD10. to DATE9. using Enterprise Guide

ChrisHemedinger — Thu, 07 May 2015 15:40:08 GMT

And if you're using the Import Data task to accomplish this, you can Modify the input Source Informat on the Field Attributes screen. Select the column, click Modify, then specify the DDMMYY10. informat:

Re: Converting EURDFDD10. to DATE9. using Enterprise Guide

J_squared — Thu, 07 May 2015 16:27:05 GMT

Thank you very much! That worked nicely!

Re: Converting EURDFDD10. to DATE9. using Enterprise Guide

J_squared — Thu, 07 May 2015 16:37:15 GMT

Thanks, Chris! I also used your suggestion regarding the ANYDTDTE informat... I changed the default field attribute for this variable from Type: String to Type: Date and then changed the Input format from DATE9. to ANYDTDTE10. as well... The output looks correct!

Re: Converting EURDFDD10. to DATE9. using Enterprise Guide

ChrisHemedinger — Thu, 07 May 2015 16:52:52 GMT

Great! Just keep in mind that the OPTIONS DATESTYLE= value will influence how the "ambiguous" dates turn out when using the ANYDT* collection of SAS informats.

options datestyle=mdy; /* 01.12.2015 will come in as 12JAN2015 */

options datestyle=dmy; /* 01.12.2015 will come in as 01DEC2015 */

You can add the proper option as a SAS program node ahead of the Import Data step to control this. You might also want to set it back to the default (DATESTYLE=LOCALE) when done.

Re: Converting EURDFDD10. to DATE9. using Enterprise Guide

J_squared — Thu, 07 May 2015 17:30:10 GMT

Like this...

The datestyle program contains the following...

Re: Converting EURDFDD10. to DATE9. using Enterprise Guide

ChrisHemedinger — Thu, 07 May 2015 17:52:20 GMT

You got it! Such a fast learner.

Don't tell the others, but you were one of my best students in our class. I don't like to play favorites, but you were definitely in the top 6.

Re: Converting EURDFDD10. to DATE9. using Enterprise Guide

J_squared — Thu, 07 May 2015 18:21:01 GMT

LOL a pupil is only as good has his/her instructor!