A macro that identifies any variables either character or numeric – for which all of the observations are missing values. When this occurs, a warning message is output to the SAS log.
%macro vtype(dsname=, varname=, outputflag=); %if %sysfunc(exist(&dsname)) %then %do; %let dsid = %sysfunc(open(&dsname)); %let varnum = %sysfunc(varnum(&dsid,&varname)); %let vartyp = %sysfunc(vartype(&dsid,&varnum)); %if &vartyp = C %then %do; %let &outputflag=&vartyp; %put &varname=character; %end; %else %if &vartyp = N %then %do; %let &outputflag=&vartyp; %put &varname=numeric; %end; %end; %else %put "DSNAME parameter is invalid Please pass appropriate values."; %mend vtype;
this my code how can i change it according to my requirment?
... View more