topic Re: SAS EG Change label of imported dataset in project view in SAS Enterprise Guide

SAS EG Change label of imported dataset in project view

JediApprentice — Tue, 27 Sep 2016 21:43:02 GMT

Anyone know how to change the label of a SAS dataset that is imported from say an excel spreadsheet. For example, I import an excel sheet called "AWP" using the import wizard. Unlike query builder, there is no option to name the output dataset something different - however, what I'm really after is that when the import is complete, in the project view, the output dataset has a label "Data Imported from AWP" rather than the actual dataset name - "AWP". Even if I right click and go into properties, I'm not allowed to change this label. Any solutions?

Re: SAS EG Change label of imported dataset in project view

CaseySmith — Tue, 27 Sep 2016 23:47:58 GMT

You can change the physical table name on the first page of the Import Data wizard, but as you mentioned, there does not appear to be a way to change the label of the data node that is output from the Import Data task. I view this as a bug (or at least a shortcoming) and will enter an issue in our tracking system to address.

Casey

Re: SAS EG Change label of imported dataset in project view

rogerjdeangelis — Wed, 28 Sep 2016 12:05:27 GMT

I am a little confused.

Why not

libname xel "c:/xls/myxls.xlsx";
data arbitrary_name(label="arbitrary_label");;
  set xel.'sheet1$'n;
run;quit;
libname xel close;

Re: SAS EG Change label of imported dataset in project view

ChrisHemedinger — Wed, 28 Sep 2016 12:11:42 GMT

Hi @rogerjdeangelis,

In this case, the displayed label in the EG process flow is not related to the data set label attribute. Sometimes they are the same, but this is a case where the EG Import Data task assigns a label for the project to display, and it cannot be changed.

If you write your own PROC IMPORT or other method to read in the Excel file, then you can assign your own data set labels.

Re: SAS EG Change label of imported dataset in project view

rogerjdeangelis — Wed, 28 Sep 2016 12:48:52 GMT

My mistake

I did not understand the questions.

I am very ignorant about EG project files.

It is annoyning that I have to log into SAS forum and cannot reply to SAS forum generated emails to my gmail account.

The return address is 'replies.disabled@sas.com. Also it would be very nice if the latest postings could be sent to my email or better yet mirroed on SAS-L. There are a lot of skilled programmers on SAS-L who can help. Same goes for Stackoverflow.

Re: SAS EG Change label of imported dataset in project view

ChrisHemedinger — Wed, 28 Sep 2016 14:38:44 GMT

Hi @rogerjdeangelis,

You can respond by e-mail, but not by using the reply feature in your e-mail program. Instead, use the Reply link at the bottom of the notification you recieve. See details for this process here.

And we are lucky to have many SAS-L and sasCommunity.org participants on this community as well. SAS experts are generous with their time in all forums!

Re: SAS EG Change label of imported dataset in project view

CaseySmith — Tue, 25 Oct 2016 15:24:48 GMT

Just wanted to follow-up and let you all know that we addressed this in the next release. In EG 7.13, you will be able to edit the label for any data node, including output data nodes.

Re: SAS EG Change label of imported dataset in project view

JediApprentice — Tue, 25 Oct 2016 18:09:17 GMT

Awesome, thank you very much. I appreciate it.