SAS Professionals

Creating relationships... and keeping SAS users In the Know


Here's how you can get involved.

Welcome to the new look

After consulting with existing SAS Professional users, we felt the time was right to make some changes to the layout of the network. The changes we have made are designed to make the site easier to use, and we have also taken this opportunity to retire some of the old functionality that was rarely used. We hope you enjoy the changes we have made and continue to join in the discussion on SAS Professionals.

If you have any questions or comments, please do not hesitate to contact Terry Salmon.


Exporting data from SAS EG 4.3 gets dates incorrectly formatted in Excel

We do calculations in SAS EG 4.3  and then export the results to Excel 2007 using the Sas Excel Add-in. An Excel macro then copies selected lines of data and pastes values into a new, largely empty, template.However, however we format the dates in…Continue

Started by Ian Selwyn Knight 19 hours ago.


Hi all, Wondering if anyone has set-up RTM to authenticate to LDAP using certificates?In ldap.conf, we need to make sure the following is set:-TLS_RECERT demand ...setting this to allow, works Many thanksContinue

Started by Divs Pankhania on Tuesday.

Optimise Code

HelloI run the attached code, which seems to take some time, Does annyone know if this code can be optimised?I am creating 3 datasets from one set of data;1) Unique records by 2 reference fields (MPN & MSN)2) Unique records by 1 reference -…Continue

Started by darren hoggard on Tuesday.

Different reference lines in different panels in an SGPANEL plot

Hello,I wish to add different horizontal reference lines to each panel in an SGPANEL plot. I currently can only have the one reference line at 0.83proc sgpanel data=TEMP;panelby AvPatRef / layout=panel columns=3; format patcorr_order corrformatnum.;…Continue

Tags: line, reference, sgpanel

Started by Alexander Pate Sep 29.

SAS Advanced Certification 1 Reply

Hi Guys,I'm planning to appear for the SAS Advanced Certification(A00-212). I've studied the prep. guide provided by the SAS inc. but there are some loopholes here and there.If you could please help me with some practice ques., I'll be very…Continue

Started by Ankur Sarwate. Last reply by Georg Spearing Sep 28.

Address String Breakdown

Hi All,I was wondering if anyone could help, I currently have an address field that is a string of text but I would like to break it down into a number of variables (e.g. address line 1, address line 2 etc). I have included some examples below and…Continue

Started by Thomas Barton Sep 28.

Blog Posts

Don’t let your competitors be the first to buy a ticket to the data lottery

There are still many barriers when it comes to big data analytics adoption, especially weighing up costs against return on investment. SAS' Paul Jones suggests businesses need to explore their data first to unlock the…


Posted by Katie Cairns on July 29, 2015 at 8:52

Fun Friday: Game theory test for the British public

Don’t be too quick to answer, sometimes answers to questions require some strategic thinking. Have you ever been faced with questions like the ones below? Do you know how you’d truly answer?…


Posted by Katie Cairns on July 24, 2015 at 14:59

The future of machine learning is now

The future of machine learning and its expected benefits have been widely discussed for years, but it seems like the future is now.

The fusion of machine learning and data mining has provided the ability to…


Posted by Katie Cairns on July 23, 2015 at 16:43

Will fluid and flowing big data be more important than stationary and at rest big data? by Mark Torr

Now that we’ve got the first 'v' of big data, volume, under control with advanced technologies and solutions, the second 'v', velocity, is starting to gain more importance.

Increasingly, the valuable data…


Posted by Katie Cairns on July 22, 2015 at 11:16



Latest Activity

© 2015   Created by Richard Peace.

Badges  |  Report an Issue  |  Terms of Service