Hello,   I want to do a frequency on a variable using proc sql. I am doint count(VariableName) and also group by (VariableName) but it does not count the records where there is no value.   I am looking for something equivalent to the missing option in proc freq.   Here is my code: data have; input id Gender $; datalines; 1 M 2 F 3 M 4 . 5 . 6 F ; run; proc sql; select Gender ,count(Gender) as frequency from have group by Gender ;quit; The output is: Gender  Frequency            0 F         2 M        2   I want the output to be like: Gender Frequency            2 F         2 M        2 ... View more

Hello,   I want to put a where clause in the sql query if the user passes it in the macro. If the user does not pass any macro parameter for the where clause then the query should get executed without any filtering. I dont want to use DSID etc options asI have to apply the query on to the database tables also.   I have this but cannot have it working. %macro isBlank( param ) ; %sysevalf( %superq( param ) =, boolean ) %mend ; %macro nos_obs( dsn = /*Name of SAS Dataset*/ where_stmt=abc ); %global num_obs ; %if %isblank(&where_stmt.)=1 %then %do; %let where_cls=; %end; %else %do; %let where_cls=&where_stmt.; %end; proc sql noprint; select count(*) into :num_obs from &dsn. &where_cls. ;quit; %put num_obs--&num_obs.; %mend ; %nos_obs(dsn=sashelp.class,where_stmt=where age in (12,13));   ... View more

Hello,   I have the following code: options symbolgen mprint mlogic; options mautosource sasautos=( '/my/macro/location/folder' sasautos ); libname lib "/sas/dataset/folder/path/";*this is automated; %let path_lib = %sysfunc(pathname(lib)); %put &path_lib.; %let dataset = name_of_sas_dataset_yyyymm; %let end_date=201707; DATA _NULL_; DO UNTIL(fileexist(&path_lib.&dataset._&end_date..sas7bdat)); %let end_date=%eval(&end_date-1); END; RUN; so i want to have the end_date macro variable have the value of the latest dataset. How can i have this working?   Please suggest.   Thanks ... View more