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: 
BL_463_IDR
‎12-21-2021
  • 7 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: Export to .mdb or .accdb error

by Calcite | Level 5 in SAS Academy for Data Science
‎12-19-2021 08:38 AM
‎12-19-2021 08:38 AM
it was an exisiting accdb file name.  I created a new accdb filename as you suggested, and it was worked, but it couldn't run for the second time coz the same error.  ... View more

Export to .mdb or .accdb error

by Calcite | Level 5 in SAS Academy for Data Science
‎12-15-2021 01:20 AM
‎12-15-2021 01:20 AM
Dear All,  I want to export dataset (.bdat) to ".accdb", but the SAS System Stopped Processing the step. i used this step to export the dataset: PROC EXPORT DATA= ccmart.appcard_20202021_datamart OUTTABLE= "Sheet1" DBMS=ACCESSCS REPLACE; DATABASE="C:\SAS_TEMP\CARD_TEMP\DATAMART_TEMP\appcard_20202021_datamart.accdb"; RUN; when i run the export step, the system stop processing because this error below; ERROR: CLI execute error: [Microsoft][ODBC Microsoft Access Driver] Cannot open database '|'. It may not be a database that your application recognizes, or the file may be corrupt. WARNING: File deletion failed for _IMEX_.Sheet1.DATA. ERROR: Export unsuccessful. See SAS Log for details. NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE EXPORT used (Total process time): real time 7:12.00 cpu time 10.29 seconds Note: i run this step daily, but today the error show up. (The file that succeed to export, has size > 2 gigabytes) for further information  - SAS 9.4 - size of dataset that i want to export is 515 megabytes - Office 365       ... View more

Re: Automate query filter by date

by Calcite | Level 5 in SAS Academy for Data Science
‎12-09-2021 03:50 AM
‎12-09-2021 03:50 AM
Dear Page Miller Thank you for your solution, i used this and it's works as expected. %nrstr(%')&date%nrstr(%%)%nrstr(%') i'm sorry for didn't provide additional information for the case, next ill fix it and explain more clear.  Once again, thanks for your solution.  Best Regards ... View more

Re: Automate query filter by date

by Calcite | Level 5 in SAS Academy for Data Science
‎12-07-2021 12:13 PM
‎12-07-2021 12:13 PM
i tried using macro like below:   %let date = %SYSFUNC(today(), year4.);  /*if current date is 07-12-2021, i want to take the year so the result that i expected is 2021*/   proc sql; connect to oracle (USER="xxxx" PASSWORD="xxxxx" PATH="(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = xxxx) (PORT = xxxx)))(CONNECT_DATA =(SID = xxxx )))"); create table newccv2.card_0 (COMPRESS=YES) as select * from connection to oracle ( select distinct * from BMDM_COMM.CREDIT_CARD_ACCOUNT where OPENING_DATEKEY like '&date.%'     /* when the macro (%let date) from above, i expected where OPENING_DATEKEY like '2021%*/ ); QUIT;   but it didnt' work, is there another way?           ... View more

Automate query filter by date

by Calcite | Level 5 in SAS Academy for Data Science
‎12-06-2021 02:59 AM
‎12-06-2021 02:59 AM
Hello,  i want to automate query by date, based on current year (date system on pc/laptop). For information the value of date (OPENING_DATEKEY) that i want to filter is '20210101' (text/string).   for example, the filter date that i currently query like below  :   proc sql; connect to oracle (USER="xxxx" PASSWORD="xxxxx" PATH="(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = xxxx) (PORT = xxxx)))(CONNECT_DATA =(SID = xxxx )))"); create table newccv2.card_0 (COMPRESS=YES) as select * from connection to oracle ( select distinct * from BMDM_COMM.CREDIT_CARD_ACCOUNT where OPENING_DATEKEY like '2021%' ); QUIT; thanks for your attention.  ... View more

Re: Query values accross table and column name

by Calcite | Level 5 in SAS Programming
‎11-23-2021 03:08 AM
‎11-23-2021 03:08 AM
i want to get the values from accross the table_name and column_name ... View more

Query values accross table and column name

by Calcite | Level 5 in SAS Programming
‎11-21-2021 10:05 PM
‎11-21-2021 10:05 PM
Dear All I'm trying to find/search values from across tables or columns name based on value name that i want to search. So far, i could search and show the tables or columns by table or column name.  This is my script that i used to search and show the tables or columns by table or column name: PROC SQL; CONNECT TO ORACLE (USER="xxxx" PASSWORD="xxxx"     PATH="(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = xxx)        (HOST = xxxxxxx) (PORT = xxxxx)))(CONNECT_DATA =(xxx = xxxx )))"); CREATE TABLE CEK.CEK_DWH_COLUMN (COMPRESS=YES) AS SELECT * FROM CONNECTION TO ORACLE ( SELECT owner, table_name, column_name FROM all_tab_columns WHERE column_name LIKE '%PRODUCT%'); QUIT;   From that query, the result in .bdat like example below: OWNER | TABLE_NAME | COLUMN_NAME DWH        PROUDUCT       PROGRAM DWH        PROUDUCT       SRRKID etc...   the result that i want, are like this below: OWNER | TABLE_NAME | COLUMN_NAME | VALUES_NAME DWH        PROUDUCT       PROGRAM            TITANIUM DWH        PROUDUCT       SRRKID                  32102 etc...   Can anyone help me, how to find/search values from across tables or columns name based on values name?, thanks for your attention. Regards    ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎12-21-2021 02:09 AM
Quick links