Counting the missing values of a variable using SAS Viya For Learners

[Genoa]

Hello Experts,

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.

[sbxkoenk · Accepted solution]

Hello,

Profile your data (without any code!).

See below video's on how that is done :

Using the SAS Data Preparation Profiling Feature to Perform Data Discovery (Video)

See how to use the profiling feature of SAS Data Preparation to aid data discovery.

Video!

https://go.documentation.sas.com/doc/en/dprepex/2.1/p0hl8f0gvw7g7rn0zr8i0n0u8bk1.htm

Using SAS Data Explorer to Profile Data for Better Understanding (Video)

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.

Video!

https://go.documentation.sas.com/doc/en/dprepex/2.1/p0g4vu11cxhn05n1p7t2bclrsysa.htm

Profiling is part of SAS Data Preparation and SAS Data Explorer.

Thanks,

Koen

SAS BeNeLux

[Genoa]

Thanks very much Koen, exactly what I need!