Hi, I've >20 with the same variable names in each table which I need to import from MS Access to SAS and stack (merge?) them vertically. Each table represents a year's worth of data. Each table has about 10,000 observations in the following format. The values for field one may overlap from year to year but not within the same year. Each table is named Table70 for 1970, Table71 for 1971, through year 2012. Table; Year 1970 field1 field2 field3 field4 field5  001     2          3     3          2    002     1          2     2          34 etc... Table Year 1971 field1 field2 field3 field4 field5 001     2          4     9          9 002     1          4     9          44 etc... Table Year 1972...etc..through Table Year 2012 FINAL TABLE: year  field1 field2 field3 field4 field5 1970  001     2       3        3        2 1970  002     1       2        2        34 etc...(remaining observations in Table 1970) 1971  001     2      4         9       9 1971  002      1     4        9        44 etc.. (remaining observations in Table 1971) THROUGH Year 2012.... proc import out= work.table.&yr      datatable="table.&yr"      dbms = access replace;      database = "C:\My Docs\Tables 1970-2000.mdb";      scanmemo=yes;      usedate=no;      scantime=yes; run; How do do this using a macro statement ro iimport the tables, add a year field and stack them vertically? I only know how to import and add a macro variable for the year: Your help is much appreciated! Thank you! ... View more

Hello, I've two tables. TableA has all observations. TableB has 30 observations, all of which are in TableA. They can be matched by an 'ID' How do I create a new variable in TableA indicating that all the observations in TableB are 'late' (ie., new variable name = late; all IDs found in TableB are coded with late=1 in TableA). I know a long way:  use a data step, and use).  Is there a way to do using subquery in SQL? data new;      set tableA;      late=0;       if ID in ('0223', '0123', '0124' etc) then late=1; run;      Thanks! ... View more

Hello. I'm need to create a new variable.   I've about 20 more to add in the parenthesis below to code. The following doesn't work: if scode=('0001 or '0083') then late=1; Thank you! ... View more

Hello. This Question has 2 steps: I've a dataset, Table A with a variable, 'dist' which may have incorrect values. and have added a new variable 'dist_orig' which has the updated values. However, 'dist_orig' only has updated values for some but not all observations (i.e, some are missing).  Therefore I don't want to overwrite 'dist' with missing values in 'dist_orig'; I want to retain values of 'dist' for which I"m missing values in 'dist_orig'. The ulitmate goal is to update the variable 'dist' with the values in dist_org. I know how to do it if I divide Table A into 2 datasets and use the UPDATE statement. But, how do you update 'dist' with values in 'dist_orig' if they're in the same dataset? ... View more