BookmarkSubscribeRSS Feed
thanikondharish
Calcite | Level 5

data ex1 ;
date='09sep2018'd ;
output ;
date='10sep2018'd ;
output ;
date='11sep2018'd ;
output ;
date='12sep2018'd ;
output ;
format date date9. ;
run;

 

i want to keep first two records in date9. formats and remaining records keep in yymmdd10. format see onnce my program

if any mistakes please let me know
proc format ;
value jj low-'10sep2018'd=[ddmmyyd10.] ;
'11sep2018'd-high=[date9.] ;
run;
data ex2 ;
set ex1 ;
new=date ;
format new jj. ;
run;

 

finaly data comes like see below dataset

date

new

09SEP2018

09-09-2018

10SEP2018

10-09-2018

11SEP2018

21438

12SEP2018

21439

3 REPLIES 3
Reeza
Super User

Read your log.

 


@thanikondharish wrote:

data ex1 ;
date='09sep2018'd ;
output ;
date='10sep2018'd ;
output ;
date='11sep2018'd ;
output ;
date='12sep2018'd ;
output ;
format date date9. ;
run;

 

i want to keep first two records in date9. formats and remaining records keep in yymmdd10. format see onnce my program

if any mistakes please let me know
proc format ;
value jj low-'10sep2018'd=[ddmmyyd10.] ;
'11sep2018'd-high=[date9.] ;
run;
data ex2 ;
set ex1 ;
new=date ;
format new jj. ;
run;

 

finaly data comes like see below dataset

date

new

09SEP2018

09-09-2018

10SEP2018

10-09-2018

11SEP2018

21438

12SEP2018

21439


 

Astounding
PROC Star

To paraphrase an old saying, "Those who refuse to read have no advantage of those who cannot read."

RW9
Diamond | Level 26 RW9
Diamond | Level 26

Maxim 2:

https://communities.sas.com/t5/SAS-Communities-Library/Maxims-of-Maximally-Efficient-SAS-Programmers...

 

After a tidy up (and using the Code window which is the {i} above post area):

data ex1;
  date='09sep2018'd;
  output;
  date='10sep2018'd;
  output;
  date='11sep2018'd;
  output;
  date='12sep2018'd;
  output;
  format date date9.;
run;
proc format;
  value jj 
    low-'10sep2018'd=[ddmmyyd10.]
    '11sep2018'd-high=[date9.];
run;
data ex2;
  set ex1;
  new=date;
  format new jj.;
run;

SAS Innovate 2025: Save the Date

 SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!

Save the date!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 3 replies
  • 1059 views
  • 0 likes
  • 4 in conversation