SAS EG Change label of imported dataset in project view

[JediApprentice]

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?

[CaseySmith · Accepted solution]

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

[rogerjdeangelis]

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;

[ChrisHemedinger]

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.  

[rogerjdeangelis]

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.

[ChrisHemedinger]

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!

[CaseySmith]

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.

[JediApprentice]

Awesome, thank you very much. I appreciate it.