Increment of Numeric Value after DDMMYYYY

[mlogan]

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]

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.

[mlogan]

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

[mlogan]

I got it! Thanks Reeza.

[Astounding · Accepted solution]

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