Dears,    I have a big data set containing more than 100 variables, am trying to have a statistical table representing Each Variable (Blank cells count and Blank cells percentage and an amount(another variable in the data set) that reflect the amount of blank cells of each variable. Data Sample Socks T-shirts Shirts Cost  Large     20   X large Small 40 Small   Large  60   Data output desired :    Variables Blanks Count Blanks % Amount representing blank data Amount % Socks 1 33% 40 33% T-shirts 2 67% 80 67% Shirts 1 33% 20 17%   Either having it as a table representing all variables. Please not that i am a beginner on SAS enterprise guide and am not good with coding. my plan was to do it by the query builder or by statistics tables. ... View more

Hello, Am trying to do a new computed column by advanced expression after doing an outer join:     " case when t1.'Claim No'n = "" then t2.'Claim No'n else t1.'Claim No'n end " where am asking it to find the value from the first table and if it is blank then take it from the second table.   The thing is it works for variable types that are string, once i tried to use it for Dates or numbers it gave the error message:   ERROR: Expression using equals (=) has components that are of different data types   Please Advice, thanks  ... View more