About FriedEgg

FriedEgg · ‎09-15-2011

How are you running the script as different user? Did you check that &sysuserid is showing the expected user appropriatly during your runs?

FriedEgg · ‎09-15-2011

Yes, my assumption is that sas_Forum is experiencing the poor performance because he is either not allowing or does not have enough memory to store the full hash table in memory and is instead performing a high number of page swaps and context switches.

FriedEgg · ‎09-15-2011

You probably want to pursue DLing's method since your system seems undersuited for hash objects of the size you are attempting to use. My tests I posted earlier only used 100MB of ram executing so unless you are storing very large text strings you maybe using too much swap space which can hinder performance. Try running with options fullstimer. Post the statistics from your datastep. Also check your options for the memory and performance groups.

FriedEgg · ‎09-15-2011

Take a look at this similar post, it should provide your answer. http://communities.sas.com/message/103590#103590

FriedEgg · ‎09-15-2011

You could do this before the proc sql step: data _null_; call symput('usr',"'"||"&sysuserid"||"'"); run; then change saslogin=&usr in proc sql.

FriedEgg · ‎09-15-2011

What are you planning to do with the numbers, you may want to consider storing as character, depending on your intention.

FriedEgg · ‎09-15-2011

I do not see an issue with the function approach, could you please provide sample of issue you see.

FriedEgg · ‎09-14-2011

I was just right in the middle of the pretty much the same thing... proc fcmp outlib=work.funcs.temp; function oras(v,l) $; s=ifc(v<0,'-','+'); n=putn(v,cats('Z',l,'.')); w=strip(s)||strip(n); return (w); endsub; run; options cmplib=work.funcs; data _null_; nbr=1234; l=6; want=oras(nbr,l); put want=; run; want=+001234

FriedEgg · ‎09-14-2011

Basically this is the direction I was meaning for you to take my post. Here is another example: $cat example.bat @echo off if NOT (%1)==() GOTO RUN ECHO ----Batch Program Notes---- ECHO Required Parameters: ECHO [program_fullpath] ECHO --------------------------------------- GOTO END :RUN for /F "tokens=2,3,4 delims=/ " %%i in ('date/t') do set d=%%k%%i%%j for /F "tokens=1,2,3 delims=:. " %%i in ('time/t') do set t=%%k%%i%%j "C:\Program Files\SAS\SASFoundation\9.2\sas.exe" -batch -nologo -sysin "%1" -sysparm "%*" -log "%~dpn1_%d%_%t%.log" -print "%~dpn1_%d%_%t%.lst" :END Wow, it has been a long time since I have thought about windows bats. I prefer *nix.

FriedEgg · ‎09-14-2011

I don't think there is a way to do it with proc format to have a properly filled dynamic length, although there should be, probably beyond my knowledge as well. data _null_; input nbr; if nbr<0 then sign='-'; else sign='+'; want6=sign || strip(put(abs(nbr),Z6.)); want8=sign || strip(put(abs(nbr),Z8.)); put want6= want8=; cards; 1234 -1234 ; run; want6=+001234 want8=+00001234 want6=-001234 want8=-00001234

FriedEgg · ‎09-14-2011

So, you want to calculate the conditional mean?

FriedEgg · ‎09-14-2011

Hi, I have been working on my knowledge of hash tables and to train myself I usually like to find/create puzzles. I was thinking of something to do and I remembered a word puzzle that was created by the author of Alice and Wonderland. It is called a word ladder. The basic concept (from the wiki page linked above): Take two words with the same length, for instance: COLD, WARM and find the list of words that easily transform with the alteration of a single letter for form the new word. COLD->WARM COLD cord card ward WARM In a situation where a connection cannot be found in the version I remember you can scramble the letters from the last word in your ladder to form a new word and continue from that point. As an example: COLD->DRAW COLD cord card ward DRAW* note that this is just an example and there is probably a way to make this connection without the scramble. Typically the words used to for a ladder are antonyms in my experience so I challege you to create a program that can solve a ladder from BLACK->WHITE Have fun! P.S. I have attached a copy of the unix word dictionary to help along the way.

FriedEgg · ‎09-14-2011

data have; format pidate mmddyy10.; input (clamno lineno) ($) pidate mmddyy10.; cards ; 12345 001 09/27/2011 12345 002 08/16/2011 12345 003 10/11/2011 23456 001 09/27/2011 23456 002 08/15/2011 23456 003 07/14/2011 13456 001 07/27/2011 13456 002 08/15/2011 13456 003 07/14/2011 ; run; proc sql; select * from have group by clamno having month(max(pidate))=9; quit; EDIT: ART beat me

FriedEgg · ‎09-14-2011

You can do it all in a single step too: data tabs; input tabname $20.; call execute('proc import out=raw_' || strip(tabname) || ' datafile="C:\temp\' || strip(tabname) || '" dbms=excel replace; sheet="' || strip(tabname) || '"; getnames=yes; run;'); cards; Tab1 Tab2 OTHER SPECS ; run;

FriedEgg · ‎09-14-2011

you can add the -log option to define a different location for the log output that is in a properly writable directory. Also if executing in batch mode you should also use the -batch option. c:\program files\SAS\SASFoundation\9.2\sas.exe -batch -log c:\mylog.log -sysin c:\mypgm.sas -print c:\mylst.lst -sysparm My Passed Paramameter

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