BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
garag
Calcite | Level 5

Hi,

I've the following problem managing date in SAS.

Here you are my code

proc sql;

   create table mycalendar as

    select distinct (datref - mynumber)   as mydatrf format = datetime20.

     from Library1.mydataset

;

quit;

Library1 points to a table on Oracle database where the field datref is a date and mynumber is numeric field.

My goal is to have the result of the query as "datetime20." SAS format but if I use the proc above it fails, because for example it the datref is 29/11/2011 and mynumber is -1 I get

29NOV2011:00:00:01 instead of 30NOV2011:00:00:00.

Any idea?

Many thanks

1 ACCEPTED SOLUTION

Accepted Solutions
art297
Opal | Level 21

Try it with:

proc sql;

   create table mycalendar as

    select distinct (datref - mynumber*24*60*60)   as mydatrf format = datetime20.

     from Library1.mydataset

;

quit;

View solution in original post

2 REPLIES 2
art297
Opal | Level 21

Try it with:

proc sql;

   create table mycalendar as

    select distinct (datref - mynumber*24*60*60)   as mydatrf format = datetime20.

     from Library1.mydataset

;

quit;

garag
Calcite | Level 5

Thanks it works.

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to choose a machine learning algorithm

Use this tutorial as a handy guide to weigh the pros and cons of these commonly used machine learning algorithms.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 2 replies
  • 770 views
  • 0 likes
  • 2 in conversation