https://communities.sas.com/t5/SAS-Programming/Formats-into-Dataset/m-p/25320#M4417 If I understand your question, you're looking for the CNTLOUT= option on the Proc Format statement to create a data set with the format information. Specify the library and dataset name like any other.<BR /> <BR /> I'd look at the contents closely before exporting as there is likely to be lot's of stuff you're not interested in. Thu, 20 May 2010 21:37:37 GMT ballardw 2010-05-20T21:37:37Z https://communities.sas.com/t5/SAS-Programming/Formats-into-Dataset/m-p/25319#M4416 Hi- <BR /> I'm trying to create a data dictionary for my dataset and willing to <BR /> read all the values for each format from the library into a dataset so <BR /> that I can export the same into Excel. <BR /> Any help is greatly appreciated. <BR /> <BR /> Matt Thu, 20 May 2010 18:15:41 GMT https://communities.sas.com/t5/SAS-Programming/Formats-into-Dataset/m-p/25319#M4416 deleted_user 2010-05-20T18:15:41Z https://communities.sas.com/t5/SAS-Programming/Formats-into-Dataset/m-p/25320#M4417 If I understand your question, you're looking for the CNTLOUT= option on the Proc Format statement to create a data set with the format information. Specify the library and dataset name like any other.<BR /> <BR /> I'd look at the contents closely before exporting as there is likely to be lot's of stuff you're not interested in. Thu, 20 May 2010 21:37:37 GMT https://communities.sas.com/t5/SAS-Programming/Formats-into-Dataset/m-p/25320#M4417 ballardw 2010-05-20T21:37:37Z https://communities.sas.com/t5/SAS-Programming/Formats-into-Dataset/m-p/25321#M4418 Matt<BR /> <BR /> If posting the same question in 2 groups I believe it would be kind of courtesy to tell people.<BR /> <BR /> <A href="http://groups.google.com/group/comp.soft-sys.sas/browse_thread/thread/70088fe6915a0991/0dd2befe03ef31a5#0dd2befe03ef31a5" target="_blank">http://groups.google.com/group/comp.soft-sys.sas/browse_thread/thread/70088fe6915a0991/0dd2befe03ef31a5#0dd2befe03ef31a5</A><BR /> <BR /> Cheers<BR /> Patrick Fri, 21 May 2010 10:51:03 GMT https://communities.sas.com/t5/SAS-Programming/Formats-into-Dataset/m-p/25321#M4418 Patrick 2010-05-21T10:51:03Z https://communities.sas.com/t5/SAS-Programming/Formats-into-Dataset/m-p/25322#M4419 Patrick-<BR /> This is kind of an urgent requirement so I had to post on the other groups too. <BR /> <BR /> Ballard- thanks for the help.<BR /> <BR /> Matt Fri, 21 May 2010 15:18:22 GMT https://communities.sas.com/t5/SAS-Programming/Formats-into-Dataset/m-p/25322#M4419 deleted_user 2010-05-21T15:18:22Z