Presentations:Art297 Papers and Presentations

From sasCommunity
Jump to: navigation, search
QR Code for this page
  Art297 Papers and Presentations QR Code.png
My LinkedIn Profile

Feel free to either email me courtesy of the sasCommunity site or comment on the Discussion tab for this page


  1. A Better Way to Flip (Transpose) a SAS Dataset
    Categories: Abbreviations and Macros, Art297 Papers and Presentations, Data Structure and Management, MWSUG 2013, Macro Language, Presentations, SAS Global Forum 2013, TRANSPOSE Procedure
    Many SAS programmers have flipped out when confronted with having to flip (transpose) a SAS dataset, especially if they had to transpose multiple variables, needed transposed variables to be in a specific order, had a mixture of character and numeric variables to transpose, or if they needed ..→
  2. A Poor/Rich SAS Users Proc Export
    Categories: Abbreviations and Macros, Art297 Papers and Presentations, EXPORT Procedure, Excel, MWSUG 2013, Macro Language, Presentations, SAS Global Forum 2014
    Have you ever wished that with one click you could copy any SAS® dataset, including variable names or labels (if desired), and automagically create or modify an Excel workbook, or paste the table into a Word file or Powerpoint presentation? Or, when accomplishing such a task, have you ..→
  3. An Easier and Faster Way to Untranspose a Wide File
    Categories: Abbreviations and Macros, Art297 Papers and Presentations, Data Structure and Management, Macro Language, Presentations, SAS Global Forum 2018, TRANSPOSE Procedure
    PROC TRANSPOSE is an extremely powerful tool for making long files wide, and wide files less wide or long, but getting it to do what you need often involves a lot of time, effort, and a substantial knowledge of SAS® functions and data step processing. This is especially true when you have to ..→
  4. Automagically Copying and Pasting Variable Names
    Categories: Art297 Papers and Presentations, Coder's Corner, Data Structure and Management, MWSUG 2012, Presentations, SAS Global Forum 2010
    Have you ever wished that, with one click, you could copy any table's variable names (or labels) so that you could paste them into your editor or possibly a Word file, powerpoint or spreadsheet? You can and, with just base SAS®, there are some little known but easy to use methods available ..→
  5. Copy and Paste Almost Anything
    Categories: Art297 Papers and Presentations, Presentations, SAS Global Forum 2012
    Every day, data appear on computer screens in various formats. The data might be in the form of Excel spreadsheets, wiki pages, html, pdf, Word documents or medium that is available to display data forms and tables. And, quite often, the files or pages include more than just the data of ..→
  6. Copy and Paste from Excel to SAS
    Categories: Art297 Papers and Presentations, Coder's Corner, Excel, MWSUG 2013, Presentations, SAS Global Forum 2013
    Most, if not all, of us are far too familiar with the problems that one can confront when trying to import an Excel workbook into a SAS® dataset. Numeric fields might be imported as character fields, dates might be imported as either character fields or dates that are sixty (60) years earlier ..→
  7. Excelling to Another Level with SAS
    Categories: Abbreviations and Macros, Art297 Papers and Presentations, Data Structure and Management, EXPORT Procedure, Macro Language, Presentations, SAS Global Forum 2018
    Have you ever wished that with one click (or submitting one macro call) you could copy any SAS® dataset, include or exclude variable names or labels, automagically create or modify Excel workbooks, or paste tables into files? Or how about doing any of the above but, at the same time, create Pivot ..→
  8. Expert Panel Solution MWSUG 2013-Tabachneck
    Categories: Art297 Papers and Presentations, MWSUG 2013, Presentations
    DC & H posed a rather typical research question, namely find a group of needles in a haystack. Specifically, the firm lost a disk which contained identification information for 1,000,000 bank customers, and wanted analysts to identify what the law firm might focus on in order to mitigate the ..→
  9. Increase Your Productivity by Doing Less
    Categories: Abbreviations and Macros, Art297 Papers and Presentations, Coder's Corner, MWSUG 2013, Macro Language, Presentations, SAS Global Forum 2013
    Using a keep dataset option when declaring a data option has mixed results with various SAS® procedures. It might have no observable effect when running PROC MEANS or PROC FREQ but, if your datasets have many variables, it could drastically reduce the time required to run some procs like ..→
  10. Index to SAS-L Chance to Make SAS-L History Posts
    Categories: Art297 Papers and Presentations, Best Practices, Coder's Corner, Lists and Indexes, SAS-L, SAS Global Forum 2011
    In 2006, Michael Raithel challenged SAS-L members to become part of a thread that was intended to be the longest running SAS-L thread ever. The goal of the thread, other than to become the longest running thread, was to get people to share tips they thought would be useful to other SAS ..→
  11. Sometimes One Needs an Option with Unusual Dates
    Categories: Art297 Papers and Presentations, Coder's Corner, Dates Times Datetimes, Dates and Times, HOLIDAY Function, Presentations, Programming, SAS Global Forum 2012
    Do you have date range analytical needs that you haven’t been able to solve with the SAS® interval and holiday functions? You have if those needs involved analyzing a date range that didn’t start at the beginning, end or middle of a given month, involved holidays other than the US and ..→
  12. Using SAS® to Build Web Pages Linking Photographs with Google Maps
    Categories: Art297 Papers and Presentations, Coder's Corner, Presentations, SAS Global Forum 2012
    Many of us at least occasionally take a picture with either a digital camera or cell phone. And some of us, be it for work, a SAS user group, or for personal use, end up posting some of our pictures on a web page. JPG files can contain a lot more information than just the pictures one sees, ..→
  13. Yet Another Sudoku Solver: PROC FCMP
    Categories: Art297 Papers and Presentations, Presentations, SAS Code, SAS Global Forum 2012, Sudoku and SAS - Code
    There have been many different Sudoku solvers written using various SAS® tools (e.g., DATA step, PROC CLP, PROC OPTMODEL with MILP Solver, and PROC SQL). This paper introduces yet another tool, PROC FCMP, which can be used to solve Sudoku puzzles using recursive functions. A unique feature of ..→