SAS Users

Programming Tips

Strengthen your programming skills with tips and techniques from the experts

Programming Tips

Lelia McConnellJanuary 20, 2017 2

Comparing SAS/GRAPH® 9.4 capabilities with SAS/GRAPH® Version 6

I remember my grandparents talking about how hard things were for them growing up. They would say, “Things were so bad that we had to walk uphill, both ways, in the freezing snow to get to school.” It was always hard for me to relate to these statements because the

English

Programming Tips | SAS Administrators

Edoardo RivaDecember 27, 2016 0

More SAS Studio Tips for SAS Grid Manager Administrators: Global Settings

We have seen in a previous post of this series how to configure SAS Studio to better manage user preferences in SAS Grid environments. There are additional settings that an administrator can leverage to properly configure a multi-user environment; as you may imagine, these options deserve special considerations when SAS Studio

English

Programming Tips | SAS Administrators

Scott McCauleyDecember 21, 2016 0

Easier Space Management for EV Data Mart Tables in 9.4M4

The report-ready SAS Environment Manager Data Mart has been an invaluable addition to SAS 9.4 for SAS administrators. The data mart tables are created and maintained by the SAS Environment Manager Service Architecture Framework and provide a source of data for out-of-the box reports as well as custom reports that any

English

Programming Tips

Andrew ChristianDecember 19, 2016 4

Dr. Strangeformat or: How I Learned to Stop Joining Tables and Love the PROC

The title of this post borrows from Stanley Kubrick’s 1964 comedy “Dr. Strangelove or: How I Learned to Stop Worrying and Love the Bomb.” It stars the great Peter Sellers as the titular character as well as George C. Scott and Slim Pickens. The black and white film is strange

English

Programming Tips

Jerry LeonardDecember 16, 2016 0

Creating and Using Multilabel Formats

A multilabel format enables you to assign multiple labels to a value or a range of values. The capability to add multilabel formats was added to the FORMAT procedure in SAS® 8.2. You assign multiple labels by specifying the MULTILABEL option in the VALUE statement of PROC FORMAT. For example,

English

Learn SAS | Programming Tips

Leonid BatkhanDecember 15, 2016 28

Truncating decimal numbers in SAS without rounding

Imagine making $50K a day out of thin air. Did you know that NASDAQ routinely processes around 10,000,000 trades a day? What if instead of rounding cents for each transaction, market makers truncated fractions of cents in the amount they owe you? Under the assumption that each transaction, on average,

English

Programming Tips

Edoardo RivaDecember 12, 2016 2

SAS Studio Webwork library demystified

In a previous blog about SAS Studio I’ve briefly introduced the concept of using the Webwork library instead of the default Work. I also suggested, in SAS Global Forum 2016 paper, Deep Dive with SAS Studio into SAS Grid Manager 9.4, to save intermediate results in the Webwork library, because

English

Data Management | Programming Tips

Mary Kathryn QueenNovember 30, 2016 0

Securing sensitive data using SAS Federation Server at the data source level

Data virtualization is an agile way to provide virtual views of data from multiple sources without moving the data. Think of data virtualization as an another arrow in your quiver in terms of how you approach combining data from different sources to augment your existing Extract, Transform and Load ETL batch

English

Data Management | Learn SAS | Programming Tips

Leonid BatkhanNovember 25, 2016 16

Modifying variable attributes in all datasets of a SAS library

Using the DATASETS procedure, we can easily modify SAS variable attributes such as name, format, informat and label: proc datasets library=libref; modify table_name; format var_name date9.; informat var_name mmddyy10.; label var_name = 'New label'; rename var_name = var_new_name; quit; We cannot, however, modify fixed variable attributes such as variable type

English

Data Visualization | Programming Tips

Teri PatsilarasNovember 15, 2016 3

Use images in SAS Visual Analytics to enhance your report link

If your SAS Visual Analytics report requirements include linking out to separate reports without the need to pass values, you may want to consider using images to enhance the appearance of your base report. Here are three style examples using images that you can use depending on your report design

English

Blogs

Blogs

Programming Tips