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 |
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
To paraphrase an old saying, "Those who refuse to read have no advantage of those who cannot read."
Maxim 2:
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;
It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.
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.
Ready to level-up your skills? Choose your own adventure.