BookmarkSubscribeRSS Feed
☑ This topic is solved. Need further help from the community? Please sign in and ask a new question.
BruceBrad
Lapis Lazuli | Level 10

I have a file open from the library browser in enterprise guide. I want to edit the file in the browser. For example, to change a format on a variable temporarily to inspect the data. How do I switch to edit mode to do this?

1 ACCEPTED SOLUTION

Accepted Solutions
ChrisHemedinger
Community Manager

You can edit data in EG. To trigger Edit mode, simply press a key when the cursor is focused on a value in the data grid view. If you have write access to the library, you will be prompted to go into Edit mode.

 

You can then change values, and right-click on a column to change its properties. This can include Formats and Informats.

 

editview.jpg

 

All changes that you make are immediate and permanent, so if you just want a view with another format, it might not be what you want to do. 

 

If you want to apply a new format without creating a copy of the data, you could create a VIEW:

data class / view=class;
 set sashelp.class;
 format Height dollar8.;
run;

 

SAS For Dummies 3rd Edition! Check out the new edition, covering SAS 9.4, SAS Viya, and all of the modern ways to use SAS!

View solution in original post

9 REPLIES 9
yabwon
Amethyst | Level 16

In contrary to SAS Display Manager SAS EG is just a "flat" client that allows to run code and preview data, but not edit datasets directly.  Such edits, which were possible in DMS ViewTable tool, are not easy when you have EG on your local machine and the data on the other side of word on a remote server.

 

What I'd do is to use for example proc print with format statement, plus OBS= data set option to limit printed observations, e.g.,

proc print data=sashelp.class(obs=5);
  format Height yymmdd10.;
run;

to get:

yabwon_0-1755085524861.png

 

Bart

 

_______________
Polish SAS Users Group: www.polsug.com and communities.sas.com/polsug

"SAS Packages: the way to share" at SGF2020 Proceedings (the latest version), GitHub Repository, and YouTube Video.
Hands-on-Workshop: "Share your code with SAS Packages"
"My First SAS Package: A How-To" at SGF2021 Proceedings

SAS Ballot Ideas: one: SPF in SAS, two, and three
SAS Documentation



BruceBrad
Lapis Lazuli | Level 10
OK, so not possible. (Of course, many of us are using EG with the data on the same machine, but I understand the general principle).
ChrisHemedinger
Community Manager

You can edit data in EG. To trigger Edit mode, simply press a key when the cursor is focused on a value in the data grid view. If you have write access to the library, you will be prompted to go into Edit mode.

 

You can then change values, and right-click on a column to change its properties. This can include Formats and Informats.

 

editview.jpg

 

All changes that you make are immediate and permanent, so if you just want a view with another format, it might not be what you want to do. 

 

If you want to apply a new format without creating a copy of the data, you could create a VIEW:

data class / view=class;
 set sashelp.class;
 format Height dollar8.;
run;

 

SAS For Dummies 3rd Edition! Check out the new edition, covering SAS 9.4, SAS Viya, and all of the modern ways to use SAS!
yabwon
Amethyst | Level 16

@ChrisHemedinger 

 

Hey Chris, Thank you! I Didn't know that!

 

Bart

 

_______________
Polish SAS Users Group: www.polsug.com and communities.sas.com/polsug

"SAS Packages: the way to share" at SGF2020 Proceedings (the latest version), GitHub Repository, and YouTube Video.
Hands-on-Workshop: "Share your code with SAS Packages"
"My First SAS Package: A How-To" at SGF2021 Proceedings

SAS Ballot Ideas: one: SPF in SAS, two, and three
SAS Documentation



BruceBrad
Lapis Lazuli | Level 10
This is perfect. I'm doing this when testing the program, and will re-create the datafile at the end.
yabwon
Amethyst | Level 16

@BruceBrad since my answer is clearly wrong, maybe you can mark @ChrisHemedinger answer as the solution? 

_______________
Polish SAS Users Group: www.polsug.com and communities.sas.com/polsug

"SAS Packages: the way to share" at SGF2020 Proceedings (the latest version), GitHub Repository, and YouTube Video.
Hands-on-Workshop: "Share your code with SAS Packages"
"My First SAS Package: A How-To" at SGF2021 Proceedings

SAS Ballot Ideas: one: SPF in SAS, two, and three
SAS Documentation



BruceBrad
Lapis Lazuli | Level 10
Can't see how to undo my solution choice. Is that possible?
ChrisHemedinger
Community Manager

Hi @BruceBrad - no, there is no Undo with this feature. So my advice is to use it only on temp data (for experimenting) or in a situation where you need to make a permanent change.

 

Since there is no code generated as part of this operation, it's not repeatable in the same way a code step or task step would be in your flow.

SAS For Dummies 3rd Edition! Check out the new edition, covering SAS 9.4, SAS Viya, and all of the modern ways to use SAS!
BruceBrad
Lapis Lazuli | Level 10

Looks like the moderator has changed the solution to the correct one. Thanks all.

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

Creating Custom Steps in SAS Studio

Check out this tutorial series to learn how to build your own steps in SAS Studio.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 9 replies
  • 641 views
  • 7 likes
  • 3 in conversation