Hey this helped me a lot! Very clearly explained thanks a lot!
@learnerea
3 жыл бұрын
Glad you liked it
@shankarsakthi9683
2 жыл бұрын
Keep upload more videos sir thank you
@learnerea
2 жыл бұрын
Keep watching
@eringao6817
Жыл бұрын
Thank you for the lecture, very well explained. I have two questions on this subject and looking for an answer, could you please help? Thanks! really appreciated. 1) Which perl regular expression can represent 5MQ, 5:MQ, 8MQ, or 8:MQ prxmatch('', x) 2)Which perl regular expression can replace MOUSE with RAT in prxmatch? the choice are '\s\MOUSE\RAT', '\s\RAT\MOUSE', ' \MOUSE\RAT', ' \RAT\MOUSE'
@shreyanshsrivastava1954
3 жыл бұрын
if we have any special characters like , @ ! then which expression should we use.
@learnerea
3 жыл бұрын
It depends what exactly you want, for example if you just want to look for strings which contains any of these characters you can simply put these characters between "/ /" as explained in the video e.g. prxmatch("/@/",text); it will be great if you can be more specific and provide an example along with problem statement
@ganeshreddytammineni9059
11 ай бұрын
Is there any other function similar to prxmatch. I have a condition like want extract dates present in the variable label
@learnerea
11 ай бұрын
Yes that can be solved. Can you elaborate your problem statement a bit more.. i.e. how does your input look like and what kind of output you are expecting.. and in what conext you are using this.. it will help us give you a more specific solution
@gunjanbhasin5546
3 жыл бұрын
How do I retrieve a substrings from a string using delimiters . Example : memoline cust 266 / 0, memoline cust 266 / 123 , memoline cust266 / 0.00 and I wanna filter out all data with 0 or 0.00 after / .. stuck help pls
@learnerea
3 жыл бұрын
Please find below: data testing; input variables $25.; datalines; memoline cust 266 / 0 memoline cust 266 / 123 memoline cust266 / 0.00 ; run; data test; set testing; where compress(variables) like '%/0%'; run;
@gunjanbhasin5546
3 жыл бұрын
@@learnerea thankyou will try that
@deepakkumaar9665
3 жыл бұрын
@@learnerea thanks sir
@aperxmim
Жыл бұрын
transaction data missing from your site
@learnerea
Жыл бұрын
my sincere apologies for that... however, you can try this technique on any sort of data... and it's more beneficial if you try to perform the taught technique on your choice of data and see if that works as expected or not.. you can download any other excel file from the given link and can try.. happy to help any further
@laicythomas7380
3 жыл бұрын
Hi could you please show how to convert from one delimeter to another
@learnerea
3 жыл бұрын
Hi Laicy, To make it more clear, could you pleas put an example of your problem statement here, like what you have and how you want that to be converted
@laicythomas7380
3 жыл бұрын
@@learnerea For example I have one basic dataset, in that default delimeter will be comma, how do I convert that to star? Is there any direct method?
@learnerea
3 жыл бұрын
@@laicythomas7380 Yes, I assume that the value is not some currency value which are separated by commas and it's character value then you can use TRANWRD function to directly replace whatever you want, for example, Try to use the below: name = tranwrd('Laicy, Thomas', ',' ,'*') for more clarity I recommend you to check out the video: kzitem.info/news/bejne/2aWA0616a6Fzf5w let me know if this answers you question or not
@laicythomas7380
3 жыл бұрын
@@learnerea Okay, Thank you so much. I got it now.
Пікірлер: 36