SAS将分钟添加到存储在宏变量中的时间戳(SAS Adding Minutes to a Timestamp Stored in a Macro Variable)

 我通过SAS从SQL Server中提取大量数据。 我想使用循环一次拉一分钟（或小时）的数据。 
 
 时间戳的格式为'yyyymmdd hh：mm：ss.000'。 
 
 通常，我会这样做： 
 
%macro Loop(num_days, tmstmp_begin):
%do i = 0 to &num_days.;
    proc sql;
    ...
    where tmstmp between &tmstmp_begin + &i minutes and &tmstmp_begin (&i+1) minutes;
    quit;
%end
%mend;
 
 但是服务器上不支持分钟添加。 在Teradata，我可以使用： 
 
DATEADD(minute, 1, tmsmtmp)
 
 添加一分钟到时间戳，但这不会在SAS中执行（它不会传递到服务器？）： 
 
ERROR: Function DATEADD could not be located.
 
 无论如何，我想知道是否有一个整洁的%sysfunc解决方案，可以帮助我避免生成一个时间戳的SAS表，我将从中读取宏变量，或其他一些愚蠢的东西。 
 
 基本上我需要从： 
 
%let i = 1;
%let tmstmp = '20150801 00:00:00.000'
 
 至： 
 
%put ...something involving tmstmp and i...;
'20150801 00:01:00.000'
 
 谢谢！ 

I am pulling a large amount of data from an SQL Server through SAS. I would like to pull one minute (or hour) of data at a time, using a loop. 
 
The format of the timestamp is 'yyyymmdd hh:mm:ss.000'.
 
Usually, I would do something like:
 
%macro Loop(num_days, tmstmp_begin):
%do i = 0 to &num_days.;
    proc sql;
    ...
    where tmstmp between &tmstmp_begin + &i minutes and &tmstmp_begin (&i+1) minutes;
    quit;
%end
%mend;
 
But the minute addition is not supported on the server. In Teradata, I can use:
 
DATEADD(minute, 1, tmsmtmp)
 
to add a minute to the timestamp, but this will not execute in SAS (it doesn't pass through to the server?):
 
ERROR: Function DATEADD could not be located.
 
Anyway I was wondering if there is a neat %sysfunc solution that would help me avoid generating a SAS table of timestamps from which I would read into macro variables, or something else just as silly.
 
Basically I need to go from:
 
%let i = 1;
%let tmstmp = '20150801 00:00:00.000'
 
to:
 
%put ...something involving tmstmp and i...;
'20150801 00:01:00.000'
 
Thanks!

原文：https://stackoverflow.com/questions/32705161