SAS Professionals

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


Here's how you can get involved.


reading large excel data into sas 2 Replies

Hi all,I was trying to import excel file(xls or xlsx or csv) with around 3000 columns and 100 rows. when I useMethod 1: porc import (for .xlsx file) I am able to get only few variable names(around 2100) and rest of those variables are having the…Continue

Started by sunil kopparapu. Last reply by Jonathan Williamson yesterday.

Building a hierarchy value in a dataset

I have a General Ledger (GL) export which has the following 4 headers. I need to create a new Variable Level which is hierarchy order number to assist with the determination of levels at which GL will be reported i.e. Summary or DetailI need the…Continue

Started by Mark Corr Sep 21.

Multivariate ROC Curve Plot

I have created a ROC Curve using PROC LOGISTIC. I understand that it is a plot of sensitivity against 1-specificity (True Positives against False Positives) for a range of cutoff values of X.If I have one variable X I can easily convert between…Continue

Started by Kier Finnegan Sep 7.

Can we sort two or more data set in one proc? 4 Replies

I have tried to sort my two data set in one proc... I am getting syntax error.... can anyone please help me,Am i doing something wrong ? Is it possible to do so ?like : proc sort data= ds ds1;run;Continue

Started by Prachi Mishra. Last reply by Wayne McMillan Aug 31.

Summertime And the Writin' Is Easy

SAS Programming Professionals,Got the late summertime blahs because your programming work has slowed down?  Then, check out my blog for a suggestion on what you can do with your extra time:…Continue

Started by Michael A. Raithel Aug 22.

Blog Posts

Hack 2.2 Creating a Subset of a SAS Data Set for Testing

SAS Programming Professionals,

Check out this hack: …


Posted by Michael A. Raithel on February 19, 2016 at 13:19

Know Your Onions* – Meet Up at #SASGF #TweetUp

Who’s excited about SAS Global Forum (SASGF) 2016 in Las…


Posted by Michelle Homes on January 19, 2016 at 0:36

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


© 2016   Created by Richard Peace.   Powered by

Badges  |  Report an Issue  |  Terms of Service