How to read data and time as a numeric variable?

[aminkarimid]

Hello everybody,

I have numeric variables which are showed below:

SAS Output:

Checking numeric variables in the patients data set
The MEANS Procedure
Variable	Label	N	N Miss	Minimum	Maximum
Price	Price	21174589	0	0.85	4050002
Turnover	Turnover	21174589	0	1	9.84E+08
Date	date	21174589	0	17615	19435
Time		21174589	0	30649	82126

I don't want to format variables and just want to read date and time variables of this table like hh:mm and dd:mm:yy.

How can I do that?

Thanks in advance

[HB]

Are you asking to have PROC MEANS display the minimum date as 21Jul1969 instead of 3489?

[aminkarimid]

Yes HB.

[ChrisNZ]

Did you paste this table from Excel?

[aminkarimid]

Yes ChrisNZ.

[ChrisNZ]

What you want is called formatting.
Why do you say you don't want it?

[aminkarimid]

Initial date and time variable were character and I formatted them to
numeric.

##- Please type your reply above this line. Simple formatting, no
attachments. -##

[ChrisNZ]

Just a bit of terminology so we all speak the same language:

Initial date and time variable were character were *converted*  to numeric, and now you want them *formatted* to date and time.

That's done with a format statement. For example:

format  DATEVAR date9.  TIMEVAR time.;

[aminkarimid]

Here is my code which is used to convert character variables to numeric:

data sampledata01;
set sampledata;
trd_event_dt = datepart(trd_event_dt);
format trd_event_dt date9.;
new_var = input(TRD_EVENT_TM,hhmmss.);
format new_var time5.;
drop TRD_EVENT_TM;
rename new_var = TRD_EVENT_TM;
run;

Explanation:
The trd_event_dt is Date.
The TRD_EVENT_TM is Time.

[ChrisNZ]

How about this?

data SAMPLEDATA01;
  set SAMPLEDATA;
  TRD_EVENT_DT = datepart(TRD_EVENT_DT);
  format TRD_EVENT_DT date9. TRD_EVENT_TM time.;
run;

[aminkarimid]

ERROR 48-59: The format $TIME was not found or could not be loaded.

[ChrisNZ]

Where did you see a $ in the code I posted?

$ formats are for character variables.

[ChrisNZ]

Or do you have a character variable?

What exactly do you have?

Provide: variable name, type, and value, for each of the 2 variables.

[Tom · Accepted solution]

How much does the format of the table matter to you?

Why not just have PROC MEANS generate a dataset and then print that?

data test;
 input id $ price turnover date time;
 format date date9. time time5. ;
cards;
min 0.85 1 17615 30649
max 4050002 9.84E+08 19435 82126
;

proc means noprint data=test;
 output out=xx ;
run;

proc print data=xx;
 where _stat_='N';
 format _all_;
run;

proc print data=xx;
 where _stat_ in ('MIN','MAX');
run;

Obs    _TYPE_    _FREQ_    _STAT_    price    turnover    date    time

 1        0         2        N         2          2         2       2


Obs    _TYPE_    _FREQ_    _STAT_         price     turnover         date     time

 2        0         2       MIN            0.85            1    24MAR2008     8:30
 3        0         2       MAX      4050002.00    984000000    18MAR2013    22:48