topic Re: DSNAME function not working in SAS Programming

DSNAME function not working

angird1990 — Thu, 21 Mar 2024 13:08:25 GMT

%let dsid=%sysfunc(open(sasuser.houses));
%put The current open data set
is %sysfunc(dsname(1));

I just copied this from the sas documentation site, but it is throwing error. I tried using datastep method as well, rather than macro function , but it is still the same. Below is the log:

338 %let dsid=%sysfunc(open(sasuser.houses));
339 %put The current open data set
340 is %sysfunc(dsname(1));
WARNING: Argument 1 to function DSNAME referenced by the %SYSFUNC or %QSYSFUNC macro function is out of range.
The current open data set is
341

Do anyone know why so?

Re: DSNAME function not working

Quentin — Thu, 21 Mar 2024 13:27:36 GMT

Most likely cause would be you don't have a dataset named sasuser.houses, or you have run the code more than once. If you run the code twice (without closing the dataset you have opened), the value of DSID will be 2 (if the dataset is present).

I would suggest adding a %PUT statement to check the value of DSID. 0 means the dataset was not found and could not be opened.

Also I would use the macro variable DSID inside the DSNAME function instead of hardcoding the value 1. So try:

%let dsid=%sysfunc(open(sashelp.class));
%put dsid=&dsid ;
%put The current open data set is %sysfunc(dsname(&dsid));

And that should work. Then try changing from sashelp.class to sasuser.houses and see if it still works.

Re: DSNAME function not working

angird1990 — Tue, 26 Mar 2024 05:39:21 GMT

Thank you. @Quentin You're right!

Re: DSNAME function not working

Kurt_Bremser — Tue, 26 Mar 2024 10:25:10 GMT

instead of a literal, use the result of the OPEN function
whenever you use OPEN, also issue a CLOSE call in the same submit; make your code clean up after itself

II. is also true for all similar operations (FOPEN/FCLOSE, DOPEN/DCLOSE and so on)