I am not kidding Andreas. I am new to SAS macros.......that's why asking and we have some existing macros for each question I asked. But in those macros, some manual intervention required and those macros are like bits and pieces...to solve those type of issues I have posted my requirements.... ... View more

Hi Shelly,   Could you please change my userName to "dsp" from rpeddireddy ? ... View more

I will post each question separately.... ... View more

In the above macro, I need to give variable name manually. But in some scenarios like I have 400 variables and out of those 400 variables, 90 variables are categorical variables. Then it's very difficult to check and picking all those variables.   Is there any code available to solve these kind of issues ?   Thanks in advance. ... View more

Thanks for the quick response Ksharp.   I have some other requirement like as follows. We need to have single or multiple SAS macro codes which will need to perform below tasks. 1. It should check all missing values in the dataset and then drop the variables with high missing values and at the same time impute those numeric and character missing values based on some conditions like in model development we used to follow something like that. 2. It should check for any outliers in the dataset and it has to treat those outliers. 3. It should create dummy variables like we have "Dummies" package in R which will create dummy variables and drop original variables after creating dummy variables.   If you have any macros to fulfill the above requirements, please share with me.   Thanks in advance. ... View more

I have a large dataset. So, if possible plz write some sql code to fulfill my requirement. Thanks in advance. ... View more

If we have less number of variables, it's easy to use code mentioned above. In my dataset, I have around 300 variables and to check each and every variable, will take more time.   My requirement is to have one macro code which will read all the missing values and drop the variables with greater than 80% missing values.   Plz share with me if you have any code like this.   Thanks in advance. ... View more