This is a pretty basic question that nonetheless keeps tripping me up.   I have a datetimevariable.  I extract the datepart and it is returned as a SAS date form.   I want a a DatePart form  like  dd/mm/yy. Here is the code Data SASCDC_2.Arias_Median_Days_Monitoring; Set SASCDC_2.Arias_Median_Days_Monitoring; C_Date=DatePart(Created_On); Create = ??? (C_Date); rename Create = Create_date; run; I put the ? marks in there.   So I have the following output                   Created_on                        C_date              26JUN20:09:40:24                22092   So I want Create (in code) to contain the DatePart representation of C_date like  26JUN20  and so on for the rest.   Thank you for your help.   wlierman ... View more

I am cleaning some extraneous strings from a text field Data SASCDC_2.Arias_County_RC_ETHNICITY_FILL; Set SASCDC_2.Arias_County_RC_ETHNIC_CLEANUP; If Identify_Race_or_Ethnicity in ("American_Indian", "American_Indian_(Cheeroke)", "American_Indian_or_Alaskan Native", "Apache", "Caucasian/_NAtive_American_Cow_Creek", "Caucasian/_Native_American", "Native_American", "Native_American_-_Cherokee", "Native_American_-_Turtle_Mountain_Reservation", "Native_American_German", "Native_American_Irish", "Native_American_and_White", "Native_American,_Hispanic,_Caucasian", "Native_American/Hispanic", "Native_America/Mexican", "Native_American/White", "Native/Indigenous", "Rosebud_Sioux_Tribe", "native_American", "native_american", "American_Indian_+_Other_White", "American_Indian_and_Caucasion", "Alaska_Native", "Alaskan_Native", "American_Indian/Hispanic") then Identify_Race_or_Ethnicity = 'NATIVE_AMERICAN'; run; In the survey the developers allowed individuals to provide free-form descriptions of R/E.  Then these free form responses are to be put into the stylized R/E buckets used by the Census and others.  Here is the log Set SASCDC_2.Arias_County_RC_ETHNIC_CLEANUP; 577 If Identify_Race_or_Ethnicity in 577! ("American_Indian","American_Indian_(Cheeroke)","American_Indian_or_Alaskan --- --- --- --- --- 49 49 49 49 49 577! Native","Apache","Caucasian/_NAtive_American_Cow_Creek","Caucasian/_Native_American", NOTE 49-169: The meaning of an identifier after a quoted string might change in a future SAS release. Inserting white space between a quoted string and the succeeding identifier is recommended. NOTE 49-169: The meaning of an identifier after a quoted string might change in a future SAS release. Inserting white space between a quoted string and the succeeding identifier is recommended. 581 "American_Indian/Hispanic") then Identify_Race_or_Ethnicity = 'NATIVE_AMERICAN' 581! ; 582 run; 581 "American_Indian/Hispanic") then Identify_Race_or_Ethnicity = 'NATIVE_AMERICAN' ------------------------------------------------------ 49 581! ; NOTE 49-169: The meaning of an identifier after a quoted string might change in a future SAS release. Inserting white space between a quoted string and the succeeding identifier is recommended. 583 Data SASCDC_2.Arias_County_RC_ETHNIC_CLEANUP; 584 Set SASCDC_2.Arias_County_RC_ETHNICITY_A; 585 586 If Identify_Race_or_Ethnicity in ("Mexican-Indian (these were their own words)", "US ---- ---- ---- ---- 49 49 49 49 I am not sure what the log is trying to tell me?  It is a note not an error technically, however when I check the field that is to be changed many of the free form texts are still there. I am searching for answers or remedies (that is why there are underscores between letters and other text expressions in the above).   In some other coding like Python that is sensitive to whitespace there is at least and explanation of how to correct and then the code runs as expected.  Here I think SAS is ambiguous (maybe not - so that is why I am asking how to correct this - even though it is just a note because the code doesn't produce the expected result.)   Thank you for your help.   wlierman ... View more

I have a dataset with several fields.  There are two fields for county - County and County_1.  I want to use County_1. However, there are 5 text strings in County_1 that need to be replaced with the corresponding value from County as well as missing values in county_1 provided county has a corresponding value.  Not every observation between the two sets is populated. There will end up being a few missing.    So for example this is what the data look like: The five strings in county_1 that need replacement are North, Warm, Confederated, OPHD, and Yellowhawk as well as missing.         County_1                          County    Polk                                     Baker                                   Baker    North                                   Columbia                                                Siskiyou    Warm                                  Baker    Confederated                      Washington                                                Malheur   Yellowhawk                          Jefferson                                                Wasco   Warm   OPHD                                   Yamhill        So the two missing obs in county_1 need to be replaced with text from county as well as when the other  erroneous text appear (Confederated, OPHD, Warm, North, Yellowhawk).  There may be some like the example with Warm in county_1 and a missing value in county.  That is okay, since there will inevitably be some missing values.  The idea is to populate as many observations in county_1 with acceptable substitutes.   Thank you for your help.   wlierman             ... View more

I am part of a state health organization.  The state uses SAS v10 and has an on-premise server.  I have been self-teaching a bit with SAS University and Jupyter notebook(Lab).  I am also learning Python (on Jupyter through anaconda) and so I am becoming a  fan of Jupyter notebooks for putting together code and text and visuals.   My question is how can Jupyter notebooks/Lab be used with SAS in our situation?  Would SASPy fit in? Your direction is most appreciated, since my super supports the idea of having Jupyter as a reporting tool.  But he wants to know that question posed above.   Thank you for your help.   wlierman       ... View more

I am using SAS University Edition JupyterLab.   This is what I have ''' options compress=yes; Libname SAS_1 'C:\SASUniversityEdition\myfolders'; Proc import Datafile = "C:\SASUniversityEdition\myfolders\data_code\All_Contacts.xlsx" dbms = xlsx out = SAS_1.All_Contacts_code replace; getnames=Yes; run; ''' The log ods listing close;ods html5 (id=saspy_internal) file=stdout options(bitmap_mode='inline') device=svg style=HTMLBlue; ods 114! graphics on / outputfmt=png; NOTE: Writing HTML5(SASPY_INTERNAL) Body file: STDOUT 115 116 options compress=yes; 117 Libname SAS_1 'C:\SASUniversityEdition\myfolders'; NOTE: Library SAS_1 does not exist. 118 119 Proc import 120 Datafile = "C:\SASUniversityEdition\myfolders\data_code\All_Contacts.xlsx" 121 dbms = xlsx 122 out = SAS_1.All_Contacts_code 123 replace; 124 getnames=Yes; 125 run; ERROR: Physical file does not exist, /media/sf_myfolders/C:\SASUniversityEdition\myfolders\data_code\/All_Contacts. 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 I can follow the path to the physical file which is an Excel xlsx file.   What is the form of the Libname statement?  Why does the path expressed in the datafile statement not find the excel file?   Thank you for your assistance. wlierman ... View more