Allaluiah Tracker

Re: Paste last value in by group to all other observations in the same group, repeat for each group

Allaluiah — Thu, 21 Feb 2019 15:49:50 GMT

Hello @apaez062 Looks like you are new on the forum. Welcome to SAS communities and I hope you enjoy learning and sharing knowledge with us. It looks like your question has been answered. If yes, can you mark the solution as answered and close the thread?

Re: how to generate sequence number in sql

Allaluiah — Tue, 22 Jan 2019 18:26:39 GMT

@thanikondharish For whatever reason, you don't seem to acknowledge answers or appreciate the solutions that is apparent having been noticed in many of your posts/questions. It's so strange and difficult to comprehend why anyone would lack that very basic courtesy to at least thank and value the time of the person who has responded.

I am absolutely certain many others have noticed the same and have let you know of this rather not pleasing demeanor. I truly believe such ethics doesn't have to be taught or spoon fed. If I am not wrong, @VDD had mentioned this too in another thread.

It's seriously disheartening to the ones who are ethical, be it who post questions or solutions.

Re: SCAN function with same delimiter repeated

Allaluiah — Sat, 19 Jan 2019 18:03:53 GMT

@r_behata Nice , but imho not so convenient as no need to compute pos which is derivative of call scan. Also, you'd have to drop the pos,len vars after. So all in all, interesting indeed but I don't think that's a convenient/needful alternative.

Re: Creating new variable from data in multiple variables

Allaluiah — Sun, 13 Jan 2019 21:48:40 GMT

@kk11 Hi, Would be more appropriate and courteous to mark novinosrin's solution as accepted than marking your own. Thanks!

Re: Calculate the difference of one variable between current year and last year.

Allaluiah — Wed, 09 Jan 2019 21:49:50 GMT

@ADou Can you acknowledge the answer by marking as accepted and close the thread?

Re: how to check if any particular values are exists or not in sas dataset column

Allaluiah — Tue, 18 Dec 2018 16:48:37 GMT

4 records only?

Why do you need SAS ?

Why do you need to automate ?

2 to 3 mins manual work will do plus that will help keep people stay employed 🙂

Re: Lag function

Allaluiah — Thu, 06 Dec 2018 14:20:41 GMT

"TN is the unique value"-- Are you sure? Your example has multiple TN transactions with TN having duplicate keys. And what is your expected output. Either your writing isn't clear or my comprehension is not.

@Sunnykapoor wrote:

Hi,

I am working on data which have several values and I have to compare them. I am trying to use Lag function but unable to get through. Below are the context of data:

MN TN EII ND

238552 40006248 1 1

316969 40006248 0 0

631788 40006248 1 0

660798 50098722 1 0

660007 50098722 0 0

661359 50098722 1 1

TN is the unique value and scenarios are:

1) we have to select TN with EII and ND as 1 and 1 only if TN with same number is followed by either EII and ND as 0 and 0 or EII and ND as 1 and 0.

2) No Duplicate entries for TN.

Please suggest

Re: How to convert several columns into one column

Allaluiah — Mon, 03 Dec 2018 14:25:09 GMT

@Kurt_Bremser That may look simple, but safer to user _numeric or _char_ . Also you would need to sort your want2 to actually meet OP's requirement stated in the question

Re: Conditional copy value

Allaluiah — Mon, 03 Dec 2018 03:23:02 GMT

What have you tried? Can you show your sincere attempt? I have noticed you haven't showed either in any of your threads and I think that's unfair

Re: Assign serial number to observations

Allaluiah — Mon, 03 Dec 2018 03:20:42 GMT

You are unnecessarily duplicating

https://communities.sas.com/t5/New-SAS-User/Split-dataset/m-p/517827#M3432

wonder why do you have to do that over and over

Re: Combining two numeric variables to make a Monyyyy Date?

Allaluiah — Wed, 07 Nov 2018 22:53:21 GMT

Hello @SuryaKiran You wrote-- "The log will show the notes because your are trying to concatenate numeric values, so SAS will automaticallly convert numeric values to character with best. format"

No, cat family of functions does not write any such auto conversion notes in the sas log.

And only the best way is to use MDY() function?

