topic Re: How to read data and time as a numeric variable? in SAS Programming

How to read data and time as a numeric variable?

aminkarimid — Tue, 25 Jul 2017 19:55:04 GMT

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

Re: How to read data and time as a numeric variable?

HB — Tue, 25 Jul 2017 21:28:25 GMT

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

Re: How to read data and time as a numeric variable?

ChrisNZ — Wed, 26 Jul 2017 06:27:14 GMT

Did you paste this table from Excel?

Re: How to read data and time as a numeric variable?

aminkarimid — Wed, 26 Jul 2017 11:27:24 GMT

Yes HB.

Re: How to read data and time as a numeric variable?

aminkarimid — Wed, 26 Jul 2017 11:27:52 GMT

Yes ChrisNZ.

Re: How to read data and time as a numeric variable?

ChrisNZ — Wed, 26 Jul 2017 11:50:35 GMT

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

Re: How to read data and time as a numeric variable?

aminkarimid — Wed, 26 Jul 2017 14:45:39 GMT

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

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

Re: How to read data and time as a numeric variable?

ChrisNZ — Wed, 26 Jul 2017 21:19:57 GMT

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.;

Re: How to read data and time as a numeric variable?

aminkarimid — Wed, 26 Jul 2017 21:41:52 GMT

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.

Re: How to read data and time as a numeric variable?

ChrisNZ — Wed, 26 Jul 2017 22:11:32 GMT

How about this?

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

Re: How to read data and time as a numeric variable?

aminkarimid — Wed, 26 Jul 2017 22:27:00 GMT

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

Re: How to read data and time as a numeric variable?

ChrisNZ — Wed, 26 Jul 2017 23:25:27 GMT

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

$ formats are for character variables.

Re: How to read data and time as a numeric variable?

ChrisNZ — Wed, 26 Jul 2017 23:27:15 GMT

Or do you have a character variable?

What exactly do you have?

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

Re: How to read data and time as a numeric variable?

Tom — Thu, 27 Jul 2017 02:14:12 GMT

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