Can you please give a bit more context on where the job is running, since when you're seeing this problem?   Thanks, Audrey ... View more

Hi Audrey,   This worked really nicely, thanks very much!   -Atte ... View more

hi Audrey,   I have the same problem in a sort and/or clustering node. We tried to change the path of base/temp library to an other with more disk space but no change.How can we change the space allocation for this temp library (on the server and in local) ?   Thanks ... View more

Start by checking your wait stats Ensure your TempDB database is configured optimally. Make sure you're running index maintenance frequently. Implement indexes that provide a benefit to your queries. Check your most expensive queries and stored procedures. Monitor your performance counters. Regards, Rachel Gomez ... View more

Perform the following steps to create a new DBMS-based repository for DataFlux Data Management Studio. Click on the Administration riser bar. Select the Repository Definitions folder in the tree. The Repository Definitions pane displays on the right. In the Repository Definitions pane, click on the New button to create the new repository. The New Repository Definition dialog appears Enter the name of your repository in the Name field. Select the Database connection control. Use the connection Name field to select an ODBC DSN connection or a SAS Federation Server connection to the database where the tables for the repository are created. Example database connection name: Oracle11g Specify a table prefix, if desired. A unique table prefix enables you to distinguish the tables that are associated with a particular repository from other tables that might be stored in the same database connection. If you enter a prefix that includes a period, the portion to the left of the period will be considered to be the name of an existing schema. For example, you specify WIP.REPOS as a prefix, the repository creation will fail if there is no WIP schema in the database. Specify a File storage location. The client might perform best when the File storage location is local to DataFlux Data Management Studio. Example file storage folder: C:\prod_repos\FileStorage Select or deselect the Connect to repository at startup checkbox as appropriate. Select or deselect the Private checkbox as appropriate. Click on the OK button. A new repository definition file (.RCF file) is created. It is saved to the location specified by the selection or deselection of the Private checkbox. A new repository database is created in the location that is specified in the Data storage area of the definition. You are connected to the new repository. To verify that you are connected to the repository, select the repository in the Administration riser bar. The Status pane should indicate that you are connected to the repository. Regards, Rachel Gomez ... View more

Step are given below- Select and upload your TXT document for splitting. Specify desired page numbers and click Split Now button. Once your TXT document is splitted click on Download Now button. Use Email button to send download link over email. Regards, Rachel Gomez ... View more

Your shown code does not have anything that would generate that particular message. So that would related to previous code submitted. If something was not properly closed like unbalanced quotes then the log typically only shows the code but nothing executes depending on the exact issue that caused the problem. Often the "fix" is to 1) save your code and 2) shut down SAS and restart. Regards, Rachel Gomez ... View more

First you need to add match codes to your database lookup table (the one that the SQL Lookup node references). Create name match codes and insert them into this table. Then when you are testing with the external data provider node, add a match code node for the name (using the same definition and sensitivity as you used in appending match codes to your lookup table.). When you are testing perform the SQL lookup on the match codes and not on the exact names and the following results will return Mike = Michael; MIKE = Michael; mike = MICHAEL. Regards, Rachel Gomez ... View more

ataFlux software and SAS data sets support different data types. Accordingly, automatic data-type conversions will take place when Data Management Studio software reads or writes SAS data sets. Also, nulls and missing values will be converted to other values. These changes can impact features that depend on particular data types. For example, when a profile reads a SAS data set, SAS fields with a format that applies to datetime values will be reported as datetime. SAS fields with a format that applies to time values will be reported as a time and SAS fields with a format that applies to date values will be reported as a date. As a result, the profile will not calculate some metrics such as Blank Count or Maximum Length for those fields. The following data-type conversions are made automatically when DataFlux software, such as a data job or a profile, reads SAS data. For jobs: SAS numeric columns with a format that applies to date, time or datetime values will be converted to a DataFlux field of type date. For profiles: SAS fields with a format that applies to datetime values will be reported as datetime. SAS fields with a format that applies to time values will be reported as a time and SAS fields with a format that applies to date values will be reported as a date. Other SAS numeric columns will be converted to a DataFlux field of type real. SAS character columns will be converted to a DataFlux field of type string with the same length as the SAS character column. Nulls and missing values will be converted to other values, as follows. SAS missing values will be converted to DataFlux null values. SAS special numeric missing values, whether they are specified with the MISSING statement in a SAS DATA step or with a dot followed by a letter or underscore, are also converted to null values. DataFlux null values will be converted to SAS missing values. A DataFlux field of type string that contains a blank will be converted to a SAS character field containing a blank. This blank will be interpreted by SAS as a missing value.   Regards, Rachel Gomez ... View more

If your system doesn't have Storage Sense, you can use the Disk Cleanup tool to delete temporary files and system files from your device. In the search box on the taskbar, type disk cleanup, then select it from the results. Select the drive you want to clean up files for, then select OK. Regards, Rachel Gomez ... View more

Hi,   Have you tried to use the Surviving Record Identification node? It's meant to keep only one record per cluster, based on some conditions.    Hope this helps. ... View more

You might also want to check the disk space that is available during the job run. Especially when you're near of the usual error point.  ... View more

Hi,   There are no definition in the QKB to match and cluster records by age. Also, I thought about your use case and I think it's not a good  solution. Let me explain what could happen: -> customer A is 20 and matches customer B who is 25, -> but customer C is 30, and therefore matches customer B, -> and, customer D is 35 and therefore matches customer C.   In the end, A matches D, and you'll end up one big cluster with all of your records.   So I think age should not be used this way. Maybe there are other criteria in your data that would be better.   Hope this helps. Audrey     ... View more

Hi,   In the Properties of your Work Table Reader, make sure you have added your new column. Then, in the Data Job that contains it, go to the Inputs tab, open the Source Binding for your Work Table Reader and go to the Column Mappings table.   Take a look at the example below, and let me know if this helps         Thanks, Audrey ... View more

Hello Audrey,   Good day!   I am really tankful to you for this. i wanted to directly write to you however i couldn't or i didn't find option to write you directly. thanks for your help and it worked for me. Thanks Dheeraj   ... View more