Please help we with this problem to count the missing values across raw with two diamensional array.
Dataset name : Subset.csv. The following is the data set.
i_Day5 Day6 Day7 City1 City2 City3
1 Friday NA NA NA Delhi NA
2 NA NA NA NA NA Mumbai
3 Friday NA NA NA NA NA
4 Friday Saturday Na Bangalore Delhi NA
5 NA NA NA NA NA NA
6 Friday Saturday Sunday Bangalore Delhi NA
7 NA NA NA NA Delhi NA
8 NA NA NA NA NA NA
9 NA NA NA NA NA NA
10 Friday Saturday NA NA NA NA
And what do you expect the output to look like?
Note that to use values of variables "across" rows outside of IML is going to involve some work.
And 'NA' is not 'missing' as used by SAS. So it looks like your question may be the "the number of NA values".
the output the am looking is, a 7th varable " No_of_Miss" that contain the number of missing values(number of "NA") of each raws. Like... Number of "NA" in the 1st raw as the 1st observation of "No_of_Miss", number of "NA" in the 2nd raw as the second obsercation on"No_Of_Miss"....etc
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.