Hello,  I have a SAS code where I am calculating dates of multiple years (between 2018 and 2023). I don't want to have to repeat the code for each year and was wondering how I could convert this into an array. Note that this isn't the full code, just part of it, I figured if folks here can assist with the smaller code I maybe able to do it for the bigger code.  Below is the code where I want to run an array for each year. So 2023 would be replaced with 2018, then 2019 and so on.    if admit_dt lt '01jan2023'd then date1='01jan2023'd ; else date1= admit_dt; if dsch_dt eq . or dsch_dt gt '31dec2023'd then date2='31dec2023'd; else if dsch_dt ne . and dsch_dt le '31dec2023'd then date2= dsch_dt;  Suggestions would be great! Thanks!   ... View more

I have a dataset of patients who are admitted and then transferred to another clinic. Sometimes they may get transferred a few times. I would like to get their first admission date and not the transferred date.  For example I have the table with admit_date and dsch_date. You will notice that at times the admit_date repeats for a few records (see client A) but then there is a new record with a new admit_date that is the same as the previous dsch_date. What I would like to do is get the first admit date and last discharge date if it is available. If the dsch_date is missing then the client is still in treatment. I would like to get admit_date1 and dsch_date1 column.    Client admit_date dsch_date admit_date1 dsch_date1 A 6/28/2002 3/30/2015 6/28/2002 7/12/2019 A 6/28/2002 3/30/2015 6/28/2002 7/12/2019 A 6/28/2002 3/30/2015 6/28/2002 7/12/2019 A 3/30/2015 7/12/2019 6/28/2002 7/12/2019 B 1/9/1998 8/21/2013 1/9/1998 . B 8/21/2013 . 1/9/1998 . C  1/29/2008 2/21/2008 1/29/2008 . C 2/21/2008 2/15/2023 1/29/2008 . C 2/15/2023 . 1/29/2008 . Here is the sas code for the table I have:   data have; input Client:$1. admit_date:mmddyy10. dsch_date:mmddyy10. ; format admit_date dsch_date mmddyy10.; datalines; A 6/28/2002 3/30/2015 A 6/28/2002 3/30/2015 A 6/28/2002 3/30/2015 A 3/30/2015 7/12/2019 B 1/9/1998 8/21/2013 B 8/21/2013 . C 1/29/2008 2/21/2008 C 2/21/2008 2/15/2023 C 2/15/2023 . ; run; Thank you!       ... View more

Hello,  I have a question on how one can import a csv file from a website that is user and password protected. I have access to this website. Via the website a reports are run on data that is collected. Each of the reports have an option to export the data under the report as a csv. Now I can go to each report and manually click and download the csv file (its ; delimited BTW), but I was wondering if there is a way to have SAS access the site (I would need to put in the HTML and user and password information but how?) and also have it direct to the report (which I have noticed has its own unique html) and then export the csv. But how can I do this?   You assistance would be great! Thanks!!   ... View more

I have a CSV file that is being extracted using API (see table 1 below). I am importing that data into SAS so I can clean it up. As I am using proc  I realize that some cells have two values that looks like are separated by a tab (see column flat_value first=John last=Doe). So when I import the data wherever the values are separated by a tab they show up in a new line and under the incorrect column (see table 2).    Table1: PID field label flat_value client_id 1 121697600 Hosp Type Clubhouse A 2 121697753 Reporting Period 6/1/2022 A 3 121698840 Confirm Hosp Type Oneonta Teen Center A 4 121718909 What is the name? first = John last = Doe A 5 121718930 Email Address John.doe@aol.com A 6 127510515 Does you have bilingual staff? No A 7 121838918 Total Visits 0 A 8 121838577 Unique Individuals Served 0 A     Table 2: PID field label flat_value client_id 1 121697600 Hosp Type Clubhouse A 2 121697753 Reporting Period 6/1/2022 A 3 121698840 Confirm Hosp Type Oneonta Teen Center A 4 121718909 What is the name? "first = John   last = Doe" A       5 121718930 Email Address John.doe@aol.com A 6 127510515 Does you have bilingual staff? No A 7 121838918 Total Visits 0 A 8 121838577 Unique Individuals Served 0 A   This is the code being used. PROC IMPORT OUT= want DATAFILE= "C:\have.csv" DBMS=csv; GETNAMES=YES; RUN; Suggestions on how to deal with the possible tab or space in one cell can be handled. I would want it to either (1) stay in the same cell but may have have a separator, or (2) have its own column or row if possible.    Thanks!         ... View more

Hello,  Not sure how complicated this is but thought maybe some one here would know what to do or have an alternative solution to my issue.    I would like to download ICD 10 codes by its chapter and subchapter names. Using this website (https://icd.codes/icd10cm/chapter1)  I could click on a chapter and then copy and paste each record into excel and clean it up but I was wondering if I could somehow have SAS do it instead. For example, chapter 1 is "Certain infectious and parasitic diseases" (which would be a value in a column called "chapter")  and then codes A00-A09 would be the sub chapter "Intestinal infectious diseases" and then each ICD 10 would have its description as a third column (so A00 would be Cholera, A01 would be "Typhoid and paratyphoid fevers" etc. See table below as the result.  But I would want to do this for all the chapters. suggestions?   Code Chapter SubChapter Description A00  Certain infectious and parasitic diseases Intestinal infectious diseases Cholera A01  Certain infectious and parasitic diseases Intestinal infectious diseases Typhoid and paratyphoid fevers A02  Certain infectious and parasitic diseases Intestinal infectious diseases Other salmonella infections A03  Certain infectious and parasitic diseases Intestinal infectious diseases Shigellosis A04  Certain infectious and parasitic diseases Intestinal infectious diseases Other bacterial intestinal infections A05  Certain infectious and parasitic diseases Intestinal infectious diseases Other bacterial foodborne intoxications  not elsewhere classified A06  Certain infectious and parasitic diseases Intestinal infectious diseases Amebiasis A07  Certain infectious and parasitic diseases Intestinal infectious diseases Other protozoal intestinal diseases A08  Certain infectious and parasitic diseases Intestinal infectious diseases Viral and other specified intestinal infections A09  Certain infectious and parasitic diseases Intestinal infectious diseases Infectious gastroenteritis and colitis unspecified     ... View more