About Andygray

Andygray · ‎03-01-2019

@RW9 You are hardcoding the datastep to get all groups as opposed to @novinosrin solution that cleverly chooses the distinct group*distinct id in the subquery making it fully dynamic.

Andygray · ‎02-25-2019

Hi @Jagadishkatam Appreciate your enthusiasm, however for this case(OP's requirement) I don't think PRX is an alternative. It is awfully slow when I tested with 40 million records. However, I like your thinking. PRX is better utilized for complex patterns as opposed to straight forward use of SAS functions such as this case. Nonetheless, thank you for your contribution

Andygray · ‎02-13-2019

@novinosrin There's some secret to sharpness in the way your brain operates. 🙂 Classic!

Andygray · ‎02-12-2019

I tested your code with a very very large dataset at my insurance company where we deal with humongous amounts of data and it's much slower than the array based solution I am afraid.

Andygray · ‎02-12-2019

I wonder how that's efficient if OP's stated objective is efficiency?

Andygray · ‎02-06-2019

Hello @mdoddala Acknowledge @novinosrin 's answer by marking the answer as accepted though I don't think somebody who is prolific with super user status cares for credits. But that's ethic. That was a sharp catch.

Andygray · ‎01-22-2019

I totally concur with @Kurt_Bremser , @PeterClemmensen . Why? why? and why? what is that you are going to achieve? Whomsoever gave you that idea sounds like somebody who doesn't know SAS programming at all

Andygray · ‎01-19-2019

Hi @sidpesar Can you attach your input file or something that is transferable rather than pics? And of course, explain the requirement aka business logic

Andygray · ‎01-03-2019

Hello @cjacobson45 You marked my comment as the solution. lol Please mark the appropriate solution.

Andygray · ‎01-02-2019

Hello @cjacobson45 Looks like your question has been answered. If so, plz mark the solution as accepted and close the thread

Andygray · ‎12-18-2018

@MB_Analyst Can you please elaborate the logic to make us understand better?

Andygray · ‎12-05-2018

Hi @art297 Fair enough. Now, I believe you 🙂 Thank you!

Andygray · ‎12-04-2018

@art297 Are you sure? I don't think public use of commercial emails existed in the 80's let alone commercial portals that offered email service like msn etc and in general internet for the most part. Were you communicating by hand written posts and sending regular mails(not emails) using postal service?

Andygray · ‎11-17-2018

@Aliya-begum If the questions has been answered, you could mark as answered choosing one of the given solutions that you prefer.

Andygray · ‎11-08-2018

+ I personally have noticed besides the address of "hi guys", you lack etiquette in terms of not acknowledging answers, not marking them, very biased responses in several other threads and beyond. It gives the impression, getting answer is some kinda right than a humble privilege. Although it's my opinion, I'm entitled to it and I care the least whomsoever disagrees.

Online Status	Offline
Date Last Visited	‎03-29-2019 08:23 PM

Re: Return count of 0 in a Group By SQL Statement

Re: taking out dashes from ID

Re: Custom Date Format

Re: Use value of one variable to directly refer another variable

Re: Use value of one variable to directly refer another variable

Re: Need help with the sas code for specifying all numerical variables

Re: how to generate sequence number in sql

Re: data step read calculated value of row in next row

Re: Merging to files

Re: Merging to files

Re: Update

Re: Grouping dates

Re: Substract date variable which is in character

Re: AND OR NOT expressions logical way of writing correction please?

Re: SAS Interview problems

Re: Need help with the sas code for specifying all numerical variables

Re: Merging to files

Re: i am new to sas i have a data set with 5 variables i need the outp...

Re: Data Transformation SAS Help: from Rows to Columns

Please explain DSD and DLM=',' differences?

Re: Return count of 0 in a Group By SQL Statement

Re: taking out dashes from ID

Re: Custom Date Format

Re: Use value of one variable to directly refer another variable

Re: Use value of one variable to directly refer another variable

Re: Need help with the sas code for specifying all numerical variables

Re: how to generate sequence number in sql

Re: data step read calculated value of row in next row

Re: Merging to files

Re: Merging to files

Re: Merge observations based on age being less than or equal to

Re: When was SAS communities launched?

Re: When was SAS communities launched?

Re: i am new to sas i have a data set with 5 variables i need the outp...

Re: select minimum value and corresponding amount in proc sql