topic Date conversion and trim function in SAS Procedures

Date conversion and trim function

raveena — Fri, 17 Jun 2011 14:14:54 GMT

Hi,

I have the dataset with the fields, the eff and exp fields are the date type.

ID comp grp eff exp
1 04 y 09/10/2010 08/12/2013
2 07 h 09/03/2009 07/02/2017

I need the report to looks like,

ID comp grp eff exp
1 04 y 20101009 20131208}
2 07 h 20090309 20170207}

Thanks in advance.

Re: Date conversion and trim function

DBailey — Fri, 17 Jun 2011 14:52:48 GMT

I think all you need to do is change the format of the date columns to yymmddn8. Do you need to add the "}" at the end of the second date?

Re: Date conversion and trim function

raveena — Fri, 17 Jun 2011 15:22:04 GMT

Hi DBailey,

Yes I need to } at the end of the field.

Re: Date conversion and trim function

sbb — Fri, 17 Jun 2011 15:29:33 GMT

Use a DATA step approach and the PUT statement to generate the data-lines.

Scott Barry
SBBWorks, Inc.

Suggested Google advanced search argument, this topic / post:

data step put statement external file site:sas.com

Re: Date conversion and trim function

yonib — Sun, 19 Jun 2011 07:12:07 GMT

Hey,
You can use the proc format picture statment.
For Example:

data temp;
eff='09oct2010'd;
output;
eff='09mar2009'd;
output;
format eff ddmmyy10.;
run;

proc format;
picture date_t (default=11)
'01jan1950'd-'31dec2011'd='%0d%0m%Y}'
(datatype=date);
run;
data temp2;
set temp;
format eff date_t.;
run;