DATA Description We have an Excel Sheet in that we have 1,000,000 Observations and 150 Variables. Some of the Records(Entire Row) have Missing values. TASK Import the Excel Sheet into SAS Data Set with the best available technique . Remove all Missing Records in the SAS Data Set(If possible import only Non Missing Records). Now we need to create Two SAS Date Sets "ONE" and "TWO". Data Set "ONE" should have all the Character Variables with 25,000 Random Records. Data Set "TWO" should have all the Numeric Variables with 50,000 Random Records.
... View more