About Ian_Tfirn

Ian_Tfirn · ‎07-15-2019

Works perfect now. Thanks for all your help!

Ian_Tfirn · ‎07-15-2019

Even when I change N to num, it still runs proc freq for my numeric var

Ian_Tfirn · ‎07-15-2019

Hey Reeza, For some reason, the macro in your most recent comment wasn't working for me while Heffo's did. Since they are nearly identical, I'm sure I was doing something wrong. Anyway, thanks for your patience. I appreciate you sticking with me.

Ian_Tfirn · ‎07-15-2019

Works perfectly, thanks for your help!

Ian_Tfirn · ‎07-15-2019

Ian_Tfirn · ‎07-15-2019

Hey Reeza, Unfortunately, your most recent suggestion will run proc means on all numeric variables and proc freq on all character variables. In datasets with hundreds of variables, that's a lot of results! I only want the macro to identify a single variable, determine if it is character or numeric, and then run the appropriate procedure.

Ian_Tfirn · ‎07-15-2019

The general idea I've tried is the following: proc contents data = original output out = new; run; %macro Freq_means (var = BMI); data new; set new; if Name = "&Var" and Type = 1 then do; proc means data = original; var &var; run; If Name = "&Var" and Type = 2 then do; proc freq data = original; tables &var; run; %mend; %Freq_means ();

Ian_Tfirn · ‎07-15-2019

Hello all, As the subject says, I'd like to create a macro that does the following: 1. Identifies a specific variable 2. determines if that variable is character or numeric 3. If it's character, runs proc freq. If it's numeric, runs proc means I've been attempting various macros that do this but none of have been remotely successful. Any ideas are greatly appreciated. Thanks

Online Status	Offline
Date Last Visited	‎08-07-2019 07:14 PM

Re: Create Macro that runs freq if character, means if numeric

Re: Create Macro that runs freq if character, means if numeric

Re: Create Macro that runs freq if character, means if numeric

Re: Create Macro that runs freq if character, means if numeric

Re: Create Macro that runs freq if character, means if numeric

Re: Create Macro that runs freq if character, means if numeric

Re: Create Macro that runs freq if character, means if numeric

Create Macro that runs freq if character, means if numeric

Re: Create Macro that runs freq if character, means if numeric

Re: Create Macro that runs freq if character, means if numeric

Re: Create Macro that runs freq if character, means if numeric

Re: Create Macro that runs freq if character, means if numeric

Re: Create Macro that runs freq if character, means if numeric

Re: Create Macro that runs freq if character, means if numeric

Re: Create Macro that runs freq if character, means if numeric

Re: Create Macro that runs freq if character, means if numeric

Create Macro that runs freq if character, means if numeric