topic Re: Name of previous dataset in SAS Programming

Name of previous dataset

JasonDiVirgilio — Fri, 20 Apr 2012 15:04:38 GMT

I know if I put the following Proc Print in my code, it will print the data for the last dataset created (previous dataset):

Proc print;

run;

But what I'd really like to do is put that in a macro with that grabs the name of the last dataset created and puts it into a TITLE statement. Is there a way to know the name of the dataset that was created?

Thanks,

Re: Name of previous dataset

art297 — Fri, 20 Apr 2012 15:14:59 GMT

Have you tried using the automatically created macro variable: &sysdsn. ?

There are a lot of automatically created macro variables that capture things you might want. Take a look at: http://support.sas.com/documentation/cdl/en/mcrolref/61885/HTML/default/viewer.htm#a001071968.htm

Re: Name of previous dataset

Haikuo — Fri, 20 Apr 2012 15:15:23 GMT

sysdsn

Haikuo

Re: Name of previous dataset

Linlin — Fri, 20 Apr 2012 15:16:23 GMT

data class;

set sashelp.class;

proc print data=&syslast;

title from dataset &syslast;

run;

Re: Name of previous dataset

PGStats — Fri, 20 Apr 2012 15:20:19 GMT

data test;
x=1;
run;

title "Created &SYSLAST";

proc print; run;

Re: Name of previous dataset

JasonDiVirgilio — Fri, 20 Apr 2012 15:26:50 GMT

Thanks everyone...sysdsn and syslast both work great...they even include the libname used.

Interestingly, &syslast uses the format "libname.datasetname"

...where &sysdsn uses the format "libname datasetname"

Re: Name of previous dataset

Peter_C — Sat, 21 Apr 2012 12:30:06 GMT

HI Jason

One wish remains unfulfilled. To have a convenient subtitle reporting the data set used in the reporting procedure we still need to submit that subtitle statement.

I would quite like have a feature that resolves when the procedure executes and not just when the title(n) or footnote statement is submitted.

footnote3 "reporting from #latest_ds" ;

I chose the # prefix because something like this used #byVal

just thinking

Re: Name of previous dataset

data_null__ — Sat, 21 Apr 2012 13:35:15 GMT

Do you remember the super-duper PROC QPRINT. It had options to include DSName and or DSLabel in the output

Re: Name of previous dataset

Peter_C — Sun, 22 Apr 2012 11:53:45 GMT

vaguely I recall qprint not providing what I needed (at the time) and proc print, did so I restricted that bit of learning (sounds like the well prepared excuse it is).

However didn't qprint become fsprint? forerunner of fsview and fsreport (now proc report)?

there is an excellent certification proposed by ChrisH in his SASDummy blog back at the beginning of this month for which I do not wish to qualify!

😉

Re: Name of previous dataset

data_null__ — Sun, 22 Apr 2012 12:28:58 GMT

Peter.C wrote:

vaguely I recall qprint not providing what I needed (at the time) and proc print, did so I restricted that bit of learning (sounds like the well prepared excuse it is).

It is quite possible that QPRINT did not provided what you needed at the time. I wouldn't know anything about that.

However didn't qprint become fsprint? forerunner of fsview and fsreport (now proc report)?

No.