Also good to know. Thanks! ... View more

Thanks Reeza, this worked! ... View more

Quick update all,   I made a change and ran in like this    proc sql;  select marketing_id send_date as psend_date format mmddyy8.,   It technically formatted correctly, but now the date show as protected ("*****") in the output and when I click into the cell, it shows every date 12 12/31/9999 instead of the correct date. Any clue as to why?   Thanks   ... View more

Hi RW9, I would need to refrence the table right? I did it like so (shown below) and I get this error: "ERROR: Invalid variable specification, tableau.metadata_match. Variable names of the form X.X must be either FIRST.X or LAST.X." data want; datepartonly=datepart(processed_dttm); format datepartonly mmddyy10. from table1; run; ... View more

Hi Tom, I looked at the table properties and it appears that it is coming in as a date with a length of 8. ... View more

Quick update, I meant to write mm/dd/yyyy ! ... View more

Perfect! This was very helpful Thank you. ... View more

proc sql; create table city_residents as select a.salutation_title, a.first_name, a.last_name, a.suffix, a.address_line1, a.address_line2, a.city, a.state_province, a.zip_code from table1 (obs = 100) a inner join table2 b on a.zip_id = b.mc_zip_id inner join table3 c on a.individual_num = c.individual_num where a.pref_language_code = 'ENG' and b.MSA_NAME like'%Nashville%' and a.address_line1 <> ' ' and a.MAILABLE = 'Y' and a.pref_language_code = 'ENG' group by 1; quit;       NOTE: Writing TAGSETS.SASREPORT13(EGSR) Body file: EGSR 21 22 GOPTIONS ACCESSIBLE; 23 proc sql; 24 create table locals as 25 select 26 a.salutation_title, 27 a.first_name, 28 a.last_name, 29 a.suffix, 30 a.address_line1, 31 a.address_line2, 32 a.city, 33 a.state_province, 34 a.zip_code 35 from table1 (obs = 100) a 36 inner join 37 table2 b 38 on a.mc_zip_id = b.mc_zip_id 39 inner join 40 table c 41 on a.INDIVIDUAL_NUM = c.INDIVIDUAL_NUM 42 where a.pref_language_code = 'ENG' 43 and b.MSA_NAME like'%Nashville%' 44 and a.address_line1 <> ' ' 45 and a.MAILABLE = 'Y' 46 and a.pref_language_code = 'ENG' 47 or a.tier_name in ('Member', 'Discoverist') and c.qualifying_stays_last_12m >=1) 48 group by 1; NOTE: The "<>" operator is interpreted as "not equals". WARNING: A GROUP BY clause has been transformed into an ORDER BY clause because neither the SELECT clause nor the optional HAVING clause of the associated table-expression referenced a summary function. NOTE: Table WORK.LOCALS created, with 16 rows and 9 columns. 50 quit; NOTE: PROCEDURE SQL used (Total process time): real time 4.84 seconds ... View more

So when I applied that, I only got a single record back. ... View more

Perfect! thank you ... View more

 Hi Reeza,   Thanks for the reply. I tried it an it did not work. I received the error below:   25 add tactic char format=$CHAR. length = $30; _ 22 200 ERROR 22-322: Expecting an integer constant. ERROR 200-322: The symbol is not recognized and will be ig ... View more