what variables are RC & IS ?? ... View more

its a generic macro i don't hav data i need a code which is error free ... View more

55 56 %let dsName=data1; 57 options nomprint nomlogic; 58 %macro check(dsName= ); 59 %let dsid = %sysfunc(open(&dsName, IS)); 60 61 %if &DSID = 0 %then 62 %put %sysfunc(sysmsg()); 63 %let nlobs = %sysfunc(attrn(&dsid,NLOBS)); 64 %put No of Observation in dataset %trim(&dsName) : %trim(&nlobs); 65 %let rc = %sysfunc(close(&dsid)); 66 67 %mend; 68 69 %check(dsName=); ERROR: There is not a default input data set (_LAST_ is _NULL_). WARNING: Argument 1 to function ATTRN referenced by the %SYSFUNC or %QSYSFUNC macro function is out of range. NOTE: Mathematical operations could not be performed during %SYSFUNC function execution. The result of the operations have been set to a missing value. No of Observation in dataset : . ... View more

what is RC & IS i couldn't ur logic... ... View more

options nomprint nomlogic; %macro check(dsName = ); %let dsid = %sysfunc(open(&dsName, IS)); %if &DSID = 0 %then %put %sysfunc(sysmsg()); %let nlobs = %sysfunc(attrn(&dsid,NLOBS)); %put No of Observation in dataset %trim(&dsName) : %trim(&nlobs); %let rc = %sysfunc(close(&dsid)); %mend; %check(dsName= ); the log options nomprint nomlogic; %macro check(dsName = ); %let dsid = %sysfunc(open(&dsName, IS)); %if &DSID = 0 %then %put %sysfunc(sysmsg()); %let nlobs = %sysfunc(attrn(&dsid,NLOBS)); %put No of Observation in dataset %trim(&dsName) : %trim(&nlobs); %let rc = %sysfunc(close(&dsid)); %mend; %check(dsName= ); ... View more

yes i run d code but it did not give the number of obs & is ur macro call correct?!!! ... View more

dsid, rc, ??? have u defined it, have u run it does it work does it return the number of observations i want the number that's imp. "a macro to determine the number of obs in a data set" ... View more

thanks but i wanted a custom made code with parameters to do so can u provide 1? ... View more

RW( i cannot understand your code 😮 ... View more

Log if data set doesn't exist: "work.data1 outputflag = 0". Log if data set does exist: "work.data1 outputflag = 1". yes ... View more

which logic do i apply with these above given parameters. ... View more

hello RW9 thanks for d reply but this issue how can i solve-> so how can i incorporate this in your code?   1>dsexist is my macro. 2>variables defined-> %let dsname=data1; %let dslib=work; %let outputflag=isexist; %let isexist;->its default value is 0 if 1 then dataset exist if 0 DS doest not exist. ... View more

and can i use %let sysfunc or % to display in d log a msg does the DS exist or not ... View more