cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Ron_MacroMaven
‎11-11-2023
  • 238 Posts
  • 162 Likes Given
  • 5 Solutions
  • 89 Likes Received

Re: Combining two macros using a %do loop with a %if-%then-%do-%else-%...

by Lapis Lazuli | Level 10 in SAS Programming
‎06-04-2015 08:56 PM
‎06-04-2015 08:56 PM
I suggest that you stick with your two macros. Each is independent and therefore easy to test. Then what you need is a data set that has the list of criteria for calling each macro. for your frequency macro, that looks like variable name and label. Here is the tool to call the macro using a data set as list of parameters. http://www.sascommunity.org/wiki/Macro_CallMacr For this tool to work your list, control data set, has to have the variables the same as the macro. I recommend that you use proc contents output data since that has (variable) name and label PROC contents data = &libname..&memname                      noprint               out  = out_contents              (keep = memname name length                      type    length  format                      nobs    varnum  label               rename = (nobs = _n_obs                         type = _type_n)); My style guide says: "always use named parameters in macros" so this is my recommendation for your parameter names %Macro Do_Freq(name=, label=); *testing; %callmacro(data = out_contents(keep = name label)) *auto-magic; %callmacro(data = out_contents(keep = name label)          ,macro_name=do_freq) ... View more

Re: Number of levels in character variables

by Lapis Lazuli | Level 10 in SAS Programming
‎06-04-2015 08:44 PM
‎06-04-2015 08:44 PM
%let data = sashelp.class; %let data = sashelp.heart; proc freq data = &data          (keep = _character_)           nlevels;           ods       exclude onewayfreqs;           ods       output           nlevels = out_n_levels          (keep    =  tablevar nlevels           rename  = (tablevar = name                      nlevels  = n_levels));          *to match  out_contents; proc print; ... View more

Re: Number of levels in character variables

by Lapis Lazuli | Level 10 in SAS Programming
‎06-04-2015 06:15 PM
‎06-04-2015 06:15 PM
I am with Tom: proc.freq.nlevels provides the answer, ... for the variables in the data-set. I have written several papers on extrapolating from n-levels. the information you are seeking is in contents output data set which has a variable type -- in (1:n, 2:c) you have to sort both out-nlevels and out-contents by name in order to merge them. check this SASware ballot item. ... View more

Re: Number range in if statement not working

by Lapis Lazuli | Level 10 in SAS Procedures
‎06-04-2015 11:19 AM
‎06-04-2015 11:19 AM
allow SAS to do the evaluation; the results are boolean, i.e. (0,1); var2 = (41000 <= var1 <= 41099); ... View more

Re: Choosing variables based on condition

by Lapis Lazuli | Level 10 in SAS Programming
‎06-04-2015 11:04 AM
‎06-04-2015 11:04 AM
Here is a follow-up on Jack's suggestion about keep=() I discovered this trick recently in polishing summary parameters %let keep_ids = name age sex; %let list_brands = bmw  mercedes; *note double space, therefore need for cmpres; %let keep_brands = %sysfunc(tranwrd(%cmpres(&list_brands)%str( ) ,%str( ),%str(: ))); %put &=keep_brands; set have( keep = &keep_ids &keep_brands); ... View more

Re: Dates in an array

by Lapis Lazuli | Level 10 in SAS Programming
‎06-04-2015 07:55 AM
‎06-04-2015 07:55 AM
assuming your dates are SAS dates and therefore integers mid-way-date = ((end - start)/2) + start; figure out whether you want to floor or ceiling that calculation to deal with the fraction 1/2 mid-way-date = floor(((end - start)/2) + start); ... View more

Re: Macro Numeric Var Creation

by Lapis Lazuli | Level 10 in SAS Programming
‎06-03-2015 05:48 PM
‎06-03-2015 05:48 PM
I'll back up Tom's answer: use arrays and suggest assignment with a select series block do i = dim(s); select;    when() g(i) =1;    when() g(i) =2;    otherwise g(i) =0    end; ... View more

Re: Opening and closing datasets with %sysfunc in a macro

by Lapis Lazuli | Level 10 in SAS Programming
‎06-02-2015 12:45 PM
‎06-02-2015 12:45 PM
LOL well, you asked how to reduce three lines of code to one in the macro variable assignment statement. save the macro in a file named value_of.sas place it in either your project folder or site folder and add the following options statement to your autoexec.sas *saved in project folder; options sasautos = ('.' sasautos); *saved in site folder; options sasautos = ('<...>\macros' sasautos); see also: Batch processing under Windows - sasCommunity ... View more

add Cardinality Ratio to output from proc.freq.nlevels;

