topic SAS Date Format in New SAS User

SAS Date Format

aditikarande — Wed, 12 Aug 2020 08:33:12 GMT

Hi,

I have a data set with the following format in date column: 28feb2018:00:00:00.000. How do I write a code to count all the observations with the year 2018, 2019 etc.?

Any help would be much appreciated.

Thanks a lot.

Re: SAS Date Format

andreas_lds — Wed, 12 Aug 2020 08:39:34 GMT

Is the variable numeric and a format attached displaying it as datetime, or is it an alphanumeric variable?

If you already have a sas-dateime variable, try:

proc summary data=have nway;
  class datetime_var;
  format datetime_var dtyear4.;
  output out=counted(drop=_type_ rename=(_freq_=count));
run;

Code is untested.

Re: SAS Date Format

PeterClemmensen — Wed, 12 Aug 2020 08:40:55 GMT

Do something like this

data have;
   do dt = '01jan2018 00:00:00'dt to '31dec2020 00:00:00'dt by 3600;
      output;
   end;
   format dt datetime20.;
run;

proc freq data=have;
   table dt;
   format dt dtyear.;
run;

Re: SAS Date Format

Jagadishkatam — Wed, 12 Aug 2020 08:41:22 GMT

Please try the below code , please check the count dataset from proc freq

data have;
input datetime:anydtdtm.;
format datetime datetime20.;
cards;
28feb2018:00:00:00.000
;

data want;
set have;
year=year(datepart(datetime));
run;

proc freq data=want;
table year / out=count;
run;

Re: SAS Date Format

aditikarande — Wed, 12 Aug 2020 08:46:01 GMT

What does have signify?

Re: SAS Date Format

Jagadishkatam — Wed, 12 Aug 2020 08:47:29 GMT

have is the input dataset, since you did not provide the sample dataset, i created a sample dataset names as have and then used in subsequently

Re: SAS Date Format

aditikarande — Wed, 12 Aug 2020 09:41:00 GMT

I am getting an error with the do statement

Re: SAS Date Format

PeterClemmensen — Wed, 12 Aug 2020 09:42:33 GMT

Post your log please.

Re: SAS Date Format

aditikarande — Wed, 12 Aug 2020 10:00:01 GMT

also, what does cards signify?

Re: SAS Date Format

andreas_lds — Wed, 12 Aug 2020 10:06:48 GMT

What about good, old RTM?

SAS-Docs are at https://documentation.sas.com/?cdcId=pgmsascdc&cdcVersion=9.4_3.4&docsetId=pgmsashome&docsetTarget=home.htm&locale=en

Re: SAS Date Format

Jagadishkatam — Wed, 12 Aug 2020 10:27:26 GMT

In order to put the data using the input statement we can use either cards or datalines , indicating that after these statements the data portion starts