About cheema11

cheema11 · ‎11-14-2022

Thanks @SASKiwi. Just one more query. I am getting below error while creating the macro variable. "The length of the value of the macro variable CUST_LIST (65540) exceeds the maximum length (65534). The value has been truncated to 65534 characters." any idea how to fix this? One way is to go by 1000 customers separately, any thing more efficient?

cheema11 · ‎11-14-2022

Hi All, I have 3,000 customers in SAS table and I want to fetch data from Oracle for those customers. there are billions of records in Oracle table. I am using Oracle Lib and joining sas data with it, but the solution is not efficient, takes ages to run. Please note that I don't have rights to create temp table in Oracle so cannot ingest 3,000 customers in oracle table. The sample code is libname SASTABLE libname ORATABLE proc sql; select A.* from oratable as a inner join sastable as b on a.cust_ID=b.cust_ID; quit;

cheema11 · ‎10-02-2022

Hi @Patrick. In response to your query...."What if a string in table A matches multiple substrings in table B?" My answer was "Return the one with longest string length in Table B. If string length is same, then return any one of them." What do i need to change in the script if I want to return the string with shortest length in Table B?

cheema11 · ‎09-29-2022

It works perfect. Thanks

cheema11 · ‎09-28-2022

I am trying to get a row based on ordered preference on list column. Preference is DCE_CMD, DCE_DA, DCE_New. Input Table - Master: Keyword List BINA DCE_CMD BINA DCE_DA BINA DCE_New ABC DCE_DA ABC DCE_New XYZ DCE_New IJK DCE_CMD Output: Keyword List BINA DCE_CMD ABC DCE_DA XYZ DCE_New IJK DCE_CMD data master; infile datalines truncover; input keyword $ list $; datalines; BINA DCE_CMD BINA DCE_DA BINA DCE_New ABC DCE_DA ABC DCE_New XYZ DCE_New IJK DCE_CMD ;

cheema11 · ‎09-26-2022

Thanks for the response on this. Really appreciate for the help. @PeterClemmensen @Patrick

cheema11 · ‎09-26-2022

Yes longest string from Table B

cheema11 · ‎09-26-2022

Return the one with longest string length. If string length is same, then return any one of them.

cheema11 · ‎09-26-2022

Yes both are sas data sets.

cheema11 · ‎09-26-2022

Hi All, New to SAS, need some help in string matching. I have Table A which have millions of records. Table B has less than 5K records. I want to match Address field of table A with Keywords field of table B. Currently doing Proc SQL with Like operation which is very slow and query takes ages. There is a cross join between both the tables. Both tables are in SAS. Wanted to know the efficient way of doing this. Using SAS EG V 8.2. It will be a great help. Thanks in advance.

Online Status	Offline
Date Last Visited	‎11-21-2022 01:54 AM

Re: Fetch Oracle Data by joining SAS table

Fetch Oracle Data by joining SAS table

Re: Match table A string with Table B keyword

Re: Select value from list based on ordered preference

Select value from list based on ordered preference

Re: Match table A string with Table B keyword

Re: Match table A string with Table B keyword

Re: Match table A string with Table B keyword

Re: Match table A string with Table B keyword

Match table A string with Table B keyword

Re: Fetch Oracle Data by joining SAS table

Fetch Oracle Data by joining SAS table

Re: Match table A string with Table B keyword

Re: Select value from list based on ordered preference

Select value from list based on ordered preference

Re: Match table A string with Table B keyword

Re: Match table A string with Table B keyword

Re: Match table A string with Table B keyword

Re: Match table A string with Table B keyword

Match table A string with Table B keyword