Editor's note: Since this topic was raised in 2015, SAS has released an open source project named SASPy, which allows you to access SAS from Python and mix Python and SAS features.  SAS has support for programming in a Python/Jupyter notebook environment.In addition, @AriZitin created the Python Integration with SAS tutorial below. Use these outline links to skip to the topic that interests you:   01:14 – Useful Python Packages: SWAT and pandas 02:15 – Connecting to CAS and Accessing In-memory Data 07:21 – Bring Data Locally to use Pandas 11:48 – Handling Missing Values 13:20 – Preparing for Predictive Modeling 15:20 – Building a Decision Tree Model 17:20 – Scoring and Assessing the Decision Tree Model 19:15 – Analyzing Results Locally 23:02 – Building other Models - Random Forest Model and Gradient Boosting Model 29:55 – More CAS Actions that can be Submitted from Python.   For a fullscreen experience, view the tutorial on YouTube: Watch Now     Dear Sir and others, Thank you so much for the responses. I created this discussion a while ago, and I'm glad to see there are at least 3 responses. Well, to give you an idea, the IT services division of our company work with finance and insurance data precisely in Credit Risk, Actuaries largely in Basel 2 modeling, Customer propensity, financial product pricing and Retention. I fully agree there wasn't really a need for Python to come into the picture as SAS's utility met the requirements.   As the design folks are moving gradually to machine learning with the usage of advanced algorithims, the notion of Python ever came to their mind I suppose, while we the so the called developers in the team are mostly from SAS background, the challenge we are facing is learning and getting comfortable in python to make it actionable in real quick time, and mitigating the need of Python by making SAS do more of the work but at the same time not having to rely on expensive SAS tools(SAS being awfully expensive). Also, they(senior management) are having tons of discussions of incorporating everything in django framework(I don't know what is this-some english letters) and beyond.   Funny enough, all this is happening at a time, we SAS users are becoming comfortable with SAS, making the learning rather very steep.   Thanks very much indeed for your thoughts. I really appreciate it.   Cheers, Naveen Srinivasan L&T Infotech   ... View more

data have; input Member $    Units     Date :mmddyy10.; format  date mmddyy10.; datalines;            A               4          1/1/2015         B               3          1/1/2015           A               3          1/5/2015               A               3          1/6/2015           B               8          1/8/2015           A               6          1/11/2015         ; proc sort data= have out=have1; by member date; run; data want; sum=0; do until(last.member);   set have1;   by member;   sum+units;   if sum>10 then    output; end; drop sum; run; Regards, Naveen Srinivasan L&T Infotech ... View more

data example; input street_number & :$50.; datalines; Limburger Str. 15a Genter Str. 1 Schanzenstrasse 12 b Hollunder Weg 92 ; run; data solution; set example; street=substr(street_number,1,anydigit(street_number)-1); Number=substr(street_number,anydigit(street_number),length(street_number)); run; Regards, Naveen Srinivasan L&T Infotech ... View more

data have; input (studentnumber id name lastname) ($) ; datalines; 12345    CSE890122    Carl    Smith 78946    SJE901205    Susan    Johnson 63796    CSE890122    Carl    Smith 36978    EME750615    Eddy    Murphy 42135    SJE901205    Susan    Johnson ; proc sort data=have out=have1; by id; run; data want; set have1; by id; if first.id then count=0; count+1; prev_stnumber=lag(studentnumber); if count>1 then do; studentnumber1=prev_stnumber; studentnumber2=studentnumber; id1=id; id2=id; name1=name; name2=name; lastname1=lastname; lastname2=lastname; output; end; keep studentnumber1 studentnumber2 id1 id2 name1 name2 lastname1 lastname2; run; Regards, Naveen Srinivasan L&T Infotech ... View more

data work;   input ID $ DaystoEvent;   cards; A 100 A 301 A 499 B 200 B 250 C 100 ; proc sql; /* copied from Reeza's*/ select max(count) into :max_count separated by ' ' from (select count(ID) as count from work   group by ID); quit; data want; do _n_=1 by 1 until(last.id);   set work;   by id;   array days(*) Daystoevent1-Daystoevent&max_count;   days(_n_)=DaystoEvent; end; do until(last.id);   set work;   by id;   output; end; run; Regards, Naveen Srinivasan L&T Infotech ... View more

Same as Ballard, with the N function: data want;      set have;      if n(of r1-r9) >=1; run; ... View more