DATA Step, Macro, Functions and more

Increment of Numeric Value after DDMMYYYY

Accepted Solution Solved
Reply
Regular Contributor
Posts: 215
Accepted Solution

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: 5,085

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.

View solution in original post


All Replies
Super User
Posts: 17,868

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.

 

 

Regular Contributor
Posts: 215

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.
Regular Contributor
Posts: 215

Re: Increment of Numeric Value after DDMMYYYY

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

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.

Need further help from the community? Please ask a new question.

Discussion stats
  • 4 replies
  • 171 views
  • 2 likes
  • 3 in conversation