topic Re: two questions on an sas example in SAS Programming

two questions on an sas example

stataq — Fri, 05 Apr 2024 16:32:09 GMT

Hello,

I am reading a sample code from help file and have a question:

why we need

%let dset=&ds; %let dsid = %sysfunc(open(&dset));

1. can we do %let dsid = %sysfunc(open(&ds)); instead?

2. why we need open dataset in order to get info?

%macro obsnvars(ds);
   %global dset nvars nobs;
   %let dset=&ds;
   %let dsid = %sysfunc(open(&dset));
   %if &dsid %then
      %do;
         %let nobs =%sysfunc(attrn(&dsid,NOBS));
         %let nvars=%sysfunc(attrn(&dsid,NVARS));
         %let rc = %sysfunc(close(&dsid));
         %put &dset has &nvars  variable(s) and &nobs observation(s).;
      %end;
   %else
      %put Open for data set &dset failed - %sysfunc(sysmsg());
%mend obsnvars;
%obsnvars(Sasuser.Houses)

Re: two questions on an sas example

Quentin — Fri, 05 Apr 2024 16:38:10 GMT

Hi,

Yes, you could do:

 %let dsid = %sysfunc(open(&ds)) ;

It looks like the macro was designed to create a global macro variable named DSET which is the the name of the dataset, and global macro variables NVARS and NOBS. The macro variable DS will be a local macro variable since it is a parameter to the macro. So if they wanted to create a global macro variable, this explains they need the %GLOBAL statement and the %LET statement.

As for needing to OPEN a dataset to get this variable information, this is only necessary if you want to use SAS File I/O functions. There are other ways you could get this information, for example with PROC CONTENTS.

Re: two questions on an sas example

yabwon — Fri, 05 Apr 2024 16:41:01 GMT

1) the first is just to store value of DS in a global macrovariable DSET, because by macro arguments are local in their scope

2) the dataset has to be opened to reserve it for use and to access its metadata (it's like entering a room, first you need to open the door)

Bart