topic Re: Date in SAS Programming

Date

Dhana18 — Fri, 26 Apr 2019 13:51:47 GMT

I have visit_date that shows like this

20190321

20190216

20190516 this is in numeric best 12 format

I would like it to be like this

2019/03/21

2019/02/16

2019/05/16

i did

data want;

data have;

format visit_date mmddyy10.;

run;

it did not work. Help me please.

Re: Date

novinosrin — Fri, 26 Apr 2019 14:12:37 GMT

Use format yymmdds10.;

format visit_date yymmdds10.;

Re: Date

VDD — Fri, 26 Apr 2019 14:14:51 GMT

SAS date formats is how you take care of that. Here is a link to those formats.

http://support.sas.com/documentation/cdl/en/lrcon/65287/HTML/default/viewer.htm#p1wj0wt2ebe2a0n1lv4lem9hdc0v.htm

self-service is always welcome

Re: Date

novinosrin — Fri, 26 Apr 2019 14:23:21 GMT

If those are just numbers, you may need some conversion

data have;
input date;
cards;
20190321
20190216
;

data want;
set have;
cdate=put(date,8. -l);
want_date=input(cdate,yymmdd8.);
format want_date yymmdds10.;
run;

Re: Date

VDD — Fri, 26 Apr 2019 14:50:46 GMT


data have;
input visit_date yymmdd8.;
cards;
20190321
20190216
20190516
;
data want;
	set have;
	visit_date_newview = visit_date;
	format visit_date_newview yymmdds10.;
run;

Re: Date

Ksharp — Fri, 26 Apr 2019 14:32:31 GMT

data have;
input date ;
want=input(put(date,best. -l),yymmdd10.);
format want yymmdds10.;
cards;
20190321
20190216
20190516
;
run;

Re: Date

Dhana18 — Fri, 26 Apr 2019 14:37:18 GMT

Thank you for replying my request, it did not work for me.

Re: Date

Dhana18 — Fri, 26 Apr 2019 14:47:18 GMT

It did not work. Log says this.

179 DATA NONSTDEM.PPWI_March_2019_B;
180 SET NONSTDEM.PPWI_March_2019_A;
181 format visdate_newview yymmdds10.;
182 run;

NOTE: Variable visdate_newview is uninitialized.
NOTE: There were 38 observations read from the data set NONSTDEM.PPWI_MARCH_2019_A.
NOTE: The data set NONSTDEM.PPWI_MARCH_2019_B has 38 observations and 31 variables.
NOTE: DATA statement used (Total process time):
real time 1.41 seconds
cpu time 0.03 seconds

and the result is visit_dat_newview is . (blank)