naveen_srini Tracker

Re: How to Print Observations that Come after a certain number of total units

naveen_srini — Fri, 31 Jul 2015 13:03:46 GMT

Sorry for the late response as I haven't been active here. "Regardless of units" or is regardless of member sort? I am asking this to make proper business sense. There is only 4 service dates for member A.

Anyway taking the notsorted "have" , a super simple logic below should suffice:

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
;
data want;
set have;

if mod(_n_,6)=0 then
output;
run;

Naveen Srinivasan

L&T Infotech

Re: SAS vs Python or SAS with Python?

naveen_srini — Mon, 15 Jun 2015 12:23:45 GMT

"senior management" (which often translates to "immature imbeciles who couldn't find their ass even when sitting on their own hands")

I love that line hahahahaha:smileylaugh::smileylaugh:

Re: SAS vs Python or SAS with Python?

naveen_srini — Thu, 31 Oct 2019 19:44:17 GMT

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

Re: Comparing columns

naveen_srini — Fri, 17 Apr 2015 18:44:42 GMT

The same code will produce your desired results for your Carl Jackson inclusion without having to worry about the change is name or last name because the count condition is done based on by group processing of ID. So chill:

data have;

input (studentnumber id name lastname) (:$10.) ;

datalines;

12345 CSE890122 Carl Smith

78946 SJE901205 Susan Johnson

63796 CSE890122 Carl Smith

36978 EME750615 Eddy Murphy

42135 SJE901205 Susan Johnson

98523 CSE890122 Carl Smith

56795 CSE890122 Carl Jackson

;

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 and count<3 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;

Re: Comparing columns

naveen_srini — Fri, 17 Apr 2015 13:56:38 GMT

Hi,

/*modified code*/

data have;

input (studentnumber id name lastname) (:$10.) ;

datalines;

12345 CSE890122 Carl Smith

78946 SJE901205 Susan Johnson

63796 CSE890122 Carl Smith

36978 EME750615 Eddy Murphy

42135 SJE901205 Susan Johnson

98523 CSE890122 Carl Smith

;

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 and count<3 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;

Re: How to Print Observations that Come after a certain number of total units

naveen_srini — Thu, 16 Apr 2015 12:01:11 GMT

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

Re: Splitting street from number (split string into two variables)

naveen_srini — Wed, 15 Apr 2015 10:15:25 GMT

Sir, Forgive me, I trust and totally agree PRX will work seamlessly, but I am not even anywhere close or to your level of expertise, so I still have to learn PRX from the very begining. I really appreciate sharing the doc, does the really cover from the very basic to considerable advance level of PRX functions and should i have to learn perl scripting before learning to use PRX functions, If so, that sounds very daunting.:smileyconfused:

BTW, I have taken a lot of your help in the past from other posts, although never had a chance to thank personally. Cheers!

Re: Splitting street from number (split string into two variables)

naveen_srini — Wed, 15 Apr 2015 10:07:58 GMT

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

Re: Splitting street from number (split string into two variables)

naveen_srini — Wed, 15 Apr 2015 09:51:06 GMT

have you tried using ANYDIGIT function?

Re: SAS Book

naveen_srini — Sat, 11 Apr 2015 17:26:24 GMT

Hi, I'd recommend, just go buy anything that you can authored by Ron Cody.

SAS Press - Ron Cody Author Page

Wish , i could afford to buy all of his books. Believe me, If a guy of below average intelligence like me can learn to code on learning from the examples given in his books, anybody can. If you are active, and not lazy like me and if you can complete learning from each and every example of his book, you are soon to program like Art T et al etc.

Re: Comparing columns

naveen_srini — Fri, 10 Apr 2015 16:03:37 GMT

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

Re: can i open sas7bdat file in sas eg 6.1

naveen_srini — Tue, 07 Apr 2015 09:54:42 GMT

Oh yes, That's true, I fully agree with you:)

Re: can i open sas7bdat file in sas eg 6.1

naveen_srini — Tue, 07 Apr 2015 09:43:27 GMT

Hi Good afternoon, Understanding that your EG is connected to the metadata server using your credentials and your dataset resides in the client desktop.I am using SAS EG 6.1 right now at office and I have just tried the same and it worked fine. How I did was, 1- Right click on the icon of the dataset 2. you will see open/open with SAS Enterprise guide 6.1 3 Clicking that should comfortably open. Well at least it did for me:)

Re: Retain + Looping among multiple row records

naveen_srini — Tue, 07 Apr 2015 04:44:50 GMT

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

Re: Null variable

naveen_srini — Mon, 06 Apr 2015 19:28:57 GMT

Same as Ballard, with the N function:

data want;

set have;

if n(of r1-r9) >=1;

run;

Re: Do Until Loop

naveen_srini — Sat, 04 Apr 2015 07:35:00 GMT

data have;

input repid date :mmddyy. positive;

format date yymmdd10.;

datalines;

125 1/12/2014 0

125 1/15/2014 1

1447 4/12/2013 0

1447 11/12/2013 0

1447 5/6/2014 0

1447 6/7/2014 0

1447 11/20/2014 1

1447 1/10/2015 0

1447 3/15/2015 0

88459 1/6/2014 0

454878 12/8/2014 0

316 2/9/2014 0

316 3/18/2014 0

316 6/2/2014 0

316 9/28/2014 1

316 12/1/2014 0

;

data want;

do _n_=1 by 1 until(last.repid);

set have;

by repid notsorted;

if positive then n=_n_;

end;

do _n_=1 by 1 until(last.repid);

set have;

by repid notsorted;

if _n_<=n or n=. then output;

end;

drop n;

run;

Regards,

Naveen Srinivasan

L&T Infotech

Re: How to check if the first and last date of ids are the same?

naveen_srini — Sat, 28 Mar 2015 12:27:55 GMT

I think your approach is right. You could do something like:

proc sort data=input_dataset out=splitone nouniquekey;

by service_date;

run;

proc sort data=input_dataset out=splittwo nodupkey;

by service_date;

run;

Please check the sort procedure documentation

APPC Functions detailed documentation help?

naveen_srini — Fri, 27 Mar 2015 20:15:07 GMT

Hi, I am in need of a Documentation that explains the use and applications of APPC functions with examples in great detail. I have found one apart from what's there in support.sas.com authored by Paul Dorfman, and if there is anymore you may have that you wouldn't mind sharing or can point me to a link, would be of great help. Thanks very much indeed.

Re: How to identify repeating characters in the string.

naveen_srini — Fri, 27 Mar 2015 16:45:45 GMT

Hi A small request and sorry it's off topic, I have noticed you using APPC functions extremely well as opposed many other major contributors. Can you please provide me a link documentation that explains pretty much well in detail for that one too? I'd appreciate it so much. Thanks.

Re: Help with getting Last Status Each month

naveen_srini — Fri, 27 Mar 2015 09:48:06 GMT

Not absolutely sure of your sample and your explanation, but just get started:
data have;

input id $ dt yymmdd10. status $;
format dt yymmdd10.;

cards;
1 20141203 D
1 20141210 D
1 20141210 A
1 20141210 S
2 20150104 A
2 20150115 D
2 20150118 S
2 20150118 D
2 20150118 A
3 20150210 S
3 20150213 D
3 20150223 D
3 20150223 S
;

data want;
do until(last.id);
set have;
by id;
end;

format dt monyy5.;
run;

Regards,

Naveen Srinivasan

L&T Infotech