topic HelloRe: How to concatenate date variables to create numeric date value in SAS Programming

How to concatenate date variables to create numeric date value

strong_s — Thu, 05 Nov 2020 22:22:12 GMT

Hi all,

I am trying to concatenate three date variables into a single numeric date value. The separate variables are day, month, and year. I am trying to concatenate the three variables into a single numeric date value and am struggling. I am wondering if I am using the wrong informat or if I am nesting my functions inappropriately. Here is my code:

DATA	WORK.Want;
SET Work.Have;
BirthDt = INPUT(CAT(BirthMonth, BirthDay, BirthYear), ANYDTDTE9.);
	RUN;

Thank you for the help!

Re: How to concatenate date variables to create numeric date value

ballardw — Thu, 05 Nov 2020 22:30:22 GMT

You don't show what the values of Birthmonth etc look like.

If they are numeric values then the better approach would be

Birthdt = mdy(birthmonth, birthday, birthyear);

format birthdt date9.;

Re: How to concatenate date variables to create numeric date value

strong_s — Thu, 05 Nov 2020 22:32:19 GMT

Sorry about that, the date variables are as follows:

BirthMonth: 12

BirthDay: 7

BirthYear: 1995

Re: How to concatenate date variables to create numeric date value

strong_s — Thu, 05 Nov 2020 22:33:39 GMT

This worked! Thank you so much!

Re: How to concatenate date variables to create numeric date value

ballardw — Thu, 05 Nov 2020 22:51:15 GMT

If you will be working with dates much you may want to check out: 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.

HelloRe: How to concatenate date variables to create numeric date value

GoldingAngela — Fri, 06 Nov 2020 01:31:14 GMT

Hello!

Try using an assignment statement to concatenate the date variables into a singular numeric variable.

DATA WORK.Want;

SET WORK.Have;

BirthDt = MDY(BirthMonth, BirthDay, BirthYear);

RUN;

I hope this was helpful!

- A.G.