by Lapis Lazuli | Level 10 in SAS Procedures
‎06-02-2015 12:32 PM
‎06-02-2015 12:32 PM
... and JMP, while we are at it. I have written several papers on Cardinality Ratio and have an sco wiki page on it. http://www.sascommunity.org/wiki/Cardinality_Ratio definitions: * the cardinality of a set is the number of elements in the set * cardinality of a data set is n-obs * cardinality of a variable is n-levels * cardinality ratio is n-levels / n-obs; * CR is a reducing function, its range is in (0:1] and it is easier to compare variable's CR than the range of n-levels in (1:n-obs) if one takes the time to calculate the n-levels of each variable proc freq data = sashelp.class nlevels; I know you have the n-obs of the data set, so, in my book it is a simple step to calculate cardinality_ratio = n-levels / n-obs; Why is this a Good Idea? Because it takes several steps to calculate it. proc contents ... out = out_contents; proc freq ... out= out_freq; proc sort out_contents proc sort out_freq data cardinality_ratio; merge out_contents out_freq; by name; cardinality_ratio = nlevels / nobs; proc summary var cardinality_ratio out = out_means data cr_type; select; when ... cr_type = 'unique'; when ... cr_type = 'many'; otherwise cr_type = 'few'; Having proc freq do the number-crunching makes calculating the cr-type in (continuous, discrete, unique) easier. ... View more

Re: Macro interpreting array incorrectly

by Lapis Lazuli | Level 10 in SAS Programming
‎06-02-2015 11:27 AM
‎06-02-2015 11:27 AM
... and, for a macro which calls a macro, this replaces your call execute step; see Macro CallMacr - sasCommunity ... View more

Re: Macro interpreting array incorrectly

by Lapis Lazuli | Level 10 in SAS Programming
‎06-02-2015 11:23 AM
‎06-02-2015 11:23 AM
array charfield (*) &charfields:; should be array charfield (*) $ &charfields; ... View more

Re: Opening and closing datasets with %sysfunc in a macro

by Lapis Lazuli | Level 10 in SAS Programming
‎06-02-2015 11:20 AM
‎06-02-2015 11:20 AM
simple hide the complexity in a macro which returns the value you want. review the code in the macro value-of and note that the parameter ''attribute'' can contain whichever attribute you want http://www.sascommunity.org/wiki/Macro_nobs so it can be used, per the test data <source lang="sas"> %let nobs = %value_of(data=sashelp.class); %let nvars = %value_of(data=sashelp.class                       ,attribute=nvars); %put &=nobs &=nvars; </source> ... View more

Re: Email Macro-Issue

by Lapis Lazuli | Level 10 in SAS Programming
‎06-02-2015 09:06 AM
‎06-02-2015 09:06 AM
As others have suggested the clue is that the macro variable 'cnt' appears to be equal to the number of obs of the data set you are reading, named 'ds1'. This is a style issue in macros: accessing global macro variables, for which the reader has no knowledge. better: fetch nobs at the top of the macro I recommend cut&paste the code from macro nobs Macro nobs - sasCommunity I support RW9's suggestion of using call execute. which, btw, can be run in open code, no macro needed. so the code generated is obvious, i.e. has line numbers and NOBS read from DS1 place the code for the email in a separate program send-email.sas so you can test it independently of the loop. here is the routine: data _null_ set ds1 call execute(%nrstr('%let parm1=...;) ); call execute(%nrstr('%let parm2=...;) ); call execute(%nrstr("%include 'send-email.sas';") run; macro function %nrstr is necessary in order to align the macro assignments with the %include ... View more

Re: If Then Run PROC

by Lapis Lazuli | Level 10 in SAS Programming
‎05-29-2015 06:17 PM
‎05-29-2015 06:17 PM
see also: Using Functions SYSFUNC and IFC to conditionally execute statements in open code - sasCommunity example: %let fmt_catalog = library.formats; %sysfunc(ifc(%sysfunc(cexist(&fmt_catalog))          ,%nrstr(%put exist catalog(&fmt_catalog);)          ,%nrstr(%put not exist catalog(&fmt_catalog);),)) yes, you have to be good at counting parentheses! Ron Fehd  there is an easier way ... View more

Re: Cycle Through Maco List?

by Lapis Lazuli | Level 10 in SAS Programming
‎05-29-2015 06:08 PM
‎05-29-2015 06:08 PM
I have written a macro, CallMacro, that has two parameters 1. data set 2. macro name I call the data set a list, SAS calls it a control data set; see e.g. proc format cntlin = Each row in the list is a set of parameters. That means that the variables names must match the parameters of the macro being called. DATA list_class_types; attrib data length = $32; data = 'all_course_types'; output; data = 'face_to_face_only_course_types' output; data ='online_only_course_types'; output; stop; run; %CallMacr(data = list_class_types, macro_name = mymacro) Ron Fehd  automagic maven http://www.sascommunity.org/wiki/Macro_CallMacr if you want to use it, ping me as I have a few modifications that are not on the sco.wiki page. ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎11-11-2023 10:13 AM
Likes given to
Quick links