Prev: ERROR: Rename... Losing data sets from network drives
Next: How to change order of variable in SAS dataset
From: Raj on 25 Jan 2007 16:19
Hi,

How to reset the fmtsearch= option so that it searches the default
catalog where sas supplied formats are stored.
Where are they stored anyway ?

thanks,
Raj

My sas program keeps erroring out with,
ERROR 48-59: The format $DDMMYY was not found or could not be loaded.

From: Martin Gregory on 25 Jan 2007 17:01
Raj,

sas supplied formats are not found via the catalogs listed in FMTSEARCH.
Your problem is that you are asking for a character ($) format and sas
dates are numeric variables. Try DDMMYY.

cheers

Martin

On 01/25/2007 10:19 PM, Raj wrote:
> Hi,
>
> How to reset the fmtsearch= option so that it searches the default
> catalog where sas supplied formats are stored.
> Where are they stored anyway ?
>
> thanks,
> Raj
>
> My sas program keeps erroring out with,
> ERROR 48-59: The format $DDMMYY was not found or could not be loaded.
>
From: "data _null_;" on 25 Jan 2007 16:27
I think your problem is you are trying to associate MMDDYY with a
character variable. Check your CONTENTS. Then take the appropriate
action.

On 1/25/07, Raj <ramesh.chakri(a)gmail.com> wrote:
> Hi,
>
> How to reset the fmtsearch= option so that it searches the default
> catalog where sas supplied formats are stored.
> Where are they stored anyway ?
>
> thanks,
> Raj
>
> My sas program keeps erroring out with,
> ERROR 48-59: The format $DDMMYY was not found or could not be loaded.
>
From: rjf2 on 25 Jan 2007 16:27
> From: Raj
> How to reset the fmtsearch= option so that it searches the
> default catalog where sas supplied formats are stored.
> Where are they stored anyway ?
>
> thanks,
> Raj
>
> My sas program keeps erroring out with,
> ERROR 48-59: The format $DDMMYY was not found or could not be loaded.

unless you have reset fmtsearch it searching the
work and libref=library
formats.catalogs.

%Put fmtsearch<%sysfunc(getoption(fmtsearch))>;

1 %Put fmtsearch<%sysfunc(getoption(fmtsearch))>;
fmtsearch<(WORK LIBRARY)>

iirc, this error comes from having a data set with a variable
that has the named format associated with it
and there is no such format in any of the libref
named in the fmtsearch list.

try this:
options nofmterr;

see also:

proc options define value option = fmtsearch;
run;

Ron Fehd the macro maven CDC Atlanta GA USA RJF2 at cdc dot gov
From: NordlDJ on 25 Jan 2007 16:39
> -----Original Message-----
> From: SAS(r) Discussion [mailto:SAS-L(a)LISTSERV.UGA.EDU] On Behalf Of Raj
> Sent: Thursday, January 25, 2007 1:20 PM
> To: SAS-L(a)LISTSERV.UGA.EDU
> Subject: How to reset fmtsearch= option to default catalog
>
> Hi,
>
> How to reset the fmtsearch= option so that it searches the default
> catalog where sas supplied formats are stored.
> Where are they stored anyway ?
>
> thanks,
> Raj
>
> My sas program keeps erroring out with,
> ERROR 48-59: The format $DDMMYY was not found or could not be loaded.

Raj,

SAS supplied formats are always available regardless of how fmtsearch=() is set. Try the format specification without the $, ddmmyy10.

Hope this is helpful,

Dan

Daniel J. Nordlund
Research and Data Analysis
Washington State Department of Social and Health Services
Olympia, WA 98504-5204
 |  Next  |  Last
Pages: 1 2
Prev: ERROR: Rename... Losing data sets from network drives
Next: How to change order of variable in SAS dataset