BookmarkSubscribeRSS Feed
alam_ather
Calcite | Level 5

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

4 REPLIES 4
alam_ather
Calcite | Level 5

The query name is

SASUSER.Check

Kurt_Bremser
Super User

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;

or

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

alam_ather
Calcite | Level 5

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 NoNAMECount
ABCDEFGAHMED AURANGZAB3
ABCDEXYKEVIN2
XYZYESSASHAUN2
MNBZXDSAJEREMY2
PKOIUHTRAROGER2
LKUHJIYGTRFLEX2
LAKSIEAUTELOREN2
POUTYAETWCARLA2
KKAUEEJYAAROBERT2
LAPEINSNXUEALEX2

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

thanks

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

SAS Enterprise Guide vs. SAS Studio

What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 4 replies
  • 927 views
  • 0 likes
  • 2 in conversation