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: 
Sulthan
‎02-19-2017
  • 10 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: Table Loader slow when updating SAS physical data set

by Calcite | Level 5 in SAS Data Management
‎02-14-2017 10:15 PM
‎02-14-2017 10:15 PM
data _null_; set sqlref.SBR_PNR_DATAELEMENTS; run;   I tried the below , but it was taking longer time to respond , but the same table using extract transformation have completed in 0.18s ... View more

Re: TABLELOADER SLOWNESS WHILE UPLOADING DATA TO SAS PHYSICAL DATASET

by Calcite | Level 5 in SAS Data Management
‎02-08-2017 02:42 AM
‎02-08-2017 02:42 AM
Yes its very slow, but this was not happened few weeks back. ... View more

Re: TABLELOADER SLOWNESS WHILE UPLOADING DATA TO SAS PHYSICAL DATASET

by Calcite | Level 5 in SAS Data Management
‎02-06-2017 09:30 PM
‎02-06-2017 09:30 PM
I have loaded 1000 obs it was loading fast and i am sharing the log so that can find anything. ... View more

Re: TABLELOADER SLOWNESS WHILE UPLOADING DATA TO SAS PHYSICAL DATASET

by Calcite | Level 5 in SAS Data Management
‎02-06-2017 09:01 PM
‎02-06-2017 09:01 PM
Yes we are using TableLoader transformation from SAS DI studio, Registered the SAS table in BASE SAS libref, Tried after by defining index(Still no use) Source data is an extraction from MSSQL tables. The speed of transfer as far tested is 3mb/10min ... View more

Table Loader slow when updating SAS physical data set

by Calcite | Level 5 in SAS Data Management
‎02-05-2017 10:46 PM
‎02-05-2017 10:46 PM
Dear All,   When trying to upload a data to sas physical dataset via TABLELOADER we are facing very slow in writing the data to the final dataset , for ex . bytes per minutes of data getting written to the dataset LOADTECHNIQUE used is REPLACE  NEWROWS IS append(proc(append))   We have increased the tmp memory to 250 GB, anyone have faced the same ? ... View more

Re: Date imported as character in SAS from MSSQL table instead of defa...

by Calcite | Level 5 in SAS Data Management
‎02-01-2017 02:14 AM
‎02-01-2017 02:14 AM
I have mentioned the DBSASTYPE while importing via DI ,but still i am seeing date as character   ... View more

Re: Date imported as character in SAS from MSSQL table instead of defa...

by Calcite | Level 5 in SAS Data Management
‎02-01-2017 01:45 AM
‎02-01-2017 01:45 AM
We havent used those steps , and aware not where to mention them whether while assigning the libname ? or how  ... View more

Re: Date imported as character in SAS from MSSQL table instead of defa...

by Calcite | Level 5 in SAS Data Management
‎01-31-2017 10:48 PM
‎01-31-2017 10:48 PM
Hi User,   Thanks for the quick response on my query, Yes we are using ODBC behind the scene we have our driver installed on the below path,   /usr/SAS/ODBC   I dont know how to check for the latest version on my ODBC ... View more

Re: Date imported as character in SAS from MSSQL table instead of defa...

by Calcite | Level 5 in SAS Data Management
‎01-31-2017 10:43 PM
‎01-31-2017 10:43 PM
HI Reeza,   IN MSSQL the type format is DATE, We have faced the same for DATETIME2 formats imported as character but upon changing DATETIME2 to DATETIME we could import correctly to NUMERIC but for DATE we couldnt define anyother datatype apart from DATE ... View more

Date imported as character in SAS from MSSQL table instead of default ...

by Calcite | Level 5 in SAS Data Management
‎01-31-2017 09:49 PM
‎01-31-2017 09:49 PM
Dear All,   Recently we have installed SAS ACCESS LICENSE to MSSQL  in our production environtment , connection established sucessfull, and while importing table from DB we are receiving DATE datatype as character instead of NUMERIC.   Please suggest why its happening. ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎02-19-2017 11:25 PM
Quick links