topic Re: Transforming date values from 07/20/2022 to 20220720 keeping the column in alphanumeric format in New SAS User

Transforming date values from 07/20/2022 to 20220720 keeping the column in alphanumeric format

Abelp9 — Thu, 21 Jul 2022 12:58:11 GMT

Hello everyone, I am new to programming in sas and in a table I have an alphanumeric column called "day" that contains values in text format: 07/20/2022 and I want to convert it to 20220720 (yyyymmdd).

How could I change the values of this table?

Thank you very much in advance, I would also appreciate any type of documentation where I can read about this

Re: Transforming date values from 07/20/2022 to 20220720 keeping the column in alphanumeric format

Astounding — Thu, 21 Jul 2022 13:03:20 GMT

There are actually three topics you would have to study: the PUT function, the INPUT function, and how SAS handles dates. With that knowledge, it only take one statement (within a DATA step):

day = put(input(day, mmddyy10.), yymmddn8.);

Re: Transforming date values from 07/20/2022 to 20220720 keeping the column in alphanumeric format

kelxxx — Thu, 21 Jul 2022 13:31:55 GMT

data have;
date="07/20/2022";
run;

data want; 
set have;
format date2 YYMMDDN8.;
date2 = input(date, mmddyy10.);
run;

hello, you can find a lot of similar topics in the forum.

Re: Transforming date values from 07/20/2022 to 20220720 keeping the column in alphanumeric format

ballardw — Thu, 21 Jul 2022 14:01:07 GMT

Why would you want a character "date"?

They don't work well as graph axis.

You have to go through a similar two-step every time you want to display a date in a different form for any purpose.

You will have to add variables to the data set to create any sort of report group such as monthly, quarterly or annually that can be accomplished with report or analysis procedure simply by changing the format in procedures like Proc Report, Tabulate, Means, Summary , Univariate and the list goes on.

Then there is the bit about dealing with anything that wants to use the difference between dates.

For almost any use leave it as the SAS date value and apply formats as desired.

Re: Transforming date values from 07/20/2022 to 20220720 keeping the column in alphanumeric format

Reeza — Thu, 21 Jul 2022 14:59:44 GMT

Here's a great, but longer and in depth, reference for dates and times in SAS
https://communities.sas.com/t5/SAS-Communities-Library/Working-with-Dates-and-Times-in-SAS-Tutorial/ta-p/424354

Re: Transforming date values from 07/20/2022 to 20220720 keeping the column in alphanumeric format

Kurt_Bremser — Thu, 21 Jul 2022 15:09:36 GMT

You do NOT want to store dates in character variables in SAS. Convert the character strings to numeric date values, and apply a suitable format:

data _null_;
chardate = "07/20/2022";
numdate = input(chardate,mmddyy10.);
format numdate yymmddn8.;
put numdate=;
run;