Something interesting is happening when I am trying to create a hash table from a table with no rows. In the following example Temp1 has no rows, Temp2 has one row. I would expect Temp3 to have one row with missing value for x. But Temp3 has no rows. I have this logic in a big data step with multiple hash tables and as soon as one of the hash table input talbe is empty all the subsequent ones fail to load and nothing is written to output tables in the data step. Anyone know why this happens and how to control it? Thank you. Proc Sql;      Create Table Temp1 (P Char(1), x Num); Quit; Data Temp2;      P="A"; y=3; Output; Run; Data Temp3(Drop=rc);      Declare Hash myhash();      myhash.DefineKey('P');      myhash.DefineData('x');      myhash.DefineDone();      eof=0;      Do Until(eof);           Set Temp1 end=eof;           rc=myhash.add();      End;      eof=0;      Do Until(eof);           Set Temp2 end=eof;           rc=myhash.find();           output;      End;      Stop; Run; ... View more

Is there a sas function that can conactenate all members of a temporary character array using a given seperator? Something like CatX(" ", of myArr)  but this doesn't work. Here is a sample code of what I want to accomplish using some function. Data _null_;      Array myArr {4} $ _temporary_ ("A" "B" "C" "D");      Length catResult $100;      catResult="";      Do i=1 to dim(myArr);           catResult=CatX(" ", catResult,myArr{i});      End;      Put catResult; Run;      Thanks ... View more

How can I see information about all session compiled macros? Thanks!! ... View more

Hello,      When I run the following code I get warning saying that "var1 not resolved" from the %put statement in Macro2. %Macro Macro1(Var1 = myVar);      %Put Inside Macro1 with Var1 = &Var1;      %Macro2 %Mend Macro1; %Macro Macro2(Var2);      %Put Inside Macro2 with Var1 = &Var1; %Mend Macro2; %Macro1 But when I change the code to the following (only change is semi colon after %Macro2 invocation line) Var1 is accessible from Macro2 and I get no warning. What is going on? %Macro Macro1(Var1 = myVar);      %Put Inside Macro1 with Var1 = &Var1;      %Macro2; %Mend Macro1; %Macro Macro2(Var2);      %Put Inside Macro2 with Var1 = &Var1; %Mend Macro2; %Macro1 Thank you ... View more