topic Re: Retrieving query name in results in SAS Enterprise Guide

Retrieving query name in results

alam_ather — Tue, 03 Jun 2014 07:03:56 GMT

Hi - I wrote following code to export results in excel, but I also want to retrieve query name along with the result. The code is as follows:

proc export data = SASUSER.Check

outfile = "C:\Documents\test\Alerts.xls"

dbms = excel replace;

sheet = "Check";

run;

The above code generates the excel file and replace it every time when I run the code and it works fine but for reference I need to add query name. Please help

thanks

Re: Retrieving query name in results

Kurt_Bremser — Tue, 03 Jun 2014 07:13:19 GMT

What is the "query name"?

Re: Retrieving query name in results

alam_ather — Tue, 03 Jun 2014 07:24:21 GMT

The query name is

SASUSER.Check

Re: Retrieving query name in results

Kurt_Bremser — Tue, 03 Jun 2014 07:51:25 GMT

Then you could use a macro variable to name the sheet like that:

%let query_name=sasuser.check;

proc export data = &query_name

outfile = "C:\Documents\test\Alerts.xls"

dbms = excel replace;

sheet = "&query_name";

run;

%let libraryname=sasuser;

%let query_name=check;

proc export data = &libraryname..&query_name

outfile = "C:\Documents\test\Alerts.xls"

dbms = excel replace;

sheet = "&query_name";

run;

Re: Retrieving query name in results

alam_ather — Tue, 03 Jun 2014 09:39:53 GMT

The above code is running perfectly now I have summarized all the queries in one excel sheet using the following code:

PROC SORT DATA=SASUSER.QUERY_FOR_APPEND_TABLE_0000;

BY DESCENDING 'Alert Count'n;

RUN;

Ref No	NAME	Count
ABCDEFG	AHMED AURANGZAB	3
ABCDEXY	KEVIN	2
XYZYESSA	SHAUN	2
MNBZXDSA	JEREMY	2
PKOIUHTRA	ROGER	2
LKUHJIYGTR	FLEX	2
LAKSIEAUTE	LOREN	2
POUTYAETW	CARLA	2
KKAUEEJYAA	ROBERT	2
LAPEINSNXUE	ALEX	2

The code is giving the above results and now I want to add the query name in the new column, please guide.

thanks