Desktop productivity for business analysts and programmers

SAS EG Change label of imported dataset in project view

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 123
Accepted Solution

SAS EG Change label of imported dataset in project view

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?


Accepted Solutions
Solution
‎09-28-2016 10:12 AM
SAS Super FREQ
Posts: 306

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

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

View solution in original post


All Replies
Solution
‎09-28-2016 10:12 AM
SAS Super FREQ
Posts: 306

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

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

Valued Guide
Posts: 505

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

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;




Community Manager
Posts: 2,889

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

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.  

Valued Guide
Posts: 505

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

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.

Community Manager
Posts: 2,889

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

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!

SAS Super FREQ
Posts: 306

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

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.

Frequent Contributor
Posts: 123

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

Awesome, thank you very much. I appreciate it.

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 7 replies
  • 1059 views
  • 8 likes
  • 4 in conversation