topic Increment of Numeric Value after DDMMYYYY in SAS Programming

Increment of Numeric Value after DDMMYYYY

mlogan — Mon, 27 Mar 2017 00:47:02 GMT

Can someone tell me how do I get the output as '26MAR2017-0001' upto with an increment upto 1000?

I was able to figure out how to get the output as '26MAR17-0001'

Thank You.

DATA want;
  DO _n_=1 TO 1000;
  x = "&SYSDATE"||'-'||PUT(_n_, z4.);
OUTPUT;
END;
RUN;

Reeza — Mon, 27 Mar 2017 00:53:41 GMT

Your code looks fine, try using a variable other than _n_, which is an automatic variable and trying to loop with it may confuse things.

I would probably also use CATX.

Astounding — Mon, 27 Mar 2017 01:31:21 GMT

&SYSDATE uses a two-digit year (as you have seen). To get a four-digit year, switch to &SYSDATE9 instead.

mlogan — Mon, 27 Mar 2017 01:45:05 GMT

Hi Reeza, How would you create 1000 observations without creating a loop? Can you please show me the code. Thanks.

mlogan — Mon, 27 Mar 2017 02:03:10 GMT

I got it! Thanks Reeza.