Data analysis is a process of inspecting, cleaning, transforming, and modelling data with the goal of highlighting useful information, suggesting conclusions, and supporting decision making.
The first step in this process is to know about your data…
– Know what kind of data are you dealing with i.e. financial, pharmaceutical etc.
– If you have access to the data..quickly run a freq / means to get data-level information.
– Depending upon your business specific questions we might have to slice and dice / summarize the data.
Often we need to add a prefix to some or all variables in a dataset before we might have to merge datasets that have similar column attributes…This macro would allow you to do that….
It is often frustrating to not see your header when you scroll through records. I sometimes wish we have something similar to WPF Scrollviewer. Since we don’t have one we have to do more plumbing work to get this done. In this article, I am going to explain to achieve this using simple JAVSCRIPT. As […]
SAS Macros that Convert a Directory of Transport Files @ http://www.sas.com/govedu/fda/macro.html
When you submit code or a catalog entry from the Enhanced Editor, the filename or catalog entry name and their respective folders are placed in these environment variables:
contains the full path of the submitted program or catalog entry. The full path includes the folder and the filename.
contains only the name of the submitted program or the catalog entry name.
You can then extract the filename and full path for use in your SAS programs.
After the following DATA step runs and the data is sorted, the PRINT procedure includes the filename in the title and the full path in the footnote of the procedure output. The results are shown below as a Screen Shot
Here’s a simple SAS Macro to delete a SAS dataset…It takes the name of the SAS dataset as the parameter…