I have one dataset (Arias_View1)that I exported from Arias (At Risk Identification Alerting System) with 26,328 records and a second exported Arias dataset (Arias_View2) with 91,060 records.  These datasets have the same number of columns and header names.  The only difference is in the first dataset (Arias_View1)   These datasets need to be stacked vertically     with       Arias_View1                                                                                           Arias View2 So I ran this code Proc Sql noprint; CREATE TABLE SASCDC_2.Arias_County_Race_Ethnicity AS SELECT * From SASCDC_2.ARIAS_View_1 OUTER UNION CORR SELECT * FROM SASCDC_2.ARIAS_View_1; quit; But the error read that field 6 in the first dataset (Arias_View1) is of different form that field 6 in second data set Arias_View2.  The field is DOB and in the first dataset and second dataset DOB is defined as follows:                         DOB is defined as NUM   length 8  format  MMDDYY10.  and in the second (Arias_View2)  DOB is defined as text  length 19  format $19.  informat  $19.     To try and correct the problem I ran   Data SASCDC_2.Arias_VIEW_2; Set SASCDC_2.Arias_VIEW_2;   dobchar = put(DOB, $10.);   drop DOB;   rename dobchar = DOB; run; However, this creates a DOB variable that is Text with length 10. The SQL query with  Outer Union Corr   does not execute because it notes that DOB is different in VIew1 than in View2.   How do I solve the DOB issue so that the Outer Union Corr runs successfully? Thank you for your assistance again in this problem. wlierman   ... View more

Hello,   I have a small data set that is set up like         Organization                        Counties_served       Contact_tracing Community Health Plans                 Gilliam                           Y                                                          Baker                            Y                                                          Lake                             Y Multnomah Community Clinic          Blaine                           Y                                                          Callum                         Y                                                          Hood River                  Y                                                          Malheur                       Y Habitat for Humanity                        Lane                            N Meals on Wheels                             Lincoln                         Y                                                         Columbia                      Y Farm Workers Cooperative             Malheur                        Y                                                         Yamhill                         N                                                         Washington                  N                                                          Camas                         Y                                                         Harney                         Y   My question is how to get a count of counties_served for each organization when the organization isn't repeated for each line.   I was planning on a Proc sql code and then use Order By to keep the Counties_served by Organization.   I am not sure on that approach.  Your help is appreciated.     wklierman ... View more

This is a common question regarding using Proc Import to import xlsx and csv files into SAS.   I have used this code for the last couple imports and it worked well.  It is shone here Proc import datafile = "I:\Health Analytics\AMB_INFORMATICS\ARIAS_COUNTY_RACE_ETHNICITY\All Contacts_Added_Fields 11_3_2020.xlsx" out = SASCDC_2.ARIAS_County_Race_Ethnicity dbms = xlsx replace; getnames=yes; run; But the error of Physical file does not exist comes back.  I have probably walked through the coding a dozen times.   Proc import datafile = "I:\Health Analytics\AMB_INFORMATICS\ARIAS_COUNTY_RACE_ETHNICITY\All 501! Contacts_Added_Fields 11_3_2020.xlsx" 502 out = SASCDC_2.ARIAS_County_Race_Ethnicity 503 dbms = xlsx 504 replace; 505 getnames=yes; 506 run; ERROR: Physical file does not exist, I:\Health Analytics\AMB_INFORMATICS\ARIAS_COUNTY_RACE_ETHNICITY\All Contacts_Added_Fields 11_3_2020. NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE IMPORT used (Total process time): real time 0.00 seconds cpu time 0.00 seconds     Is there anything that I am forgetting.  Someone suggested removing some of the file steps and just have the xlsx / csv files after the AMB_INFORMATICS step.  The thing is though this coding worked with the last import about two weeks ago.   Any help or direction will be appreciated.   Thanks.   wlierman   ... View more

I am putting together a table of Preferred contact method (email, text, phone) from a survey of contacts for contact tracing.  Then I wish to express the results by the binary result 'Contact Successful'.  This is the code Proc sql noprint; CREATE TABLE SASCDC_2.Contact_Reached_by_RE AS SELECT Contact_Attempt_Successful, Preferred_Method_of_Contact, Count(American_Indian_and_Alaska_Nativ) AS _American_Indian_Alaska_Native, Count(Asian) AS _Asian, Count(Black_or_African_American) AS _Black__or__African_American, Count(Hispanic_or_Latino_a_x) AS _Hispanic_or_Latino_a_x, Count(Middle_Eastern_North_African) AS _Middle_Eastern__North_African, Count(Native_Hawaiian_and_Pacific_Isla) AS _Native_Hawaiian_and_Pacific_Isl, Count(White) AS _White FROM SASCDC_2.Arias_age_groupings Group By Contact_Attempt_Successful, Preferred_Method_of_Contact; quit; The output doesn't look too bad but I would like to insert a subtotal by preferred_method_of_contact for each contact_attempt_successful   The results look like this (this is an abbreviated table): Contact_Successful  Preferred_Method      AIAN        Asian     Hispanic     White No                                    Email                      6             11              65            158 No                                    Phone                    17            29          1303            467   Would like a subtotal here ========>       23            40          1368            625   Yes                                   Email                     16             66           181             656 Yes                                   Phone                    39           112         1799           1145      Would like a subtotal here ========>       55          178         1980           1801        Also is there a trick to position the Yes responses first then the No responses below them?   Thank you for your assistance.   wlierman   ... View more

I have the following results from proc freq tables statement. I will give just a couple lines like:                                                                              Age Grouping   County                   0-9    10-19   20-29   30-39   40-49   50-59   60-69     70-79    80 and Above    Total    Baker                      31        14      25        23         12        16        22           13              0                 156    Benton                    49      141    250        74         46         47       33             7               9                656                                                             . . . . .   My question is what is the easiest way I can export the table from the Results Viewer into Excel.    Thank you.   wlierman ... View more