Hi Team, I have dates stored in character format. They look like - "15Jul2014". I need to convert it into 2014-Jul-15 i.e. YYYY-MMM-DD . Is there any easy way to convert it? Thanks in anticipation! ... View more

Is there any way we can use variables in different combinations in a macro? For example, there are 3 variables - Var 1 Var2 Var3. Possible combinations i would like to make --- Var1 Var2 Var3 Var1 Var2 Var1 Var3 Var2 Var3 Var1 Var2 Var3 Order does not matter (Var1 Var2 Var3 and Var2 Var1 Var3 - Same). ... View more

Hi Team, Is there a way we can collapse the levels of categorical variables in an automated manner? One way i know is to calculate the % of events falling in each category and run cluster analysis on it. Can this be automated for multiple variables considering only event rate, not cluster analysis? For example, there is a variable called "Char A". I have calculated Event Rate for this variable, i.e. percentage of 1s appearing in dependent variable (let's say VarY). It is simply the mean of Y. Char A Event Rate A 49% B 67% C 2% D 87% E 4% F 3% Next step is to combine categories of C,E and F as they have almost similar event rate (let's say, variation within 5%). Method 2 : If the above methodology is complicated to automate, can we make it simple taking only the number of cases falling in Char A (not considering dependent variable). For example, if a categorical level contains atmost  5% observations, combine it with others which all have percentage less than 5%, Char A ColPct C 2% F 3% E 4% A 49% B 67% D 87% Combine categories of C,E and F as they have column percentage less than 5%. After using either of the 2 methodologies, we need to replace the levels with the combined category in a raw data file. The raw data file looks like below - Char A Y C 1 C 1 F 1 E 0 E 0 A 1 B 1 D 1 E 0 A 0 B 1 D 1 C 1 Any help would be highly appreciated! Thanks in anticipation! ... View more

I am using %IF %THEN and it works sometimes as expected. Sometimes it does not work as expected. The following code does not work when i put "mean" in quotes - options minoperator mlogic; %macro missing (method=); %if %lowcase(&method.) = "mean" or %lowcase(&method.) = "median" %then %do; %put type = "mean or median"; %end; %else %do; %put type = "zero"; %end; %mend; %missing (method=mean); When i replace the third line of code to : %if %lowcase(&method.) = mean or %lowcase(&method.) = median %then %do; , the code works. ... View more

I am trying to create a macro that calculates number of levels (distinct categories) for all the character variables in a dataset. Currently, i am using PROC SQL to calculate distinct categories. If i have 100 variables, i have to run PROC SQL 100 times in a loop. Is there a better way to do it? Is "stackods" kind of option available in PROC SQL so that i can reshape my dataset easily? Sample Code - proc sql; create table abc as select count(distinct(sex)) as sex_levels from sashelp.class; quit; Sample Output - Variable N_Levels Sex 2 Age 6 It's just the sample code and output for 2 variables. I need to do it for all the character variables in a dataset. Note : All my categorical variables are stored as character variables (string) in my dataset. Thanks in anticipation! ... View more