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;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.