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


Hello,  you folks helped me out immensely with figuring out how to turn the date of 1/1/1960 into a real date to be stored in an Oracle table.  I have another question on how to turn that date, which is the CURRENT date, into the PREVIOUS days date.  The following is the code.

*  This gets the current Date.

%let curday=%sysfunc(date(), date9.);

%put &curday;

* This loads the records into an Oracle table.  the date portion  hos_date is the date 7/25/2013 12:01:01 PM.  I want it to be Yesterday's Date of 7/24/2013 12:01:01 PM

proc sql;
insert into safety.safety_hrs_svc

select dhms("&curday"d,12,01,01) as hos_date, STATION, CONTR_ID, CONTR_NAME, PRIM_SVC_AREA_ID, DRIVER_NBR, DRIVER_NAME, PCK_DELV_HRS, SPOT_HRS, LINEHAUL_HRS from work.safety_hrs;
quit;

Thank you very much.

1 ACCEPTED SOLUTION

Accepted Solutions
Fleroo
Calcite | Level 5

Bruno......... BANG.  YOU NAILED  IT.  Man you're good.   Do you want to fly to Pennsylvania ?   :smileylaugh:

THANKS ALL.... I LUV THIS BOARD

View solution in original post

6 REPLIES 6
OS2Rules
Obsidian | Level 7

Try:

%let preday=%sysfunc(date()-1, date9.);

Fleroo
Calcite | Level 5

OS2, that generates the following error..... cut from the log.

11         %let prevday=%sysfunc(date()-1, date9.);

ERROR: Expected close parenthesis after macro function invocation not found.

Thanks so much for looking.

OS2Rules
Obsidian | Level 7

My Bad:

use:

CALL SYMPUT('predte',put(date()-1.date9.));

BrunoMueller
SAS Super FREQ

Fleroo


Check this code:
%let curday=%sysfunc(PUTN(%eval(%sysfunc(date()) - 1), date9.));
%put NOTE: &=curday;
Fleroo
Calcite | Level 5

Bruno......... BANG.  YOU NAILED  IT.  Man you're good.   Do you want to fly to Pennsylvania ?   :smileylaugh:

THANKS ALL.... I LUV THIS BOARD

Haikuo
Onyx | Level 15

You can also use INTNX:

%let curday=%sysfunc(intnx(day,%sysfunc(date()), -1),date9.);

%put NOTE: &=curday;

Haikuo

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!

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 6 replies
  • 8965 views
  • 1 like
  • 4 in conversation