https://communities.sas.com/t5/SAS-Programming/A-super-macro-to-create-Data-Dictionary-for-assessing-new-data/m-p/857011#M338597 <P>Hi folks, we would like to share with you a super useful and powerful macro developed by the team of <A href="https://www.reptik.swiss/" target="_self">RepTik Analytics Solution</A>&nbsp;- to create a SAS Data Dictionary on one or more or all datasets from a SAS data library. This tool&nbsp;<SPAN>helps assessing unfamiliar datasets, boosting analyses speed, and sharing data info across stakeholders.</SPAN>&nbsp;Macro file is attached.&nbsp;</P> <P>&nbsp;</P> <P>The generated Excel data dictionary contains&nbsp;rich summary information on:&nbsp;</P> <UL> <LI>All Datasets: e.g. number of variables, records, and unique keys.</LI> <LI>All Variables: e.g. length, format, N(%) of missing /non-null /unique values.</LI> <LI>Optional: first 15 obs, and basic statistics (Min, P1, P25, Median, P75, P99, Max, Mean, Mode) of numeric variables.</LI> <LI>Optional: frequencies - N(%) - for each unique values of all variables.&nbsp;</LI> <LI>Optional: remove the display of unique values for specific variables.</LI> <LI>Optional: create a separate Excel data dictionary for each dataset.</LI> </UL> <P>&nbsp;</P> <P>Example Use Cases:</P> <UL> <LI>Explore a new set of data tables that you work for first time, get overview of tables, variables, unique values, statistics, etc.</LI> <LI>Generate table/variable/value overviews on a project specific datacut, substantially boost your analyses speed!</LI> <LI>Produce a catalog of information (so called "data dictionary") on a specific set of data tables, for other people to use, e.g. periodic deliveries.</LI> </UL> <P><BR />* Note 1: The program can be used in both Windows and Unix environment. Built with SAS 9.4.<BR />* Note 2: There're 5 macros in this file, where %SAS_Data_Dict() is the main macro and the others are supportive.&nbsp;</P> <P>&nbsp;</P> <P>Have fun!&nbsp;</P> Fri, 03 Feb 2023 13:12:10 GMT Bravez 2023-02-03T13:12:10Z https://communities.sas.com/t5/SAS-Programming/A-super-macro-to-create-Data-Dictionary-for-assessing-new-data/m-p/857011#M338597 <P>Hi folks, we would like to share with you a super useful and powerful macro developed by the team of <A href="https://www.reptik.swiss/" target="_self">RepTik Analytics Solution</A>&nbsp;- to create a SAS Data Dictionary on one or more or all datasets from a SAS data library. This tool&nbsp;<SPAN>helps assessing unfamiliar datasets, boosting analyses speed, and sharing data info across stakeholders.</SPAN>&nbsp;Macro file is attached.&nbsp;</P> <P>&nbsp;</P> <P>The generated Excel data dictionary contains&nbsp;rich summary information on:&nbsp;</P> <UL> <LI>All Datasets: e.g. number of variables, records, and unique keys.</LI> <LI>All Variables: e.g. length, format, N(%) of missing /non-null /unique values.</LI> <LI>Optional: first 15 obs, and basic statistics (Min, P1, P25, Median, P75, P99, Max, Mean, Mode) of numeric variables.</LI> <LI>Optional: frequencies - N(%) - for each unique values of all variables.&nbsp;</LI> <LI>Optional: remove the display of unique values for specific variables.</LI> <LI>Optional: create a separate Excel data dictionary for each dataset.</LI> </UL> <P>&nbsp;</P> <P>Example Use Cases:</P> <UL> <LI>Explore a new set of data tables that you work for first time, get overview of tables, variables, unique values, statistics, etc.</LI> <LI>Generate table/variable/value overviews on a project specific datacut, substantially boost your analyses speed!</LI> <LI>Produce a catalog of information (so called "data dictionary") on a specific set of data tables, for other people to use, e.g. periodic deliveries.</LI> </UL> <P><BR />* Note 1: The program can be used in both Windows and Unix environment. Built with SAS 9.4.<BR />* Note 2: There're 5 macros in this file, where %SAS_Data_Dict() is the main macro and the others are supportive.&nbsp;</P> <P>&nbsp;</P> <P>Have fun!&nbsp;</P> Fri, 03 Feb 2023 13:12:10 GMT https://communities.sas.com/t5/SAS-Programming/A-super-macro-to-create-Data-Dictionary-for-assessing-new-data/m-p/857011#M338597 Bravez 2023-02-03T13:12:10Z https://communities.sas.com/t5/SAS-Programming/A-super-macro-to-create-Data-Dictionary-for-assessing-new-data/m-p/857986#M338995 <P><SPAN>We would welcome your feedback/contribution to this tool - SASdict project in Github:</SPAN>&nbsp;<A href="https://github.com/RepTik/SASdict" target="_blank">https://github.com/RepTik/SASdict</A></P> Thu, 09 Feb 2023 12:37:28 GMT https://communities.sas.com/t5/SAS-Programming/A-super-macro-to-create-Data-Dictionary-for-assessing-new-data/m-p/857986#M338995 Bravez 2023-02-09T12:37:28Z