About Smile1

Smile1 · ‎11-11-2021

Hi Kurf, Yes. I agree with you. I will try to drop unnecessary columns from my dataset.

Smile1 · ‎11-07-2021

Hi Kurt, Thank you for your response. Now, I'm not sure whether it is possible to spread WORK across locations or not. I'm trying to sort out data that doesn't have stock information and to join again, FYI. Thank you for your suggestion. I will post my code and log here if something is wrong.

Smile1 · ‎11-07-2021

Hi Chris, Thank you for your information. Now, I'm not sure whether it is possible to spread WORK across locations or not. I'm trying to sort out data that doesn't have stock information and to join again, FYI.

Smile1 · ‎10-29-2021

Thank you for your response, ballardw. No, I am not experimenting with macros and creating sets inside %do /%end loops. I downloaded data sets from WRDS (Dealscan and S34 13F) and the size of each data set is about 210,000 x 15 and 33,000,000 x 26. I tried to join these two data set. That's why a terabyte of disk space is filled up. Maybe, I have to re-consider if I can further reduce the size of my data set or not...

Smile1 · ‎10-29-2021

Thank you for your information, Pagie. I want to use D and C drive at the same time, rather than use either D or C drive randomly, though. Maybe, I have to consider if I can reduce the size of my data set or not...

Smile1 · ‎10-28-2021

Hi~ all, I have 1TB D drive. So, I located my SAS work library on D drive. However, I found that 1TB is not enough since nowadays, my D drive became full when I run my SAS program. So I wonder if I can locate work library on D drive as well as C drive at the same time or not...

Smile1 · ‎09-24-2021

Hi Koen, Thank you for your response. Yes, COMPGED costs are very quickly above 100. But I think maybe there is a way to standardize COMPGED costs based on 0 - 100. It is no doubt that we can easily recognize which name is close to the original if we can measure COMPGED costs based on 0 - 100, rather than 0 - infinite. I will try different ways as well. Thank you for your help!

Smile1 · ‎09-24-2021

Hi ChrisNZ, Thank you for your response. Yes, A score lower than 100 is for almost identical strings.... But I think maybe there is a way to standardize COMPGED costs based on 0 - 100. It is no doubt that we can easily recognize which name is close to the original if we can measure COMPGED costs based on 0 - 100, rather than 0 - infinite. I will try different ways as well. Thank you for your help!

Smile1 · ‎09-24-2021

Hi Ballardw, Thank you for your response. Yes, it takes very little to exceed 100 with Compged scores.. But I think maybe there is a way to standardize COMPGED costs based on 0 - 100. It is no doubt that we can easily recognize which name is close to the original if we can measure COMPGED costs based on 0 - 100, rather than 0 - infinite. Maybe I need to learn how to use SPEDIS if I can't find a way to standardize COMPGED costs based on 0 - 100. Thank you for your help!

Smile1 · ‎09-20-2021

Hi~ To match COMPGED scores to 100 or less in legt join, I used compged function as below. ============================================================================ libname proj "D:\SASWORK"; proc sql; *Left join ccmmatch with s34match via cusip; create table dualmatch as select a.*, b.mgrname, b.fdate, b.shares, b.shrout2, compged (a.lender, b.mgrname, 'I') as match from proj.ccmmatch a left join proj.s34match b on (a.cusip=b.s34cusip1) and (compged (a.lender, b.mgrname) le 100) and (year(a.FacilityStartDate)=year(b.FDATE)) and (month(a.FacilityStartDate) between month(b.FDATE)-2 and month(b.FDATE)); quit; ============================================================================ There is no errors in this code. However, my COBPGED scores are much larger than 100 as follows. I would really appreciate it if anyone could give me a help. Thanks!

Smile1 · ‎09-14-2021

Thank you for your advice, PG. Now, my COMPGED function is working. I will try to use COMPLEV function as well sooner or later. Thanks, have a wonderful day! 🙂

Smile1 · ‎09-14-2021

Hi Koen, Thank you so much for your help! I added modifier 'I' as you advised. I coded as below and my sas program was finally working. Thank you so much! 🙂 ========================================== libname proj "D:\SASWORK"; proc sql; *evaluate name similarity with score 0~100; create table nameexample as select *, compged (lender, mgrname, 'I') as similarity from proj.periodexample where calculated similarity le 100; quit; ==========================================

Smile1 · ‎09-12-2021

Hi~ To match COMPGED scores to 100 or less, I used compged function as below. ========================================== libname proj "D:\SASWORK"; proc sql; *evaluate name similarity with score 0~100; create table nameexample as select *, compged (lender, mgrname) as similarity from proj.periodexample where calculated similarity le 100; quit; ========================================== There is no problem from line 1 to 5. However, when I add 'where calculated similarity le 100;', I can't get the result. The log message is as follows : ========================================================= Note : Table WORK.NAMEEXAMPLE created, with 0 rows and 11 columns. ========================================================= I would really appreciate it if anyone could give me a help. Thanks!

Online Status	Offline
Date Last Visited	‎11-12-2021 01:21 AM

Re: Can I locate work library on D: drive as well as C: drive at the s...

Re: Can I locate work library on D: drive as well as C: drive at the s...

Re: Can I locate work library on D: drive as well as C: drive at the s...

Re: Can I locate work library on D: drive as well as C: drive at the s...

Re: Can I locate work library on D: drive as well as C: drive at the s...

Can I locate work library on D: drive as well as C: drive at the same ...

Re: How to match COMPGED scores to 100 or less in left join?

Re: How to match COMPGED scores to 100 or less in left join?

Re: How to match COMPGED scores to 100 or less in left join?

How to match COMPGED scores to 100 or less in left join?

Re: Can I locate work library on D: drive as well as C: drive at the s...

Re: Can I locate work library on D: drive as well as C: drive at the s...

Re: Can I locate work library on D: drive as well as C: drive at the s...

Re: Can I locate work library on D: drive as well as C: drive at the s...

Re: Can I locate work library on D: drive as well as C: drive at the s...

Can I locate work library on D: drive as well as C: drive at the same ...

Re: How to match COMPGED scores to 100 or less in left join?

Re: How to match COMPGED scores to 100 or less in left join?

Re: How to match COMPGED scores to 100 or less in left join?

How to match COMPGED scores to 100 or less in left join?

Re: How to match COMPGED scores to 100 or less?

Re: How to match COMPGED scores to 100 or less?

How to match COMPGED scores to 100 or less?