@dcruik applied ur logic but got a error 56 %macro datatt(data = , 57 attribute =, 58 type=); 59 %local dsid; 60 61 %if %length(&type)= 0 %then %let type= N; 62 %else %let type = %upcase(%substr(&type,1,1)); 63 %if &type = N %then %let notfound = .; 64 %else %let notfound = ' '; 65 66 %let dsid = %sysfunc(open(&data)); 67 %if &dsid ne 0 %then 68 %put variable=%sysfunc(attrn(&dsid,&&attrname)); 69 %else 70 %put &notfound; 71 %let dsid = close(&dsid); 72 73 %mend datatt; 74 %datatt(data=sashelp.class, attribute=age, type=n, notfound=., attrname=nobs); ERROR: The keyword parameter NOTFOUND was not defined with the macro. ERROR: The keyword parameter ATTRNAME was not defined with the macro. ... View more

i hav done a code to abort but how can i enhance it more to conditionally abort a sas prg can i add data_null_ & check condition or any other logic/code please do provide... thankU ... View more

nope am not familiar with ERRORABEND concept. ... View more

My requirement--->need a macro code to return an attribute of a specified data-set variable, My code only giving the number of attribute in d log how can i modify it to display a specific attribute of a specified data-set variable....? %macro datatt(data = , attribute =, type=); %local dsid; %if %length(&type)= 0 %then %let type= N; %else %let type = %upcase(%substr(&type,1,1)); %if &type = N %then %let notfound = .; %else %let notfound = ' '; %let dsid = %sysfunc(open(&data)); %if &dsid ne 0 %then %put %sysfunc(attrn(&dsid,nobs)); %else %put &notfound; %let dsid = close(&dsid); %mend datatt; ... View more

nope i want to display att of data set variable & not the type of variable... using a generic macro ... View more

%macro datatt(data = ,attribute =,type =,notfound = ); %local dsid; %if %length(&type)= 0 %then %let type= N; %else %let type = %upcase(%substr(&type,1,1)); %if &type = N %then %let notfound = .; %else %let notfound = ' '; %let dsid = %sysfunc(open(&data)); %if &dsid ne 0 %then %put %sysfunc(attrn(&dsid,nobs)); %else %put &notfound; %let dsid = close(&dsid); %mend datatt; %datatt(data =work.test0,attribute =var3,type =N,notfound =.); hello this is my code but it doesn't display variable attribute what changes do i do to display a attribute of a specified dataset variable. ... View more

and having issue with %if &dsid ne 0 %then %sysfunc(attrn(&dsid,&attribute)); & having issue solving this errorthis attarn ... View more

@zaki oops my bad sorry varnum i wrote by mistake, am trying to extract a attribute of a macro variable & displaying it in d log. ... View more

hello @Jerry applied your logic but the code did not work data maini; input ID var1 var2 var3 var4; cards; 1 6 4 4 5 6 5 4 . 5 3 7 9 . . 7 9 4 2 6 run; proc contents data=work.main0; run; %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."; proc sql noprint; select count(*) into :notmissing from &dsname where &varname is not missing; quit; %if &notmissing = 0 %then %put WARNING: All &varname values are missing; %mend vtype; %let vartyp = -99; %vtype(dsname=work.maini, varname=var3, outputflag =vartyp); %put var_type =&vartyp; code log below there wasn't any error msg as the dataset variable var3 has missing values.. 56 data maini; 57 input ID var1 var2 var3 var4; 58 cards; NOTE: The data set WORK.MAINI has 4 observations and 5 variables. NOTE: DATA statement used (Total process time): real time 0.02 seconds cpu time 0.02 seconds 63 run; 64 proc contents data=work.main0; 65 run; NOTE: PROCEDURE CONTENTS used (Total process time): real time 0.26 seconds cpu time 0.27 seconds 66 67 %macro vtype(dsname=, varname=, outputflag=); 68 %if %sysfunc(exist(&dsname)) %then %do; 69 %let dsid = %sysfunc(open(&dsname)); 70 %let varnum = %sysfunc(varnum(&dsid,&varname)); 71 %let vartyp = %sysfunc(vartype(&dsid,&varnum)); 72 %if &vartyp = C %then %do; 73 %let &outputflag=&vartyp; 74 %put &varname=character; 75 %end; 76 %else %if &vartyp = N %then %do; 77 %let &outputflag=&vartyp; 78 %put &varname=numeric; 79 %end; 80 %end; 81 %else %put "DSNAME parameter is invalid Please pass appropriate values."; 82 proc sql noprint; 83 select count(*) 84 into :notmissing 85 from &dsname 86 where &varname is not missing; 87 quit; 88 %if &notmissing = 0 %then 89 %put WARNING: All &varname values are missing; 90 %mend vtype; 91 %let vartyp = -99; 92 %vtype(dsname=work.maini, varname=var3, outputflag =vartyp); var3=numeric NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds 93 %put var_type =&vartyp; var_type =N ... View more

my code to check variable type--> %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; -->How can i edit this code to identify 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. ... View more