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?
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
Register today and join us virtually on June 16!
sasglobalforum.com | #SASGF
View now: on-demand content for SAS users
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
Register today and join us virtually on June 16!
sasglobalforum.com | #SASGF
View now: on-demand content for SAS users
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;
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.
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.
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!
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.
Register today and join us virtually on June 16!
sasglobalforum.com | #SASGF
View now: on-demand content for SAS users
Awesome, thank you very much. I appreciate it.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 16. Read more here about why you should contribute and what is in it for you!
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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: