SAS Learning Post

Learn SAS

Learn about the latest tips, tutorials, upcoming events and certifications

Learn SAS

Jim SimonJune 8, 2015 3

When reading a text file (common extensions: TXT, DAT; or, for the adventurous: HTML) with the DATA STEP, you should always view several lines from the text file, and compare to the record layout, before completing the INPUT statement. There are many ways to view a text file. I use

English

Learn SAS

Jim SimonJune 4, 2015 3

Weird PROC FREQ trick

Default PROC FREQ output looks like this: Suppose you don't want the two cumulative statistic columns above. No problem. Those can be suppressed with the NOCUM option on the TABLE statement, like this: proc freq data=sashelp.shoes; table product / nocum; run;

English

Learn SAS | Programming Tips

Charu ShankarJune 1, 2015 6

Looking for a SAS job? Join the 21-day SAS challenge

I recently taught a SAS training course where the students were very engaged. They had so many questions, I could have spent the next month writing helpful blog posts that came from that one class. However, I picked this one question that the class begged for me to share. The

English

Learn SAS | SAS Events

Sian RobertsMay 27, 2015 0

Top 10 bestselling titles at SAS Global Forum 2015

The final figures are in! This year there was a fierce battle for the top spot of the SAS Global Forum 2015 books bestseller list. In a nail biting finish, newcomer, Exchanging Data between SAS and Microsoft Excel: Tips and Techniques to Transfer and Manage Data More Efficiently, beat off

English

Learn SAS | Programming Tips

Charu ShankarMay 27, 2015 14

Life saver tip for comparing PROC SQL join with SAS data step merge

“Phew! That tip alone was a life saver,” said a student in one of my SAS SQL classes. “Before, I would have to read about ten Google search results before I could find that content of the sort you shared in class.” That student was referring to the tip I

English

Learn SAS

Lauren Haworth LakeMay 26, 2015 1

3 reasons you need the new edition of PROC TABULATE by Example

What prompted me to find a co-author and write a new edition of my original book on PROC TABULATE? It’s those inventive developers at SAS. They keep adding new features to make the product even better. There are too many new features and techniques in the book to name, but these are

English

Learn SAS

Jim SimonMay 18, 2015 8

Dataset too big for PROC PRINT?

Dataset too big for PROC PRINT? One weird trick solves your problem! proc print data=bigdata (obs=10); run; The OBS= dataset option specifies the last observation to process from an input dataset. In the above example, regardless of dataset size, only the first 10 observations are printed; an easy way to

English

Learn SAS | Programming Tips

Michael A. RaithelMay 8, 2015 1

Doctor, I have this friend who has a pain right about here

We have all heard the old joke about the person who sidles up to a doctor at a party and describes in great detail a medical problem a "friend" is having in order to get free medical advice. It could just as easily be a person buttonholing an accountant for

English

Learn SAS | Programming Tips

Charu ShankarMay 6, 2015 5

10 reasons to learn SAS code even when you have Enterprise Guide

New York City Mayor, Michael Bloomberg made a new-year's resolution to learn code. Apple’s Steve Jobs said, “I think everybody in this country should learn how to program a computer because it teaches you how to think.” President Barrack Obama said, "Don't just buy a new video game, make one.

English

Learn SAS

Michael SmithMay 4, 2015 0

Become SAS certified at PharmaSUG and save 50% on the exam cost

If you’re one of the hundreds of SAS users registered for PharmaSUG, scheduled for May 17-20 in Orlando, you should give extending your stay some serious thought. In just a few hours, you can set yourself apart with a professional certification from SAS! SAS is offering something no theme park

English

Blogs

Blogs

Learn SAS