https://communities.sas.com/t5/New-SAS-User/Counting-the-missing-values-of-a-variable-using-SAS-Viya-For/m-p/802875#M33296 Thanks very much Koen, exactly what I need!<BR /><BR /><BR /> Fri, 18 Mar 2022 21:56:45 GMT Genoa 2022-03-18T21:56:45Z https://communities.sas.com/t5/New-SAS-User/Counting-the-missing-values-of-a-variable-using-SAS-Viya-For/m-p/802442#M33275 <P>Hello Experts,</P><P>&nbsp;</P><P>Is there a way for me to count the number of missing/empty values/rows of a specific variable within the Manage Data or Prepare Data? I am not a programmer.</P> Wed, 16 Mar 2022 10:06:26 GMT https://communities.sas.com/t5/New-SAS-User/Counting-the-missing-values-of-a-variable-using-SAS-Viya-For/m-p/802442#M33275 Genoa 2022-03-16T10:06:26Z https://communities.sas.com/t5/New-SAS-User/Counting-the-missing-values-of-a-variable-using-SAS-Viya-For/m-p/802502#M33276 <P>Hello,</P> <P>&nbsp;</P> <P>Profile your data (without any code!).<BR /><BR />See below video's on how that is done :</P> <P>&nbsp;</P> <P>Using the SAS Data Preparation Profiling Feature to Perform Data Discovery (Video)</P> <P>See how to use the profiling feature of SAS Data Preparation to aid data discovery.</P> <P><EM>Video</EM>!</P> <P><A href="https://go.documentation.sas.com/doc/en/dprepex/2.1/p0hl8f0gvw7g7rn0zr8i0n0u8bk1.htm" target="_blank">https://go.documentation.sas.com/doc/en/dprepex/2.1/p0hl8f0gvw7g7rn0zr8i0n0u8bk1.htm</A></P> <P>&nbsp;</P> <P>Using SAS Data Explorer to Profile Data for Better Understanding (Video)</P> <P>See how to leverage SAS Data Explorer to profile data for inconsistencies and anomalies. This video shows you how to generate and review table and column metrics, which can help you to better understand your data.</P> <P><EM>Video</EM>!</P> <P><A href="https://go.documentation.sas.com/doc/en/dprepex/2.1/p0g4vu11cxhn05n1p7t2bclrsysa.htm" target="_blank">https://go.documentation.sas.com/doc/en/dprepex/2.1/p0g4vu11cxhn05n1p7t2bclrsysa.htm</A></P> <P>&nbsp;</P> <P>Profiling is part of SAS Data Preparation and SAS Data Explorer.</P> <P>&nbsp;</P> <P>Thanks,</P> <P>Koen</P> <P>SAS BeNeLux</P> Wed, 16 Mar 2022 15:42:14 GMT https://communities.sas.com/t5/New-SAS-User/Counting-the-missing-values-of-a-variable-using-SAS-Viya-For/m-p/802502#M33276 sbxkoenk 2022-03-16T15:42:14Z https://communities.sas.com/t5/New-SAS-User/Counting-the-missing-values-of-a-variable-using-SAS-Viya-For/m-p/802875#M33296 Thanks very much Koen, exactly what I need!<BR /><BR /><BR /> Fri, 18 Mar 2022 21:56:45 GMT https://communities.sas.com/t5/New-SAS-User/Counting-the-missing-values-of-a-variable-using-SAS-Viya-For/m-p/802875#M33296 Genoa 2022-03-18T21:56:45Z