Hi As already suggested you could use automatically created macro variables, i.e: proc sql; create table test as select * from sashelp.class ; %put SQLRC : &sqlrc; %put sqlobs: &sqlobs; quit; You can find documentation at the end of: http://support.sas.com/documentation/cdl/en/sqlproc/62086/HTML/default/a001360983.htm HTH Patrick ... View more

Hi, Just let you know that the drop option works in sas 9.3. data _null_; if 0 then set sashelp.class;      dcl hash h();      h.definekey('name');      h.definedata('name', 'age');      h.definedone();     do obs = 1 to nobs;        set sashelp.class nobs=nobs;        h.add();      end;      h.output(dataset: "work.class(drop=age)");     stop; run ; proc print data=class; run ;                                 Obs    Name                                     1    John                                     2    Alice                                     3    Henry                                     4    Joyce                                     5    Janet                                     6    Judy                                     7    William                                     8    Mary                                     9    James                                    10    Barbara                                    11    Carol                                    12    Ronald                                    13    Louise                                    14    Thomas                                    15    Alfred                                    16    Robert                                    17    Jane                                    18    Philip                                    19    Jeffrey Linlin ... View more

The sytax is the first and last values separated by a colon (you gotta love the colon it does so much for us). Here the array x will range from 10 to 15. [pre]array x{6} _temporary_ (10:15);[/pre] The following step augments this definition by passing through a list of values twice. [pre]data silly; array x{10} _temporary_ (2*1:5); do i = 1 to dim(x); y= x{i}; put i= y= ; end; run; [/pre] ... View more

thank you, data _null_. I see correct the sample code, _a even, 🙂 ... View more

Thank you both very much indeed. I love both suggestions. 🙂 It solves my problem perfectly. thank you very much again. ... View more

thank you very much for all the suggestions. I will just use two libs. I was expecting to have the lib.sublib.dataset type of structure, which I do not think sas support the nested dot notation thing. 🙂 ... View more

Your guys are rock!!! Thank you all very much indeed. ... View more

There is undocumented _method option to the proc sql statement. See also Kent's note at http://support.sas.com/techsup/technote/ts553.html ... View more

See this sas-l posting and the link in it. http://tinyurl.com/2c8939j or http://www.listserv.uga.edu/cgi-bin/wa?A2=ind1009C&L=sas-l&D=1&H=0&O=D&T=1&m=291216&P=11759 ... View more

Here is a link that gives the byte specification and maximum integer values on a Windows OS: http://support.sas.com/onlinedoc/913/getDoc/en/hostwin.hlp/numvar.htm ... View more