topic Re: Date Formatting issue in SAS Programming

Date Formatting issue

alexanthonymaj0 — Wed, 06 Feb 2019 07:41:59 GMT

Hi everyone,

I am getting all of my desired results, except my date formatting is incorrect. Currently, the date is formatted as "06-Aug-89" (it also comes up in the results this way) and I would like it to be formatted as 06/11/1989. Does anyone have any suggestions?

Here is my code:

libname employee '/home/alexanthonymaj0/my_courses/rahmansarker/c_8568';

data emp123;
length FirstName $ 14 LastName $ 20 JobTitle $ 22;
infile '/home/alexanthonymaj0/my_courses/rahmansarker/c_8568/emp_50490.csv' dlm=',';
input EmployeeID FirstName $ LastName $ Gender $ Salary JobTitle $ Country $ HireDate $;
format HireDate $ddmmyy. Salary dollar8.;
drop Gender Country;

run;

proc print data=emp123;
run;

Re: Date Formatting issue

PeterClemmensen — Wed, 06 Feb 2019 07:48:39 GMT

Hi and welcome to the SAS communities 🙂

Try this code

libname employee '/home/alexanthonymaj0/my_courses/rahmansarker/c_8568';

data emp123;
          length FirstName $ 14 LastName $ 20 JobTitle $ 22;
          infile '/home/alexanthonymaj0/my_courses/rahmansarker/c_8568/emp_50490.csv' dlm=',';
          input EmployeeID FirstName $ LastName $ Gender $ Salary JobTitle $ Country $ HireDate $;
          format HireDate ddmmyy10. Salary dollar8.;
drop Gender Country;

run;

proc print data=emp123;
run;

In your original code, you specified a character format (with a $). A date format is a numeric format. Also, remember to specify a length along with the format, as in ddmmyy10.

Re: Date Formatting issue

Astounding — Wed, 06 Feb 2019 08:32:00 GMT

With a slight modification to the end of the suggested INPUT statement which now reads:

... Hiredate $ ;

Change that to:

... Hiredate : date9. ;

That gives you a numeric date that you can format as ddmmyy10.

Re: Date Formatting issue

ballardw — Wed, 06 Feb 2019 15:48:10 GMT

https://communities.sas.com/t5/SAS-Communities-Library/Working-with-Dates-and-Times-in-SAS-Tutorial/ta-p/424354 has a PDF with much information about dates.