cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Suzy_Cat
‎09-22-2021
  • 126 Posts
  • 123 Likes Given
  • 0 Solutions
  • 15 Likes Received

Re: Perl regular expression

by Pyrite | Level 9 in SAS Programming
‎03-01-2020 09:42 PM
‎03-01-2020 09:42 PM
Even better! Noted down the formula for future usage. ... View more

Re: Perl regular expression

by Pyrite | Level 9 in SAS Programming
‎03-01-2020 09:25 PM
‎03-01-2020 09:25 PM
@novinosrin, That is exactly what i wanted! Thanks heaps for the help out 🙂 ... View more

Re: Perl regular expression

by Pyrite | Level 9 in SAS Programming
‎03-01-2020 09:13 PM
‎03-01-2020 09:13 PM
Thank you Chris,   Your suggestion is exactly what I was after... 🙂 ... View more

Re: Perl regular expression

by Pyrite | Level 9 in SAS Programming
‎03-01-2020 09:07 PM
‎03-01-2020 09:07 PM
whoops my bad, accidently put / instead of | between, no wonder it was not working earlier...     Check=prxmatch("/GOL|G.O.L/G O L/", words);     also there is an extra : when i tested earlier   data have; input ID:$1. Words :$50.; datalines;   A Googled B G.O.L C GOL D "G O L" ; run;     ... View more

Perl regular expression

by Pyrite | Level 9 in SAS Programming
‎03-01-2020 08:55 PM
‎03-01-2020 08:55 PM
Hi there,   Any one can help me on Perl regular expression:   Example:   data have; input ID:$1. Words :$50.; datalines;   A Googled B G.O.L C GOL D "G O L" ; run; data test; set have; Check=prxmatch("/GOL|G.O.L|G O L/", words); run;   The result I need is B,C,D but not A by using prxmatch   Thanks for help 🙂     ... View more

calculate distance between two nz addresses

by Pyrite | Level 9 in SAS Programming
‎02-17-2020 08:33 PM
‎02-17-2020 08:33 PM
Hello,   Can anyone share their experience in calculating distance between two nz addresses?   I had a quick browse and have no clue how to set up/access API.   Sad that SASHELP.ZIPCODE has no such info for New Zealand.   Would be great to get the practical idea on how to actually using SAS to calculate the distance/travel time required between two address vars.   Thanks   ... View more

Re: Rename column names in reversed order for suffix in the column na...

by Pyrite | Level 9 in SAS Programming
‎02-12-2020 10:27 PM
‎02-12-2020 10:27 PM
Cool . Nice and easy. Thank you Tom! ... View more

Rename column names in reversed order for suffix in the column names

by Pyrite | Level 9 in SAS Programming
‎02-12-2020 09:05 PM
‎02-12-2020 09:05 PM
Hi there,   Can anyone help me out to change the column names with suffix by  digit number in ascending order to descending order?   data have; input a_1 $ b_2 $ c_3 $ d_4 e_5; cards;   a . a 1 3 . b . 2 4 a a a . 5 . . b 3 5 a a a . 6 a a a . 7 a a a 2 8 ; run; data want; input a_5 $ b_4 $ c_3 $ d_2 e_1; cards;   a . a 1 3 . b . 2 4 a a a . 5 . . b 3 5 a a a . 6 a a a . 7 a a a 2 8 ; run;     Thanks in advance 🙂   Suzy ... View more

Re: Count occurrances of a variable's value

by Pyrite | Level 9 in SAS Programming
‎02-05-2020 06:53 PM
‎02-05-2020 06:53 PM
all works! ... View more

Re: Count occurrances of a variable's value

by Pyrite | Level 9 in SAS Programming
‎02-05-2020 06:53 PM
‎02-05-2020 06:53 PM
Amazing!! Thank you guys for the great help. The alternative methods helps me to learn. :):) ... View more

Re: Count occurrances of a variable's value

by Pyrite | Level 9 in SAS Programming
‎02-02-2020 02:20 AM
‎02-02-2020 02:20 AM
hi unison, that is super. it is exactly what I need to achieve! ... View more

Count occurrances of a variable's value

by Pyrite | Level 9 in SAS Programming
‎02-02-2020 01:46 AM
‎02-02-2020 01:46 AM
hi all; may you please assist. I have a dataset where the client column can have multiple clients. I need count the occurrences of the clients showing in the data.    Below is the example of dataset: Count is the data column needed here, ie, Client A appeared 4 times in the data while B showed 5 times.   Client Count A   B   A,B   B,A   A,B,C   B   C   D     data wanted: Client Count A 4 B 5 C 2 D 1     thanks ahead of time for your assistance. ... View more

Re: Parsing CSV data with Alt-Enter separators within one cell

by Pyrite | Level 9 in SAS Data Management
‎01-30-2020 11:31 PM
‎01-30-2020 11:31 PM
Thank you @Tom, the code works perfectly with what I want to achieve. Your suggestion help with alternative ways to get the same result. Appreciated for your time:) ... View more

Re: Parsing CSV data with Alt-Enter separators within one cell

by Pyrite | Level 9 in SAS Data Management
‎01-30-2020 04:42 AM
‎01-30-2020 04:42 AM
@Ksharp Thank you for your input here. It really helped and resolved my issue with data export to CSV.   Here is my code which works perfectly to my problem: data have; id=1; comment=catx('0D0A'x,'sa as','sdf   sd','xcxd','v dfew');output; id=2; comment=catx('0D0A'x,'w we','ghf','bv d','azx');output; run;   data want; set have; * Count number of lines in a cell; Cnt=countw(comment,'0D0A'x); * Remove line breaks; comment_new=compress(comment,'0D0A'X); * Remove extra space and connect text in different lines by semicolon; comment_new1=compbl(translate(comment,';','0D0A'X)); run;     ... View more

Re: syscc & syserr: How to get a list of errors and warnings after a p...

by Pyrite | Level 9 in SAS Programming
‎01-15-2020 09:49 PM
‎01-15-2020 09:49 PM
Found some useful link, need time to work on and test if it serves the purpose: https://communities.sas.com/t5/ODS-and-Base-Reporting/Extract-Errors-and-Warnings-from-log/td-p/295839 Paper 1173-2017 Check Please: An Automated Approach to Log Checking Richann Watson, Experis https://support.sas.com/resources/papers/proceedings17/1173-2017.pdf ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎09-22-2021 10:16 AM
  • Contact User via MSN
  • Contact User via AIM
  • Contact User via Skype
Likes given to
Likes from
Quick links