topic Re: Date format in SAS Programming

Date format

mrinmoy — Wed, 29 Mar 2017 09:06:22 GMT

Q1.I am running the below code snippets to get the b_date from Birth_Date

data birth;

set credit card;

b_date= input(Birth_Date,10.);

format b_date date9.

run;

Why for Birth_Date 01/08/1966, b_date = 22JAN1960 ?

Q2. Running the below code Snippets.

data birth;

set credit card;

b_date= input(Birth_Date,10.);

run:

Why for Birth_Date 01/08/1966, b_date = 21?

Q3) Running the below code Snippets.

data birth;

set credit card;

b_date= put(Birth_Date,10.);

run:

Why for Birth_Date 01/08/1966, b_date = 2199?

Re: Date format

PeterClemmensen — Wed, 29 Mar 2017 09:13:20 GMT

Can you provide some sample data?

Re: Date format

mrinmoy — Wed, 29 Mar 2017 09:21:10 GMT

can you please try with the date which has been given in the question

Re: Date format

Kurt_Bremser — Wed, 29 Mar 2017 09:33:00 GMT

You need to give us a sample of your datasets credit and card (as yout set statement adresses those two datasets).

We need this to see the actual values and the variable types and attributes.

Provide the data in a data step; a macro that converts your dataset to a data step for posting is found here:

https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-data-AKA-generate/ta-p/258712

When posting, use the "little running man" or {i} icons. These preserve formatting and prevent reformatting of supposed smileys etc.

Re: Date format

mrinmoy — Wed, 29 Mar 2017 10:04:24 GMT

PFA for sample data set

Re: Date format

Kurt_Bremser — Wed, 29 Mar 2017 11:11:03 GMT

The problem is that a csv file does not convey column attributes in any way, which are essential in getting the right answers.

Or do you mean that you do not yet have a SAS dataset and need proper import code for the csv also?

Re: Date format

Astounding — Wed, 29 Mar 2017 10:34:22 GMT

Board monitors,

Perhaps it's time to compare this to:

https://communities.sas.com/t5/General-SAS-Programming/PUT-and-INPUT/m-p/345080#M44559https://communities.sas.com/t5/General-SAS-Programming/PUT-and-INPUT/m-p/345080#M44559

Looks like there's a homework assignment here.

Re: Date format

Kurt_Bremser — Wed, 29 Mar 2017 11:10:05 GMT

Oh, yeah, some people need to get a grasp on the concept that homework assignments want to test THEIR brains, not OURS.

Re: Date format

mrinmoy — Wed, 29 Mar 2017 11:11:52 GMT

The data set i have importeed correctly but I am not understanding why I am getting different out put while using put and input

please help me on that

Re: Date format

Kurt_Bremser — Wed, 29 Mar 2017 11:19:11 GMT

Show the code with which you imported the csv, so we can recreate your dataset.

Or use the macro I previously mentioned to convert your dataset into a data step for posting here.

Re: Date format

ccarel — Wed, 29 Mar 2017 14:35:09 GMT

Q1.I am running the below code snippets to get the b_date from Birth_Date

data birth;

set credit card;

b_date= input(Birth_Date,10.);

format b_date date9.

run;

Why for Birth_Date 01/08/1966, b_date = 22JAN1960 ?

Answer: The b_date is 22JAN1960 b/c that is the DATE9. format that you requested in the code. You also need a semicolon (;) after DATE9.

Re: Date format

ballardw — Wed, 29 Mar 2017 18:20:08 GMT

Adding to @ccarel

The value of Birth_date apparently is already a SAS date value. Run proc contents on your data set and I bet you see Birth_date has Format mmddyy10.

What you did with this code:

b_date= input(Birth_date,10.);

was ask SAS to convert the existing value of Birth_date to a string value that the INPUT function requires. The unformatted value of 08Jan1966 is 2199. When SAS does the requested conversion it uses the best12. format so the resulting string 12 characters long with a value of 8 blanks followed by 2199. Then you tell SAS to read that value with 10. format so it reads the first 10 characters. The only numerals there are 21 so the result is 21. When you format that as a date you get 22 Jan 1960 because 0 is 1 Jan 1960 and dates are number of days from 1 Jan 1960. So add 21 = 22 Jan 1960.

If your value had actually been the string '01/08/1966' there would have been an error because that is not valid to read with the 10. informat.

Your log when you ran the code would have message about "Numeric values have been converted to character values at the places given by :

(Line):(Column).

the line and column shown would point to the location of Birth_date in the input function argument.