data have; input Age $ Race $ Ethnicity $Gender $ DATE1: ddmmyy10. Class ; FORMAT DATE1 MMDDYY10.; datalines; 10 W C . 02/01/2017 1 . W C M 03/04/2015 2 . W C F 01/01/2016 2 ; run;   The final table should look like this but I want to be able to filter this output by date (year, qtr, month) and class:                   Missing        Not Missing           Total       year       Class Age             2                      1                        3 Race           0                      3                        3 Ethnicity      0                      3                        3 Gender        1                      2                        3   I tried this code: *create format for missing; proc format ; value $ missfmt ' '="Missing" other="Not Missing"; value nmissfmt .="Missing" other="Not Missing"; run; /* Created "Year" variable using teh date field and used that in proc freq:*/ *Proc freq to count missing/non missing; ods table onewayfreqs=temp; proc freq data=class; table _all_ / missing; format _numeric_ nmissfmt. _character_ $missfmt.; by year class; run; *Format output; data want; length variable $32. variable_value $50.; set temp; Variable=scan(table, 2); Variable_Value=strip(trim(vvaluex(variable))); keep variable variable_value frequency percent cum:; label variable='Variable' variable_value='Variable Value'; run; But I dont know how can I format the output by variables e.g. (date (year, qtr, month) and class). Thank you   ... View more

Hi, Trying to create year, qtr, month from a date in ddmmyy10. format - not working, any ideas?  The date field is a text field with $10 length. '01/31/2017'   Thank you   ... View more

Hi, Trying to create a left outer join with a table on the server. TableB is on the server and is a huge table, and TableA is the local table:     PROC SQL; CREATE TABLE NEW AS SELECT a.*, b.VAR1, b.VAR2, b.VAR3, b.VAR4, b.VAR5 FROM TableA AS a LEFT OUTER JOIN TABLEB AS b ON a.ID = b.ID; QUIT;     This code is taking very long actually more than 2 hours. Is there an efficient way I should run this code? like creating a temp table from the server and using that to join TableA.   Thank you   ... View more