PROC SQL – Holland Numerics: Blog and Forums

The SAS Programming Forum has been growing again with new SAS course sections and topics

The SAS course sections and topics themselves are in the SAS Programming Forum, which can only be accessed by Programming level members, but Free members can read the SAS course – Home page and see the individual section and topic names.

The SAS course and the SAS Programming Forum continue to grow, I have just added some new course sections and topics about Data Steps, Base SAS Procedures, PROC SQL, SAS Macros, SAS Enterprise Guide and SAS Studio, and there are now 54 topics in 7 different sections:

A. SAS components – 2 topics
B. Data Steps – 14 topics (1 new topic)
C. Base SAS Procedures – 6 topics (new section)
F. PROC SQL – 15 topics (1 new topic)
G. SAS Macros – 15 topics (11 new topics)
N. SAS Enterprise Guide – 1 topic (new section)
O. SAS Studio – 1 topic (new section)

More topics and sections are being developed, so register for free now to be kept up-to-date about all of the news, so you can take advantage of the Programmer level when it suits you best!

Would you like 1/2 day or 1 day SAS training at PharmaSUG China 2020?

I was considering attending PharmaSUG China at the end of August 2019, but I’ve been told that a seminar held previously in China on SAS programming efficiency had a low attendance, as programmers there are relatively young, so they like to learn techniques on their own, or take classes on topics that they cannot learn from the internet. However, they prefer challenging topics, which are hard to learn on their own.

I have now decided to delay what could be my one and only visit to China until 2020, and use the extra preparation time to find out a little more about what SAS programmers in China would be most interested in.

Therefore, please could you help me by answering this quick poll about the 1/2 day training sessions I currently provide. The answers will guide me to the best package to offer to PharmaSUG China 2020. Links to most of the training courses can be found below the poll.

If you have not yet voted and can view the poll results, but the Vote button is grey, your IP address may already have been used to vote on this poll. This is in fact quite common when viewing blog posts from a company PC, so I would therefore recommend that you try voting using your phone or your home PC instead.

Thank you in advance………..Phil

I'm planning to go to PharmaSUG China in 2020. Which 1/2 day training courses would you be interested in attending there? (max 2)

Efficient SAS Programming (28%, 7 Votes)
Defensive SAS Programming (24%, 6 Votes)
Introduction to ODS Graph Templates (20%, 5 Votes)
SAS PROC SQL (12%, 3 Votes)
Enterprise Guide and SAS Studio (8%, 2 Votes)
Practical ODS Graphics (8%, 2 Votes)

Total Voters: 14

Loading ...

Apologies to anyone who recently downloaded my SAS Training Course List, but a new one for 2018 is now available!

Apologies to anyone who recently downloaded my SAS Training Course List, but a new one for 2018 is now available as a free download!

The significant updates in the 2018 list are:

The new 1/2-day PROC SQL course is now available.
A new 1/4-day Introduction to ODS RTF course is now included, which should be considered as an add-on course, rather than to be booked on its own. Note that a 1/4-day course costs half of a 1/2-day course. However, any travelling and accommodation expenses will be the same, of course.

Finally a quick reminder that course notes for some of the courses can be purchased separately as PDF eBooks or Android apps. See the training page in the Product Shop for all the available course notes and also the latest Training Course List.

I’ve added the final topic of the PROC SQL course in the SAS course (in the SAS Programming Forum)

I’ve added the final topic of the PROC SQL course in the SAS course (in the SAS Programming Forum), and it describes some of the limitations and differences between the SQL language in PROC SQL and the ANSI (American National Standards Institute) guidelines for SQL.

I’ve also added, for those who don’t want to follow the course but would prefer to read the course notes, a copy of course notes as a downloadable PDF ebook, and have published Android ebook apps with the same content on Google Play and Amazon Appstore.

As other SAS courses are finalised I will be publishing them as PDF ebooks and Android apps too.

The SAS Programming Forum is growing again with 8 new SAS course topics

The SAS course and the SAS Programming Forum continue to grow, I have just added 8 new course topics about PROC SQL, and there are now 33 topics in 4 different sections:

[A] SAS components – 2 topics
Data Steps – 13 topics
[F] PROC SQL – 14 topics (8 new topics!)
[G] Macros – 4 topics

The SAS course topics themselves are in the SAS Programming Forum, which can only be accessed by Programmer level members, but Free members can read the SAS course – Home page and see the individual topic names.

More topics and sections are being developed, so register for free now to be kept up-to-date about all of the news, so you can take advantage of the Programmer level when it suits you best!

The SAS macros section has been added to the SAS course

The SAS course and the SAS Programming Forum continue to grow, I have just added a new course section about SAS macros, and there are now 23 topics in 4 different sections:

[A] SAS components – 2 topics
Data Steps – 13 topics
[F] PROC SQL – 6 topics
[G] Macros – 2 topics (2 new topics!)

More topics and sections are being developed, so register for free now to be kept up-to-date about all of the news, so you can take advantage of the Programmer level when it suits you best!

The SAS Programming Forum is growing: a new SAS course topic posted and another SAS question answered

The SAS course and the SAS Programming Forum continue to grow, I have just added a new course topic about the PROC SQL data set combining, and there are now 21 topics in 3 different sections:

[A] SAS components – 2 topics
Data Steps – 13 topics
[F] PROC SQL – 6 topics (1 new topic!)

I’ve also added an answer to a new SAS-related question in the SAS Programming Forum about re-ordering data sets without using PROC SORT. Again this topic can only be accessed by Programmer level members.

More topics and sections are being developed, so register for free now to be kept up-to-date about all of the news, so you can take advantage of the Programmer level when it suits you best!

Another new post in the SAS course making a total of 20 topics in 3 sections

The SAS course continues to grow, I have just added a new topic about the PUT statement, and there are now 20 topics in 3 different sections:

[A] SAS components – 2 topics
Data Steps – 13 topics (1 new topic!)
[F] PROC SQL – 5 topics

The SAS course topics themselves can only be accessed by Programmer level members, but Free members can read the SAS course – Home page and see the individual topic names.

More topics and sections are being developed, so register for free now to be kept up-to-date about all of the news, so you can take advantage of the Programmer level when it suits you best!

A new SAS course section about PROC SQL has been started

While I have been working on the final topic(s) for the Data Steps section of the SAS course on the FILE & PUT statements, I have read a number of questions on the web about PROC SQL syntax. I was not going to start this section until somewhat later, but I have decided to publish the first few topics to explain some of the most useful PROC SQL syntax, so look out for the following topics in the next few weeks:

SELECT & FROM
ORDER BY
GROUP BY & HAVING
Joins, WHERE & ON
INTO
DISTINCT
Summary functions

The SAS course topics can only be accessed by Programmer level members, but Free members can read the SAS course – Home page.