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;
SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!
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.