Here is another option that works within a macro: 213 %macro monthly; 214 proc sql; 215 create table Lobs (Lob char(3), State char(2)); 216 insert into Lobs 217 values ('IMR','IL') 218 values ('IMD','IL') 219 values ('MMD','MO') 220 values ('MMR','MO') 221 values ('HMR','IN') 222 values ('OMD','OH') 223 values ('OAD','OH'); 224 quit; 225 %mend; 226 %monthly NOTE: Table WORK.LOBS created, with 0 rows and 2 columns. NOTE: 7 rows were inserted into WORK.LOBS. NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds
... View more