Hello all, I am attempting to output in a data set text like this for auto caluclation in an excell file that SAS ODS produces for me: =EXACT({table_name1}!A1,{table_name2}!A1) =EXACT({table_name1}!A2,{table_name2}!A2) =EXACT({table_name1}!A3,{table_name2}!A3) =EXACT({table_name1}!A#...,{table_name2}!A#...)   My code: %macro create(howmany); %do i=1 %to &howmany; data check_db; a&i.="=EXACT(census!A&i.,cendev!A&i.)"; B&i.="=EXACT(census!B&i.,cendev!B&i.)"; c&i.="=EXACT(census!C&i.,cendev!C&i.)"; output; run; %end; %mend create; %create(1); proc print data=check_db; run; My output:   Obs                a1                             B1                             c1  1     =EXACT(census!A1,cendev!A1)    =EXACT(census!B1,cendev!B1)    =EXACT(census!C1,cendev!C1) However when I put in 2, or 3, 4, ... I still only get one line (1 obs) and the numbers all change to the number passed in.   Can someone straighten me out here? What I want is if I pass in 20 I get 20 obs all numbered from 1 to 20.   %create(2); proc print data=check_db; run;                                                                                                                                                                                                                          14:52 Wednesday, September 21, 2016 837 Obs                a2                             B2                             c2  1     =EXACT(census!A2,cendev!A2)    =EXACT(census!B2,cendev!B2)    =EXACT(census!C2,cendev!C2) PS I get no errors: 4097  %macro create(howmany); 4098     %do i=1 %to &howmany; 4099        data check_db; 4100      a&i.="=EXACT(census!A&i.,cendev!A&i.)"; 4101  /*output;*/ 4102      B&i.="=EXACT(census!B&i.,cendev!B&i.)"; 4103  /*output;*/ 4104      c&i.="=EXACT(census!C&i.,cendev!C&i.)"; output; 4105 4106        run; 4107     %end; 4108  %mend create; 4109 4110  %create(2); NOTE: The data set WORK.CHECK_DB has 1 observations and 3 variables. NOTE: DATA statement used (Total process time):       real time           0.01 seconds       cpu time            0.01 seconds NOTE: The data set WORK.CHECK_DB has 1 observations and 3 variables. NOTE: DATA statement used (Total process time):       real time           0.00 seconds       cpu time            0.00 seconds 4111 4112  proc print data=check_db; 4113  run; NOTE: There were 1 observations read from the data set WORK.CHECK_DB. NOTE: PROCEDURE PRINT used (Total process time):       real time           0.00 seconds       cpu time            0.00 seconds TIA.  -KJ   ... View more

Hello everyone, I have a need to count the number of records in a list of dynamic files and create a new small table with the name of the file as the key and the total number of records as one data field.   (Well in next version[s] I will be adding a per term [strm] record count field/term, and snapshot, etc.)   Anyway I am not sure how to go about this,  I can easily count a file or two but I think I need an array or a do loop and am not sure what is the best way given my long term goal.  ...and being a bit of a hack at SAS with just one year of experience have as of yet to try a single array. I am hoping to get some advice. And maybe a bit of starter code.  Anyway here is some of my starter code (SAS 9.4): *be sure to update the snapshot and term in set_variable.sas program for each run...; %include "&pname.set_variables.sas"; libname test odbc dsn=test schema = dbo; %let Current_DB=test; %put &Current_DB; %put &snapshot; %put &strm; options nocenter; options ls=256; proc sql; create table mytables as select distinct TABLE_CATALOG length=8, TABLE_NAME length=32, '9999999999' as file_obs_ct length 10 from &Current_DB..my_metadata; quit; data mytables2; format TABLE_CATALOG $8.; format TABLE_NAME $32.; set mytables; run; data mytables; set mytables2; run; proc sql noprint; select TABLE_NAME into: TABLE_NAME_list separated by '","' from mytables where lower(TABLE_NAME) like "xw_%"; quit; %put "&TABLE_NAME_list."; proc sql noprint; select distinct count(TABLE_NAME) into: TABLE_NAME_ct separated by '","' from mytables /*where lower(TABLE_NAME) like "xw_%";*/ quit; %put &TABLE_NAME_ct.; TIA  -Keith   ... View more

Hello all, I have two Data Bases that store a field room, one has it with leading zeros and one without, the hitch is these rooms can have a alpha charater?   any ideas? I had some 1100 false positives now with this just a 100 or so   I came up with this: put(input(a.room,best4.),z4.) <> put(input(b.room,best4.),z4.)   I started with: a.room <> b.room but with data like:   a.room     b.room 451a        0451a 451b        0451b 1              00001 21            00021 1-1           001-1       I am not sure what to try to get them down to the true diffences that I want.  TIA   -KJ ... View more