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-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

Register now!

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

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