Wait until what the OP wants in his/her final result before assuming what is the best way although mdy is very straight forward, that I completely agree.

Nevertheless, we are not sure of OP's expected output-

should it revert to first of month, end or whatever, does that OP want a resulting character? OP needs to provide more info

Re: Converting currency to num displayed as a char

Allaluiah — Sat, 27 Oct 2018 14:45:03 GMT

@Q1983 Thank you for posting the $ currency question as I ran into this need just a few moments ago.

@Jagadishkatam Your alternative though looks nice by stripping chars and keeping digits, but is far slower than the straight forward offered one by @novinosrin

I just tested with about 20 million records and your solution exponentially gets slower as I increase the test with adding number of records. Could you offer something that is rather better to beat that ?

Re: Grouping dates

Allaluiah — Thu, 25 Oct 2018 17:43:22 GMT

Hello @sg_kr It's apparent having followed many of your posts you don't ever seem to mark the answers as accepted/solved. While arguably this is the best forum on earth and people share joy in writing sas programs than any of the acknowledgements they get, it is our responsibility to extend courtesy and goodwill.

I do appreciate all the questions however please offer the minimum courtesy. It's great to be human after all. Well well!!!!!!!!!

Re: replacing missing date values in a column with new date

Allaluiah — Mon, 22 Oct 2018 17:32:07 GMT

Hi @singhsahab Appreciate your effort and attempt. However, the code doesn't look very desirable from the point of view ease of use or even application of logic. From the start of typing to , testing and moving to production and then post production maintenance, I guess it's hard to envision implementing your code. I wonder how your code can be an alternative to the rest. Nevertheless, good contribution

Re: Concatnation of character and number into one variable

Allaluiah — Sat, 20 Oct 2018 21:20:53 GMT

@sgarg Mark the post as answered having acknowledged the help. That completes and closes it.

Re: Syntax check which has link statement

Allaluiah — Sat, 13 Oct 2018 15:11:39 GMT

If you honestly and sincerely wrote this code which one may agree considering your proc star status, nonetheless your question raises doubt whether you really wrote the code. On the other hand, supposing you did, what's the problem in checking syntax by yourself.

With reference to many of your previous questions, I'm afraid the legitimacy of your questions seem very doubtful

Re: How do I find and select the first non-missing variable in a group of variables

Allaluiah — Fri, 06 Jul 2018 11:11:37 GMT

@Amihic You could credit the help you received by marking their solution as accepted

Re: How to create the bar chart for my requirement using proc gchart?

Allaluiah — Mon, 18 Apr 2016 13:41:04 GMT

@BrunoMueller Very nice Sir, Thank you so much. That pretty much did it for me. It seems like you have loads of experience in SAS. How did you manage to read, understand and remember all these options. Is there a method or technique to learn SAS more effectively? I would welcome your suggestions plz

How to create the bar chart for my requirement using proc gchart?

Allaluiah — Sun, 17 Apr 2016 15:40:18 GMT

I have attached input dataset sample that has values for the bar chart and I have also attached the wanted barchart sample.

In the bar chart , I need find out from 2007 to 2010, how many times(frequency) GY1, GY2 and GY3 are ranked in each year (shown as numbers under bars on the graph attached). And within each year’s bars I’d also like to know what the proportions are respectively that GY1, GY2 and GY3 are ranked as 1^st, 2^nd and 3^rd (shown as percentages within each bars).

Re: Need SAS query help for date/month based processing?

Allaluiah — Wed, 03 Feb 2016 15:46:15 GMT

@Kurt_Bremser Sir, Thank you for you time and response. Yes, I agree it's not nice to duplicate questions but you have noticed the difference. I apologise that I duplicated it because i couldn't find the edit in my laptop screen for some weird reason. Forgive me for that.

Yep, you were right about the want values. Let me test your code and clarify my question clearly and sincerely and follow up with any doubts if i have. If you allow me, I will mark your answer as solution soon as I complete my testing bcoz I would like to take this chance to keep it open to have a follow up clarification with you. Thank you once again

MN	TN	EII	ND
238552	40006248	1	1
316969	40006248	0	0
631788	40006248	1	0
660798	50098722	1	0
660007	50098722	0	0
661359	50098722	1	1