About BU2B

RW9 · ‎05-23-2018

proc sort data=meter out=loop nodupkey; by meter; run; data _null_; set loop; call execute(cats('data meter_',meter,'; set meter; where meter="',meter,'"; run;')); run; No loops, no macro code, no restrictions on number of elements etc. Although as before, splitting data up into smaller datasets is not a good idea from storage or coding point of view.

ballardw · ‎03-09-2018

@BU2B wrote: Solved: Instead of "sas.LocalProvider.9.4", it's "sas.LocalProvider.9.43". So the actual problem was in the line obConnection.Provider = "sas.LocalProvider.9.2" which you had indicated "Yeah that's not it. That was the first thing I tried"

BU2B · ‎12-18-2015

That worked, thanks so much!

BU2B · ‎11-11-2015

Thanks guys! I got that to work with a couple of tweeks... I appreciate it! Steve

BU2B · ‎10-23-2015

Thanks guys! I really apreciate it. have a good weekend... Steve

sbb · ‎07-13-2015

Consider the opportunity to move some part of your SYSIN to a separate file (containing the SAS code-piece), and then use a %INCLUDE statement to invoke that code in-line where needed within your base SAS program. Scott Barry SBBWorks, Inc.

BU2B · ‎06-24-2015

Thanks guys! I'm sure all of them would work, but I got the last one to work first. Thanks again! Steve

BU2B · ‎04-28-2015

Doh! OK I feel stupid now:-) On the bright side I guess my date/time understanding is better. Thanks!

BU2B · ‎03-26-2015

Thank you sir!

data_null__ · ‎03-12-2015

I think, based on your description, you want the Start of the next 15 minute interval. page; data _null_; do Starttime = datetime() by 15*60; I + 1; if i eq 20 then stop; Min_Start = intnx('dtminute15',StartTime,1,'B'); put (starttime min_start)(=datetime.); end; run; 33 data _null_; 34 do Starttime = datetime() by 15*60; 35 I + 1; 36 if i eq 20 then stop; 37 Min_Start = intnx('dtminute15',StartTime,1,'B'); 38 put (starttime min_start)(=datetime.); 39 end; 40 run; Starttime=12MAR15:12:34:38 Min_Start=12MAR15:12:45:00 Starttime=12MAR15:12:49:38 Min_Start=12MAR15:13:00:00 Starttime=12MAR15:13:04:38 Min_Start=12MAR15:13:15:00 Starttime=12MAR15:13:19:38 Min_Start=12MAR15:13:30:00 Starttime=12MAR15:13:34:38 Min_Start=12MAR15:13:45:00 Starttime=12MAR15:13:49:38 Min_Start=12MAR15:14:00:00 Starttime=12MAR15:14:04:38 Min_Start=12MAR15:14:15:00 Starttime=12MAR15:14:19:38 Min_Start=12MAR15:14:30:00 Starttime=12MAR15:14:34:38 Min_Start=12MAR15:14:45:00 Starttime=12MAR15:14:49:38 Min_Start=12MAR15:15:00:00 Starttime=12MAR15:15:04:38 Min_Start=12MAR15:15:15:00 Starttime=12MAR15:15:19:38 Min_Start=12MAR15:15:30:00 Starttime=12MAR15:15:34:38 Min_Start=12MAR15:15:45:00 Starttime=12MAR15:15:49:38 Min_Start=12MAR15:16:00:00 Starttime=12MAR15:16:04:38 Min_Start=12MAR15:16:15:00 Starttime=12MAR15:16:19:38 Min_Start=12MAR15:16:30:00 Starttime=12MAR15:16:34:38 Min_Start=12MAR15:16:45:00 Starttime=12MAR15:16:49:38 Min_Start=12MAR15:17:00:00 Starttime=12MAR15:17:04:38 Min_Start=12MAR15:17:15:00

BU2B · ‎03-12-2015

Thanks guys! I'm sure I'll be back when I hit the next step... I'm going to try and struggle through it on my own 1st!

BU2B · ‎10-15-2014

Well that did the trick! Thanks so much! Have a good weekend! Steve

BU2B · ‎09-16-2014

Thanks guys! Both very helpful answers. Steve

Vish33 · ‎06-08-2014

Try with informat and format for the base data., data base; set base; informat date_variable datetime9. ; format date_variable date9.; run; /* now append two datasets */ proc append base=base data=data force; run;

Ksharp · ‎05-10-2014

OR do time='00:00:00't to '24:00:00't by 15*60 ;

Online Status	Offline
Date Last Visited	‎02-09-2019 02:42 PM

Re: :INTO Variable ERROR?

Re: :INTO Variable ERROR?

Re: :INTO Variable ERROR?

Re: :INTO Variable ERROR?

:INTO Variable ERROR?

Re: VBA run-time error 3706

Re: VBA run-time error 3706

VBA run-time error 3706

Re: MMDDYY10 FORMAT TO DATETIME20

MMDDYY10 FORMAT TO DATETIME20

Re: Subtracting Two Arrays

Re: :INTO Variable ERROR?

Re: VBA run-time error 3706

Re: MMDDYY10 FORMAT TO DATETIME20

Re: Subtracting Two Arrays

Re: Macro Loop

Re: Using Task Scheduler to Run SAS

Re: Time Conversion

Re: Date by 15 Minute Interval

Re: 2 digit month

Re: INTNX by 15 Minute

Re: SAS Dates

Re: Duplicate Observation

Re: INPUT Statement

Re: SAS date format

Re: 15 Minute Increment