DATA Step, Macro, Functions and more

Increment of Numeric Value after DDMMYYYY

Accepted Solution Solved
Reply
Regular Contributor
Posts: 218
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,504

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: 19,789

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: 218

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: 218

Re: Increment of Numeric Value after DDMMYYYY

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

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
  • 174 views
  • 2 likes
  • 3 in conversation