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: 
Jade_SAS
‎10-30-2021
  • 235 Posts
  • 38 Likes Given
  • 2 Solutions
  • 14 Likes Received

how to deal with Hash error "Hash object added 0 items when memory fai...

by Pyrite | Level 9 in SAS Data Management
‎09-06-2017 02:34 PM
‎09-06-2017 02:34 PM
Hi all,       I am running a do loop and got into this hash error, wonder how can I deal with this error. please note I'm runing with SAS EG on linux server. (SAS EG is on my laptop)     Detailed error info:     ERROR: Hash object added 0 items when memory failure occurred. FATAL: Insufficient memory to execute DATA step program. Aborted during the EXECUTION phase. ERROR: The SAS System stopped processing this step because of insufficient memory.   Possible solution I can think of: 1) Split big data set to small ones. I have total records about 3500000, it seems I need to split to at least 15 data sets. (I tested the small data set ran through the sas code successfully)   2) Increase the memory size? I ran the code Proc Options group=memory; run; and the results are as follows: Group=MEMORY SORTSIZE=1073741824 Specifies the amount of memory that is available to the SORT procedure. SUMSIZE=0 Specifies a limit on the amount of memory that is available for data summarization procedures when class variables are active. MAXMEMQUERY=268435456 For certain procedures, specifies the maximum amount of memory that can be allocated per request. LOADMEMSIZE=0 Specifies a suggested amount of memory that is needed for executable programs loaded by SAS. MEMSIZE=2147483648 Specifies the limit on the amount of virtual memory that can be used during a SAS session. REALMEMSIZE=0 Specifies the amount of real memory SAS can expect to allocate.   Please advise what I should do, any suggestion is welcome. Thank you! Jade                ... View more

Re: how to come up with a do loop in SAS in this special situation?

by Pyrite | Level 9 in SAS Data Management
‎09-06-2017 11:08 AM
‎09-06-2017 11:08 AM
Thank you for your input! ... View more

Re: how to come up with a do loop in SAS in this special situation?

by Pyrite | Level 9 in SAS Data Management
‎09-06-2017 11:07 AM
‎09-06-2017 11:07 AM
Thank you, I will test it. ... View more

Re: how to come up with a do loop in SAS in this special situation?

by Pyrite | Level 9 in SAS Data Management
‎09-05-2017 05:09 PM
‎09-05-2017 05:09 PM
Thank you for the qucik reply. From the coding, I seems to get the following results (see range_got):   Date    Status    Group_ID    Range (Want to get the value of this field)   Range_got     date1      0          A                    date2      0          A     date3      1          A                 date3-date1                                                date3-date2     date4      0          A     date5      1          A                 date5-date4                                                date5-date4     date6      1          A                                                                                     date6-date4     date7      1          A                                                                                     date7-date4     date8      1          B                                                                                     date8-date4     date9      1          B                                                                                     date9-date4     date10     0         B                                                                                         date11     0         B     date12     0         B     date13     1         B                date13-date10                                             date13-date12     date14     1         B                                                                                     date14-date12   ... View more

Re: how to come up with a do loop in SAS in this special situation?

by Pyrite | Level 9 in SAS Data Management
‎09-05-2017 04:57 PM
‎09-05-2017 04:57 PM
The groupID is a higher level than status. There is a lot of groups (A, B, C, D, E,F, etc. groups) in the data,  I forgot to mention in the post.   Within each group, there is status with 0 and 1. ... View more

how to come up with a do loop in SAS in this special situation?

by Pyrite | Level 9 in SAS Data Management
‎09-05-2017 03:45 PM
‎09-05-2017 03:45 PM
Hi All,       I have a dataset with column properties as the first three columns, I want to come up with a do loop to get the fourth column, whihc is range:       Date    Status    Group_ID    Range (Want to get the value of this field)     date1      0          A                    date2      0          A     date3      1          A                 date3-date1     date4      0          A     date5      1          A                 date5-date4     date6      1          A     date7      1          A     date8      1          B     date9      1          B     date10     0         B     date11     0         B     date12     0         B     date13     1         B                date13-date10     date14     1         B       .              .          .       .              .          .            Data can go on with this pattern.     In this data, date is sorted ascendingly. Could you please let me now how should O come up with do loop to get the column range?   Thank you! Amy comments are welcome!   Jade  ... View more

error when copying teradata in SAS

by Pyrite | Level 9 in SAS Data Management
‎08-23-2017 04:47 PM
‎08-23-2017 04:47 PM
Hi All,       I'm copying one table from Teradata to the same location and I get the error below:     LIBNAME TD TERADATA SERVER=*** DATABASE=***;   Data TD.test1; set TD.log; Run;   ERROR: Error attempting to CREATE a DBMS table. ERROR: Teradata execute: Length 0 is not allowed for a CHAR, VARCHAR, BYTE, VARBYTE column.. ERROR: ROLLBACK issued due to errors for data set TD.TEST1.DATA.     What's the possible reason for this? Thank you!   Jade   ... View more

Re: question about writting SAS data back to Teradata, why using TPT n...

by Pyrite | Level 9 in SAS Data Management
‎08-23-2017 01:39 PM
‎08-23-2017 01:39 PM
That's make sense. I did try big data set and it's faster with TPT. How can we dicide what size of data to use TPT or not? Is there a roughly size vable based on your experience? Thank you!   Jade ... View more

Re: how to use TPT in DS2 data step?

by Pyrite | Level 9 in SAS Data Management
‎08-23-2017 01:19 PM
‎08-23-2017 01:19 PM
Right, I feel the TPT is not compatible with PROC DS2. ... View more

Re: how to use TPT in DS2 data step?

by Pyrite | Level 9 in SAS Data Management
‎08-23-2017 09:16 AM
‎08-23-2017 09:16 AM
Thank you for the suggestion! Tried to add TPT in the libname statement, then try the coding again, unfortunately still get the same error ... View more

how to use TPT in DS2 data step?

by Pyrite | Level 9 in SAS Data Management
‎08-22-2017 05:20 PM
1 Like
‎08-22-2017 05:20 PM
1 Like
Hi All,       I got an error when using TPT in DS2 data step, the coding and error are below: proc ds2; data TD.TEST(TPT=YES FASTLOAD=YES TPT_MAX_SESSIONS=4); method run(); set test.data1; end; enddata; run; ERROR: Compilation error. ERROR: Syntax error or access violation TPT ERROR: Unable to execute CREATE TABLE statement for table TD.TEST.       I checked the same DS2 step works without TPT, see coding below: proc ds2; data TD.TEST1; method run(); set test.data1; end; enddata; run;        What's the correct syntax to apply TPT is DS2 step? Thank you!   Jade ... View more

Re: where can find Hand on forecast documentation

by Pyrite | Level 9 in SAS Forecasting and Econometrics
‎08-22-2017 04:54 PM
‎08-22-2017 04:54 PM
Alex, this is really helpful! Thank you! ... View more

Re: About delivering forecasting results to clients

by Pyrite | Level 9 in SAS Forecasting and Econometrics
‎08-22-2017 04:51 PM
‎08-22-2017 04:51 PM
Thank you both! ... View more

Where can I find forecast example data sets and books?

by Pyrite | Level 9 in SAS Forecasting and Econometrics
‎08-22-2017 12:59 PM
‎08-22-2017 12:59 PM
Hi All,       Where I can find hand on forecast documentations? I read the theorical booked recommended on this forum, right now want to do some practice work with example data sets. Any hand on documentation is welcome. Thank you!   Jade ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎10-30-2021 11:05 PM
Likes given to
Likes from
Quick links