Hi, i am using SAS8.2 and trying to connect to oracle.My server is on unix and just want to know what are the interfacinf files which are used and how the connection is established.
... View more
Hi, You can append the datasets and then can apply label.I have tried and i don't find any problem. Can you elaborate what is the issue if we append with different labels.
... View more
Hi, macro just substitute the resolved program as text in your macro call.in the first instance when you invoke the macro in proc sql it substitute the macro program text which is text_val in the place where you invoke the macro. However in second the macro program will resolve to may statement including data step which is not valid in proc sql. you can write proc sql to achieve your result conditinally.
... View more
