Hello Experts: I have few questions want to ask about hash table. 1.When use hash table to look up matched records, do records in hash table scanned sequentially from top to bottom or it will jump to the corresponding key value straight just like index? 2.What is the advantage and disadvantage of hash table compare to proc sql and data step merge? 3.To be updated in the future... Thanks ... View more

Why do you have to define call missing(variables) when define a hash table? I thought during the execution phase of data step, the variables will automatically be assigned a missing value so why do you still have to use call missing routine in the hash. Thanks ... View more

Hello Experts, When I create a hash table, I have to specify the key value, but if I want to replace the key value with a new variable created during the hash iterator process within the same data step. How do I do that? For the code below, I want the dataset work.temp1(highlighted in red) to be created  before it hold by "mylittlehash1" ,how do I achieve that? My goal is to use one single datastep (with hash) to complete the task as shown in the code below. data work.temp1 work.temp2; attrib filename length=$1000 sfname length=$1000 key length=$1000; if _n_=1 then do; declare hash mylittlehash(dataset: 'library.want', ordered:'yes'); declare hiter mylittlehashter('mylittlehash'); mylittlehash.defineData('filename'); mylittlehash.defineKey('sfname'); mylittlehash.defineDone(); call missing(filename,sfname,key); end; rc=mylittlehashter.first(); do until (rc ne 0); perlexpression2=prxparse("/\w*(\w\w\d\d\d\d)(\w)\w*/"); if prxmatch(perlexpression2,filename) then do; Key=upcase((prxposn(perlexpression2,1,filename))); output work.temp1; rc=mylittlehashter.next(); end; end; declare hash mylittlehash1(dataset: 'work.temp1', ordered:'yes', duplicate: 'r'); mylittlehash1.defineKey('key'); mylittlehash1.defineData('key'); mylittlehash1.defineDone(); end; set files_found; perlexpression=prxparse("/\w*(\w\w\d\d\d\d)(\w)\w*/"); if prxmatch(perlexpression,filename) then do; Key=upcase((prxposn(perlexpression,1,filename))); end; if prxposn(perlexpression,2,filename)="Z"; rc=mylittlehash1.check(); if rc=0 then output work.temp2; run; Thanks ... View more

Hello Experts, When I create a hash table, I have to specify the key value, but if I want to replace the key value with a new variable created during the hash iterator process within the same data step. How do I do that? For the code below, I want the dataset work.temp1(highlighted in red) to be created  before it hold by "mylittlehash1" ,how do I achieve that? My goal is to use one single datastep (with hash) to complete the task as shown in the code below. data work.temp1 work.temp2; attrib filename length=$1000 sfname length=$1000 key length=$1000; if _n_=1 then do; declare hash mylittlehash(dataset: 'library.want', ordered:'yes'); declare hiter mylittlehashter('mylittlehash'); mylittlehash.defineData('filename'); mylittlehash.defineKey('sfname'); mylittlehash.defineDone(); call missing(filename,sfname,key); rc=mylittlehashter.first(); do until (rc ne 0); perlexpression2=prxparse("/\w*(\w\w\d\d\d\d)(\w)\w*/"); if prxmatch(perlexpression2,filename) then do; Key=upcase((prxposn(perlexpression2,1,filename))); output work.temp1; rc=mylittlehashter.next(); end; end; declare hash mylittlehash1(dataset: 'work.temp1', ordered:'yes', duplicate: 'r'); mylittlehash1.defineKey('key'); mylittlehash1.defineData('key'); mylittlehash1.defineDone(); end; set files_found; perlexpression=prxparse("/\w*(\w\w\d\d\d\d)(\w)\w*/"); if prxmatch(perlexpression,filename) then do; Key=upcase((prxposn(perlexpression,1,filename))); end; if prxposn(perlexpression,2,filename)="Z"; rc=mylittlehash1.check(); if rc=0 then output work.temp2; run; Thanks ... View more

Hello experts, I am wondering how do I highlight the content and subject of the SAS email output: for example I want to highlight the following bolded words with yellow colour. FILENAME Mailbox EMAIL "&email" Subject= "Suite Number:aaaaa- Reference Number: aaaaa"; DATA _NULL_; FILE Mailbox; PUT "Hello"; PUT "This is a notification "; RUN; Thanks ... View more

Hello experts, How do I convert table A to table B like following: Table A: variable1 a                aaa            bbb ccc ddd eee b eee ggg hhh jjj qqq ... ... Table B variable1      variable2             aaa               a bbb               a ccc                a ddd               a eee               a eee               b ggg               b hhh               b jjj                   b qqq                b ... ... Thanks so much! ... View more

Hello Experts, I have recently awared that ODS excel became available to SAS users to produce native excel file(xlsx) that can insert charts. I have done that successfully on the EG. I am just wondering when it comes to stored process, how do you make the following codes work if you use streaming output in stored process.(I do not want to save any excel output and just want to display it with AMO) ods excel FILE="c:\a.xlsx"                                       options(sheet_interval="none"   sheet_name="CARS summary" ); proc means data=sashelp.cars; var msrp invoice; run; ods excel options(sheet_interval="none" sheet_name="graph"); proc sgplot data=sashelp.cars; histogram msrp; run; ods excel close; Thanks ... View more

Hello Experts, I have recently awared that ODS excel became available to SAS users to produce native excel file(xlsx) that can insert charts. I have done that successfully on the EG. I am just wondering when it comes to stored process, how do you make the following codes work if you use streaming output in stored process.(I do not want to save any excel output and just want to display it with AMO) ods excel FILE="c:\a.xlsx"                                       options(sheet_interval="none"   sheet_name="CARS summary" ); proc means data=sashelp.cars; var msrp invoice; run; ods excel options(sheet_interval="none" sheet_name="graph"); proc sgplot data=sashelp.cars; histogram msrp; run; ods excel close; Thanks ... View more