topic SAS Date format with out slashes in SAS Programming

SAS Date format with out slashes

cbrotz — Wed, 12 Jun 2019 19:43:53 GMT

I am looking to remove the slashes from a date field. The following format with the "n" returns an error. Any ideas appreciated.

Original data is a date field called month in this format:

20161201
20160801
20161201
20161201
20161001
20161101
20161101

data fix_date;
set work.query_for_objectives_for_reports;
month = intnx('month',month1,0,"BEGINNING");
format month mmddyyn10.;

run;

%LET _CLIENTPROJECTPATHHOST='';
7 %LET _CLIENTPROJECTNAME='';
8 %LET _SASPROGRAMFILE='';
9 %LET _SASPROGRAMFILEHOST='';
10
11 ODS _ALL_ CLOSE;
12 OPTIONS DEV=PNG;
13 GOPTIONS XPIXELS=0 YPIXELS=0;
14
15 GOPTIONS ACCESSIBLE;
16 data fix_date;
17 set work.query_for_objectives_for_reports;
18 month = intnx('month',month1,0,"BEGINNING");
19 format month mmddyyn10.;
__________
29
ERROR 29-185: Width specified for format MMDDYYN is invalid.

20
21 run;

Re: SAS Date format with out slashes

PaigeMiller — Wed, 12 Jun 2019 19:41:56 GMT

What error? Show us the SAS log, not just the ERROR message, but the entire DATA step with subsequent ERROR message and notes. Please paste the log into the window that appears when you click on the {i} icon.

Re: SAS Date format with out slashes

data_null__ — Wed, 12 Jun 2019 19:43:31 GMT

use width 8. mmddyyn8,;

Re: SAS Date format with out slashes

cbrotz — Wed, 12 Jun 2019 19:44:22 GMT

Added log....

Re: SAS Date format with out slashes

cbrotz — Wed, 12 Jun 2019 19:47:24 GMT

Thank you!

Re: SAS Date format with out slashes

ballardw — Wed, 12 Jun 2019 20:43:39 GMT

From the documentation of the mmddyxw. format:

Interactions When w has a value of from 2 to 5, the date appears with as much of the month and the day as possible. When w is 7, the date appears as a two-digit year without separators.

When x has a value of N, the width range changes to 2–8.

Interactions	When w has a value of from 2 to 5, the date appears with as much of the month and the day as possible. When w is 7, the date appears as a two-digit year without separators.
	When x has a value of N, the width range changes to 2–8.