## Increment of Numeric Value after DDMMYYYY

Solved
Super Contributor
Posts: 254

# Increment of Numeric Value after DDMMYYYY

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;``````

Accepted Solutions
Solution
‎03-26-2017 09:41 PM
Super User
Posts: 6,908

## Re: Increment of Numeric Value after DDMMYYYY

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

All Replies
Super User
Posts: 23,963

## Re: Increment of Numeric Value after DDMMYYYY

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.

Super Contributor
Posts: 254

## Re: Increment of Numeric Value after DDMMYYYY

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

## Re: Increment of Numeric Value after DDMMYYYY

I got it! Thanks Reeza.
Solution
‎03-26-2017 09:41 PM
Super User
Posts: 6,908

## Re: Increment of Numeric Value after DDMMYYYY

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

☑ This topic is solved.