About FriedEgg

FriedEgg · ‎09-17-2011

The rule is to change only one letter per step in the ladder, it can be any letter though. BLACK blank blink clink chink chine whine WHITE This is the shortest version of the ladder I can find. It is not a simple task, for sure.

FriedEgg · ‎09-16-2011

Okay, I think I understand better now what the meaning of this is. These are generic keyboard macros, not specific to the SAS editors.

FriedEgg · ‎09-16-2011

I do not recommend. It cannot be used for that purpose. I should have been more clear in my post.

FriedEgg · ‎09-16-2011

I was replying to your original posting while you posted a working solution. It finds a version in 15 steps. Can it be optimized to find shortest ladder?

FriedEgg · ‎09-16-2011

compress(provno,'*');

FriedEgg · ‎09-16-2011

The link does indeed exist in the dictionary file provided, I manually checked all the words, if you would like I will give you the answer to the ladder to help debug. There are 6 words in the chain. There is also another linkage that takes 9 steps.

FriedEgg · ‎09-16-2011

Very nice! Too bad I never use sas interactivly

FriedEgg · ‎09-16-2011

If you are dealing with very large character fields you should attempt to save space by performing md5 hash on values prior to entering the hash step. Here is example using random generated data on 100,000 record set. System reported memory usage again at just about 100MB total max according to fullstimer and at OS level max virtual size of process was between 450-500MB, the test file is 10MB in size on disk. The operation took about 36 seconds between multiple runs. To test vrs larger string I use put fuction on the md5 hash output to format as binary128. This would be same as having every char field in OP's original data being of length $128. Memory usage was slightly higher about 160MB on average with VIRT of about 520MB. The test file is 47MB in size on disk now. About 41 seconds of run time between multiple runs. In short, I have seen increased performance by utilizing 'call sortc' function for dataprep as well as md5 hash for decreasing size of large character fields. The only issue is that both of these methods obscure your data. So it would be good to add a finder key to link the generated household back to the original data. I have spent enough time on this for right now but I will later. test data sent to KSharp's process: data test; call streaminit( 12345 ); array a[4] $200 pan1-pan3 add1; do i=1 to 10**5; do j=1 to dim(a); a =/*put(*/md5(abs(mod(int(rand('cauchy')*10**5),10**6)))/*,binary128.)*/; end; output; end; call sortc(of a ); drop i j; run; sas_Forum Can you please share your memory and performance options settings as I had asked before. Also about available free memory on your computer, what version of windows are you running specifically? As art297 inquired, where are you sourceing this data from as it goes into the hash step, are you pulling across network, disk, tape, etc...???

FriedEgg · ‎09-16-2011

DLing is correct about reference the documentation that is available. I will explain that regular expression briefly. s/<[^>]*>// substitute, look for < that is not immediately followed by > but has any other string inbetween another >, replace with nil Also by using the prxdebug function you will get nice information in your log about what it is doing, can help you understand, maybe.

FriedEgg · ‎09-16-2011

&sqlobs is the output count of a executed sql task. proc sql; create table want as select * from sashelp.class; %put &sqlobs; quit;

FriedEgg · ‎09-15-2011

His requirements said; if the whole clamno that has the ind='Y' then the version number should be '1' - When the field pidate month in the clamno is with in the processing month then the version number is"0". So this instance meets both criteria and wondering which takes precedence?

FriedEgg · ‎09-15-2011

What should happen when you have all in a group with 'Y' and the max(date)=process_month? Should it be 1 or 0? In the logic previously posted the result will be 0. 92390 001 09/02/2011 Y 0 92390 002 08/02/2011 Y 1

FriedEgg · ‎09-15-2011

Hmm, I deleted my previous comment because it was dumb, but apparently it removed Art and my answers as well, seems like a issue with the forum??? data have; format pidate mmddyy10.; input (clamno lineno) ($) pidate mmddyy10. revind $; cards ; 12345 001 09/27/2011 Y 12345 002 08/16/2011 N 12345 003 10/11/2011 Y 23456 001 09/27/2011 Y 23456 002 08/15/2011 Y 23456 003 07/14/2011 Y 12390 001 09/02/2011 Y 12390 002 08/02/2011 N 92390 001 09/02/2011 Y 92390 002 08/02/2011 Y 13456 001 07/27/2011 N 13456 002 08/15/2011 N 13456 003 07/14/2011 Y ; run; proc sql; select clamno,lineno,pidate,revind, case when month(pidate)=9 then 0 when min(revind)='Y' and max(revind)='Y' then 1 else 1 end as versionnumber from have group by clamno having month(max(pidate))=9 order by clamno,lineno; quit;

FriedEgg · ‎09-15-2011

Thanks, Tom. I would still like to know what issue Chris is having with the functional approach?

FriedEgg · ‎09-15-2011

What authentication mode are you using to spawn the conncetions, does each profile use the same user? &sysuserid is the system user, so it should be equal to the value of the user that performs the login to that session.

Online Status	Offline
Date Last Visited	‎03-31-2025 06:28 PM