Date:         Mon, 7 Aug 2006 08:28:58 +0800
Reply-To:     Scott Bass <sas_l_739.at.yahoo.dot.com.dot.au@PESTO.CC.UGA.EDU>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Scott Bass <sas_l_739.at.yahoo.dot.com.dot.au@PESTO.CC.UGA.EDU>
Subject:      Re: Assigning Format
Comments: To: sas-l@uga.edu

Hari,

If you have permanent user-defined formats associated with variables in a
dataset, you need to ensure:

* the formats exist in a formats catalog
* the format catalog is in the current fmtsearch path

when you attempt to access the dataset.

Read the doc for the fmtsearch option, paying close attention to the search
rules for the LIBRARY and WORK librefs.

If the creation of data set B fails, try viewtable A, and see if your data
is formatted as expected.  You could also run the code (untested):

proc format lib=fmtproj.formats cntlout=test;  /* change the catalog name as
appropriate */
   select pidcs;
run;

which would 1) display the values of your format and 2) test your current
fmtsearch path.

HTH,
Scott

"Hari" <excel_hari@yahoo.com> wrote in message
news:1154900050.976359.178660@75g2000cwc.googlegroups.com...
> Hi,
>
> I have a Datset A (in library ProjA) having some user defined formats
> with its format catalog
> (FmtProjA) in a library called FmtProj and I have associated the format
> of the dataset with the catalog in FmtProj.
>
> Now, I create a new data set called B from A (data ProjA.B; Set
> ProjA.A;run;) and I see that the formats in B do not get assigned
> automatically from the formats in dataset A. I get messages like
>
> "NOTE: Format PIDCS was not found or could not be loaded."
>
> Because of this am forced to explicitly  associate the FmtProjA to
> dataset B using Proc datasets statement. Shouldnt SAS associate the
> formats for derived datasets by default?
>
> Regards,
> HP
> India
>