topic Re: Formating Time display when proc exporting in SAS Programming

Formating Time display when proc exporting

Q1983 — Sat, 09 Mar 2019 18:43:51 GMT

data have;

input ID DATE DATE9. TIME TIME.;

format date date9.;

format time hhmm.;

datalines;

12 31dec2018 12:10:02

12 11dec2018 12:11:02

;

run;

PROC EXPORT Outfile= "\\Shared\DPMS\have.xls"

DATA= have

/*label /*replace with label name*/

DBMS= EXCELCS REPLACE;

SHEET='DATA';

SERVER='saspcff';

ID DATE TIME

12 12/31/2018 1/0/1900

12 12/11/2018 1/0/1900

As you can see the TIME exports as 1/0/1900. Is there a way to preserve the actual time as a time format. The report will e dumped into another program thus the formats must remain. In this case I want the time to retain as 10:12 and 11:12

Re: Formating Time display when proc exporting

VDD — Sat, 09 Mar 2019 19:04:59 GMT

if you use datetime32. for the format will it work

data have;
input ID DATE DATE9. TIME TIME.;
format date datetime32.;
format time hhmm.;
datalines;
 
12 31dec2018 12:10:02
12 11dec2018 12:11:02
;

run;

Re: Formating Time display when proc exporting

Ksharp — Sun, 10 Mar 2019 12:03:47 GMT

Turn it into CHARACTER variable ?

Re: Formating Time display when proc exporting

Tom — Sun, 10 Mar 2019 17:18:42 GMT

Do you have to use EXCELCS engine? Do you really need to create the old (really old) XLS format?

Why not just let SAS write the file directly using the XLSX engine?

PROC EXPORT Outfile= "c:\downloads\have.xlsx" dbms=xlsx replace
  data=have
;
run;

Re: Formating Time display when proc exporting

VDD — Sun, 10 Mar 2019 17:33:54 GMT

based on the userid I would say that they are dealing with old version of Excel along with the newer versions.

anyway it should not mater to a good programmer if the requested results are to be in versions of xls, xlsx, csv, txt or even if the file has NDX or AD1 on the end. Data is data, and the process of providing the results are part of the business requirements gathering for the project or task that is to be preformed. Most of the time we as the data results providers need to confirm that the managers, departments or groups that may be backing the request understand what they are asking for. Most of the time they are just picking at the tip of the iceberg.