https://communities.sas.com/t5/SAS-Programming/Formats/m-p/285350#M58315 <P>You only need to create the formats once. You can&nbsp;save formats to a catalog and reference them later.&nbsp;</P> <P>&nbsp;</P> <P><A href="http://support.sas.com/resources/papers/proceedings12/048-2012.pdf" target="_blank">http://support.sas.com/resources/papers/proceedings12/048-2012.pdf</A></P> <P>&nbsp;</P> <P>You can write SAS code to generate formats using the values / labels in a dataset. But normally&nbsp;it's&nbsp;faster to copy the labels from Word and paste them into your proc format code.&nbsp;</P> <P>&nbsp;</P> <P>Hope this helps.</P> <P>&nbsp;</P> <P>Ray</P> <P>&nbsp;</P> <P>&nbsp;</P> Mon, 18 Jul 2016 19:48:06 GMT rayIII 2016-07-18T19:48:06Z https://communities.sas.com/t5/SAS-Programming/Formats/m-p/283066#M57632 <P>Hi,</P><P>Do we have to use proc format statement everytime? If I do not use the statement but I have value labels with me (out of the dataset) and I can work while I put vlaues in MSword tables, is that ok?</P><P>Thanks</P> Fri, 08 Jul 2016 21:13:48 GMT https://communities.sas.com/t5/SAS-Programming/Formats/m-p/283066#M57632 wajmsu 2016-07-08T21:13:48Z https://communities.sas.com/t5/SAS-Programming/Formats/m-p/285350#M58315 <P>You only need to create the formats once. You can&nbsp;save formats to a catalog and reference them later.&nbsp;</P> <P>&nbsp;</P> <P><A href="http://support.sas.com/resources/papers/proceedings12/048-2012.pdf" target="_blank">http://support.sas.com/resources/papers/proceedings12/048-2012.pdf</A></P> <P>&nbsp;</P> <P>You can write SAS code to generate formats using the values / labels in a dataset. But normally&nbsp;it's&nbsp;faster to copy the labels from Word and paste them into your proc format code.&nbsp;</P> <P>&nbsp;</P> <P>Hope this helps.</P> <P>&nbsp;</P> <P>Ray</P> <P>&nbsp;</P> <P>&nbsp;</P> Mon, 18 Jul 2016 19:48:06 GMT https://communities.sas.com/t5/SAS-Programming/Formats/m-p/285350#M58315 rayIII 2016-07-18T19:48:06Z