cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
yawen929
‎03-21-2024
  • 4 Posts
  • 2 Likes Given
  • 0 Solutions
  • 0 Likes Received

Converting Date and Time to Character

by Fluorite | Level 6 in SAS Programming
‎03-20-2024 11:29 PM
‎03-20-2024 11:29 PM
Hello!   For reporting purposes, I am trying to convert numeric datetime records to character. I have the following:   HAVE (Numeric, datetime22.3) WANT (Character) 19APR2022:00:00:00.000 2022-04-19 11MAY2021:12:24:00.000 2021-05-11T12:24 20APR2022:00:00:00.000 2022-04-20 09MAR2021:10:21:00.000 2021-03-09T10:21 13APR2021:08:25:00.000 2021-04-13T08:25 30MAR2021:12:12:00.000 2021-03-30T12:12 22FEB2024:16:25:00.000 2024-02-22T16:25 12OCT2020:00:00:00.000 2020-10-12   How would I get a character result for the HAVE variable? I have tried: WANT=put(datepart(HAVE),yymmdd10.); but this does not include the time part.   I also tried: WANT=put(datepart(HAVE),datetime22.3); but it only gives me 01JAN1960:xx:xx:xx.000 for each record, not the actual date.   Is it possible to do this another way? Any guidance would be appreciated. Thank you in advance!     Best, Yawen ... View more

Re: Using ODS PACKAGE to create ZIP files without Changing Timestamp

by Fluorite | Level 6 in New SAS User
‎10-10-2019 02:54 PM
‎10-10-2019 02:54 PM
Hello Tom,    A beginner error, thanks for catching it! I don't know if you might know the answer to this question, but now I am getting a new error message:   'zip' is not recognized as an internal or external command, operable program or batch file.   Can you please advise? Thank you!     Best, Yawen  ... View more

Re: Using ODS PACKAGE to create ZIP files without Changing Timestamp

by Fluorite | Level 6 in New SAS User
‎10-10-2019 02:42 PM
‎10-10-2019 02:42 PM
Hello Kurt,   I am using the following code for retaining timestamps but it isn't working quite right:   filename oscmd pipe 'zip &outpath./&zipname..zip &datafolder./have.sas7bdat 2>&1'; data _null_; infile oscmd; input; put _infile_; run;   Is the issue with macro variables? Thank you!     Best, Yawen ... View more

Using ODS PACKAGE to create ZIP files without Changing Timestamp

by Fluorite | Level 6 in New SAS User
‎07-29-2019 05:44 PM
‎07-29-2019 05:44 PM
Hello, I followed this guide to create ZIP files of SAS datasets, but it messes with the timestamps and capitalizes all original file names. Is there a way to make it so the timestamps and file names aren't changed? Please find the sample code below. Thank you!     ods package (EXAMPLE) open nopf; %macro zip(); %do i = 1 %to &cnt; %let dataset = %scan(&list, &i); ods package (EXAMPLE) add file="&datafolder.\&dataset..sas7bdat"; %end; %mend zip; %zip ods package (EXAMPLE) publish archive properties(archive_name="&zipname..zip" archive_path="&outpath."); ods package (EXAMPLE) close;   ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎03-21-2024 05:15 PM
Likes given to
View All
Quick links