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: 
Suzanne099
‎09-01-2015
  • 4 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Finding non-exact matches in one dataset

by Calcite | Level 5 in SAS Procedures
‎08-09-2012 12:43 PM
‎08-09-2012 12:43 PM
Hello Everyone, I am trying to find non-exact matches within the same dataset.   For example, Susan Smith and Sue Smith, would be a match, etc.    I have a unique ID variable for every observation, and I want to keep that and create a list of potential matches.   Does anyone have any ideas? Thank you. ... View more

Insufficient Space Question

by Calcite | Level 5 in SAS Enterprise Guide
‎03-24-2012 04:26 PM
‎03-24-2012 04:26 PM
I tried to manually change the work location, using the above  directions, but I have SAS 9.3, and would not locate the appropriate folder.   I than tried to change the work location using a libname statement. libname work 'X:\SASTEMP'; In the log it stated that the SAS Library work could not be reassigned.   Does anyone know why or a way around this? ... View more

Insufficient Space Question

by Calcite | Level 5 in SAS Enterprise Guide
‎03-24-2012 02:30 PM
‎03-24-2012 02:30 PM
See log below.   I am running out of space within the work library.   Is there a way to change the default work library to a different drive with more memory? I found this comment regarding a similar issue, but I was not sure if this would work for my issues: If SAS is installed on your pc go to the installation folder (c:\program files\sas\sas 9.1) and open the file "sasv9.cfg". Find the line starting with -WORK and edit it. EXCERPT FROM LOG 1356       proc sql ; 1357       create table service_codes_sum (index = (key = (bene_id claim_no_grp claim_number )) 1357     !  ) as 1358       select 1359         bene_id, from_dt, claim_no_grp, claim_number, file_type, 1360         code_type, code_loc, code_value, poa_value, mdfr_cd1, mdfr_cd2, rev_cntr, apcpps, 1360     ! code_pckgind, 1361         sum(code_amt) as code_amt, 1362         sum(code_units) as code_units 1363       from 1364         service_codes 1365       group by 1366         bene_id, from_dt, claim_no_grp, claim_number, file_type, 1367         code_type, code_loc, code_value, poa_value, mdfr_cd1, mdfr_cd2, rev_cntr, apcpps, 1367     ! code_pckgind  ; ERROR: Insufficient space in file WORK.'SASTMP-000000102'n.UTILITY. ERROR: File WORK.'SASTMP-000000102'n.UTILITY is damaged. I/O processing did not complete. NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements. 1368       quit ; NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE SQL used (Total process time):       real time           2:20:53.07       cpu time            28:33.98 ... View more

Re: UTILITY failed

by Calcite | Level 5 in SAS Enterprise Guide
‎03-24-2012 01:59 PM
‎03-24-2012 01:59 PM
By updating this, all the utility processing would be done in the new directory, correct?  Therefore, as long as you have sufficient memory in the new work directory, you would not run into insufficient memory errors? Is there a way to make sure SAS is using the updated work library when first running your program?   The issue is the program I ran took over 6 hours, and the error occurred at the very end.  I want to make sure SAS is using the new work library for utility processing before I re-run the program. ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎09-01-2015 07:11 AM
Quick links