data Have; input name $ contents $; cards; RE_OP Sydney RE_OP Brussels RE_OP Paris RE_TRF Newyork RE_TRF Washington RE_TRF Houston RE_TRF Dayton ; proc sql; create table Names as select distinct name from Have; quit; data _null_; set Names; call execute("data "||strip(name)||";set Have;where name = '"||strip(name)||"';run;"); run; ... View more

Hello Amit, Thanks alot for your detailed explanation. you have cleared my doubt about the concept of local and global symbol table. regards, ved ... View more

Hi, Thanks a lot. This worked for me. ... View more

The idea of comparing two SAS programs as-is could be flawed, depending on the SAS environment where invoked, and also considering if/how SAS AUTOCALL MACROs or MACRO statements (old SAS 79 style - ex:  MACRO _BOO  BLAH BLAH BLAH % ) may be exploited (that being embedded code references where you would only see %xxxxxxx;  (disclaimer-invoked: oversimplified example) in the main SAS code-piece being analyzed. Also depending on the SAS process / code complexity, there may be path-conditions influencing just how much of the code is executed, such as a passed SYSPARM or incoming %LET macro variables. Scott Barry SBBWorks, Inc. ... View more

The classic sas DMS is connected to a terminal or running on your desktop. It is based on having some source (input) getting results (output) and a log file. It is the approach of batch processing with punch cards in the 60's. With Sas bi/di there is a metadata server object and more. It is more Iike a dbms system wit a data and system dictionary. All new solutions are based on that. Sas studio and Eguide server based. You can have more and shared sessions with those. Eguide studio sare sending the results and log after processing. Not terminal  based anymore. You will break that with an abort. ... View more

Hi Experts, Using an index in table momstatefips1 is one of options to reduce the processing time. An index can reduce the time required to locate a set of rows, especially for a large data file. proc sql noprint;   create index x on work.momstatefips1(x);   create table ds as   select a.*   from a inner join b   on a.momstatefips1 = b.momstatefips; quit; Br, Amit ... View more

I just used the call execute method because I knew the exact syntax for proc format/value from memory, but couldn't reliably recall the correct layout of the cntlin file ... View more

Mistake. Updated the correct program. I picked the dataset from work. Thanks, Amit ... View more

Thank you Patrick, I'm fully clear. ... View more