Did you miss the March 1, 2017 Ask the Expert session on Getting Started with SAS Enterprise Guide? Not to worry, you can reivew it on-demand here
If you did participate, its Q&A is below.
There are a few different tasks in Enterprise Guide that will do this, such as: Split Columns, Stack Columns, Transpose. These tasks can be found under Tasks -> Data.
SAS does not limit the number of records that you can read or write – your hardware and architecture dictate scalability. If you are creating Excel spreadsheets and reach the maximum number of rows, SAS will create another worksheet for the remaining data. Please check with Microsoft for its technologies’ constraints.
Yes, you can work from Excel spreadsheets only. With SAS/ACCESS to PC File Formats, you can read Excel data and Enterprise Guide will create SAS data sets.
Yes, all of those configurations are supported.
A program is SAS code that can be stored externally or within an Enterprise Guide project. A project is the main way that Enterprise Guide organizes its work; a project can contain code, tasks, data and other components. A process flow is a portion of a project; it can contain code, tasks, data, etc. A project may contain multiple process flows and programs; a process flow can contain multiple programs and tasks.
You would need SAS/ACCESS Interface to Oracle. This technology allows you to view, analyze, write and build load Oracle data from within Enterprise Guide as if it were a SAS data set.
Is the number stored as numeric in the SAS data? If so, the leading zeros would not be stored as part of the value. You may want to experiment with storing the zip code as character in the SAS data. It was converted into a numeric within SAS because as a character it was stripped in both SAS and Excel; converting it to numeric SAS retained the leading zero but Excel stripped it out. If it was stored as a numeric in SAS, then it would not store the leading zeros. Perhaps the leading zeros were there because of applying a SAS format?
You can navigate your files and data via Enterprise Guide’s ‘servers’ icon of the lower left corner’s resources pane. Your administrator’s decisions dictate how your server’s storage is organized and how it appears in SAS Enterprise Guide.
There are many techniques for de-duplicating, such as running data explorations or distributions, generating match codes.
This recording for SAS administration tasks is a good place to start https://www.sas.com/en_us/webinars/introduction-sas-admin-tasks-94/register.html
The SAS Administration Coaches Corner on March 8 is a great way to get your SAS administration-related questions aired and answered https://communities.sas.com/t5/Administration-and-Deployment/Admin-Coaches-Corner-set-for-March-8-2-...
Yes, creating these outputs his can be handled programmatically from the program window.
View -> Project Log invokes and reviews more detailed audit trail specifications. We encourage you to visit and interact with your peers in these 2 healthcare specific communities to see how they handle healthcare-specific audit trails:
Please contact your SAS representative after reviewing the suggested communities and links if additional assistance is required.