topic Re: Determine and return the number of physical observations in the specified dataset. in SAS Programming

Determine and return the number of physical observations in the specified dataset.

RTelang — Wed, 25 Nov 2015 05:37:37 GMT

a generic macro to Determine and return the number of physical observations in the specified dataset.!!!

Re: Determine and return the number of physical observations in the specified dataset.

AbhiD — Wed, 25 Nov 2015 05:44:04 GMT

Please check the link pasted

http://www2.sas.com/proceedings/sugi26/p095-26.pdf

Re: Determine and return the number of physical observations in the specified dataset.

RTelang — Wed, 25 Nov 2015 05:52:38 GMT

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

Re: Determine and return the number of physical observations in the specified dataset.

AbhiD — Wed, 25 Nov 2015 06:42:01 GMT

%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 = );

Re: Determine and return the number of physical observations in the specified dataset.

RTelang — Wed, 25 Nov 2015 06:56:16 GMT

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"

Re: Determine and return the number of physical observations in the specified dataset.

user24feb — Wed, 25 Nov 2015 07:09:18 GMT

Try:

Data A;
  Do i=1 To 18;
    Output;
  End;
Run;

Proc SQL NoPrint;
  * If a dataset is required use;
  Create Table xx As Select Nobs From Dictionary.Tables 
  Where UpCase(Libname)='WORK' AND UpCase(Memname)='A' ;
  * If you need a macro-variable;
  Select Nobs Into :M_Nobs Trimmed From Dictionary.Tables 
  Where UpCase(Libname)='WORK' AND UpCase(Memname)='A' ;
Quit;
%Put ***&M_Nobs.*;

Re: Determine and return the number of physical observations in the specified dataset.

AbhiD — Wed, 25 Nov 2015 07:15:05 GMT

Yes it works if you would have ran it you would have known

Rgds,

Abhi

Re: Determine and return the number of physical observations in the specified dataset.

RTelang — Wed, 25 Nov 2015 07:30:09 GMT

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

Re: Determine and return the number of physical observations in the specified dataset.

AbhiD — Wed, 25 Nov 2015 07:46:12 GMT

can you paste what macro call u used and the log for the same

Re: Determine and return the number of physical observations in the specified dataset.

RTelang — Wed, 25 Nov 2015 08:06:04 GMT

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= );

Re: Determine and return the number of physical observations in the specified dataset.

RTelang — Wed, 25 Nov 2015 08:08:55 GMT

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

Re: Determine and return the number of physical observations in the specified dataset.

AbhiD — Wed, 25 Nov 2015 08:51:20 GMT

In ur macro call please could you pass the dataset name

%check(dsName= <<YOUR DATASET NAME HERE LIBRARY.DATASETNAME)>> );

Re: Determine and return the number of physical observations in the specified dataset.

RTelang — Wed, 25 Nov 2015 09:32:46 GMT

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 : .

Re: Determine and return the number of physical observations in the specified dataset.

RTelang — Wed, 25 Nov 2015 09:33:25 GMT

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

Re: Determine and return the number of physical observations in the specified dataset.

RTelang — Wed, 25 Nov 2015 10:01:17 GMT

what variables are RC & IS ??

Re: Determine and return the number of physical observations in the specified dataset.

RW9 — Wed, 25 Nov 2015 10:23:13 GMT

"Why" do you need a macro? Have you created code which does this in Base SAS, if so then provide it, and that can then be put into a macro. If you just want the number of observations from a dataset, then query the metadata tables (SASHELP.VTABLE, VCOLUMN, or DICTIONARY.TABLES, COLUMS in SQL). User24feb has given you the code for this type of thing.

Re: Determine and return the number of physical observations in the specified dataset.

Kurt_Bremser — Wed, 25 Nov 2015 11:20:11 GMT

%check(dsName=);

you specifically submitted an empty string to the macro, so no dataset could be found.

Supply a valid dataset name, and the macro will work.

Inform yourself about how parameters are passed to macros.

Re: Determine and return the number of physical observations in the specified dataset.

dcruik — Wed, 25 Nov 2015 15:49:29 GMT

Here's a macro similar to @AbhiD. If you don't specify a data set in the macro call, it will print to the log saying no data set specified (1st call). If you specify a data set that does not exist, it will print ot the log saying the data set does not exist (2nd call). If you specify an existing data set, it will print to the log the number of observations in that data set (3rd call). I'm not sure what you're looking to do with the number of observations, so you may want to be more specific. For example, if you want the number of observations in a macro variable or a data set, or if you just want it printed to the log (which is what this will do):

%macro nobs(dsn);
%if &dsn= %then %do;
	%put *****************************;
	%put *** No Data Set Specified ***;
	%put *****************************;
%end;

%else %do;
	%let dsid=%sysfunc(open(&dsn));

	%if &dsid=0 %then %do;
		%put *******************************;
		%put *** Data Set Does Not Exist ***;
		%put *******************************;
	%end;

	%else %do;
		%let obs=%sysfunc(attrn(&dsid,nlobs));
		%put ****************************************************;
		%put *** Number of Observations in Data Set is = &obs ***;
		%put ****************************************************;
	%end;
%end;
%mend;

%nobs();
%nobs(data);

data test;
	do i=1 to 10;
	output;
	end;
run;

%nobs(test);

Re: Determine and return the number of physical observations in the specified dataset.

Patrick — Wed, 25 Nov 2015 21:26:59 GMT

@RTelang

You're asking for ready made code without putting in some own work first - and amazingly people in this forum work for you free of charge.

I believe it's now really up-to-you to spend a bit of time to understand the answers and use stuff as people tell you it needs to be used.

If you continue on the path you've taken then I start to think "troll".

Re: Determine and return the number of physical observations in the specified dataset.

RTelang — Thu, 26 Nov 2015 08:54:09 GMT

i hav done the prog am trying to find a suitable logic through ur inputs has & seen before i gave my code to debug or to see if its correct. am a student learning sas so more number q's from me, give some time i may provide solution to ur probs Patrick k