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: 
CharlesC
‎12-14-2015
  • 14 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: Select records with count of id > 1

by SAS Employee in SAS Data Management
‎04-09-2014 10:02 PM
‎04-09-2014 10:02 PM
This should also work for you: select dr_lic_num1, count(*) from victimsummary group by dr_lic_num1 having count(*) > 1 ... View more

Re: Output second record

by Calcite | Level 5 in SAS Data Management
‎04-09-2014 07:36 PM
‎04-09-2014 07:36 PM
Thank you all very much! ... View more

Re: How to read a dataset for a value range and output the var name, o...

by Calcite | Level 5 in SAS Data Management
‎10-08-2013 06:46 PM
‎10-08-2013 06:46 PM
It worked, thank you very much.  I really like the way you set up the IF-THEN statement with the abs() to capture both the negative and positive values-- nicely done!! I appreciate your help! -Charles ... View more

Re: Supress all but one statistic in a PROC

by Jade | Level 19 in SAS Programming
‎10-03-2013 10:50 AM
‎10-03-2013 10:50 AM
Micelle's answer will (almost) always give you the table names, but the documentation also lists the ODS Table Names, along with required statements or options, under the Details tab. Steve Denham ... View more

Re: Input dataset path once in program, recall it many times

by Calcite | Level 5 in SAS Programming
‎09-30-2013 06:06 PM
‎09-30-2013 06:06 PM
Thank you very much!  Macros are still unfamiliar territory as we didn't really cover them in Base SAS Programming... I appreciate the help. ... View more

Re: How to search for text within a string with leading characters

by Opal | Level 21 in SAS Data Management
‎09-08-2013 06:24 PM
‎09-08-2013 06:24 PM
You could use pattern matching like this: data have; input Keyword :&$80. Impressions Clicks; datalines; [sale on gas grills]        10        2 "Gas grill sales"      0         0 green egg sale grills      420          336 ; data want; set have; beg = prxmatch('/^[\["]?\s*sale(s)?\b/io', Keyword)>0; mid = prxmatch('/\w+.*\b\bsale(s)?\b.*\w+/io',Keyword)>0; end = prxmatch('/\w+.*\bsale(s)?\s*["\]]?$/io',trim(Keyword))>0; run; proc print data=want noobs; run; Whatever solution you choose, it should be tested with more examples. PG ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎12-14-2015 03:28 PM
Quick links