Hi SAS experts, I'm new to SAS programming, could you please help with the following! I've multiple date columns for a study and some of these date columns can be completely empty for all the rows, so while importing, SAS is importing these completely empty columns as length 1 characters. Since other dates are imported as dates and I'm not able to compare across these dates. My sample data looks like this   id,date1,date2,date3 100,,, 101,10-10-2020,20-10-2020, 102,15-10-2020,, 103,,, I'm trying to import this using proc import out= test datafile = "/home/one/sas/study_data.txt" dbms = CSV REPLACE ; delimiter=',';guessingrows=32767; DATAROW=2; run; In the imported data, I'm seeing the date3 as character of length 1, so I'm not able to compare this date3 column with date2   Is there a way, we can tell SAS to import all the date columns (date1, date2, date3) as date columns of format YYMMDD10. even though some of these columns are completely empty and if the column isn't empty, it should import all the data in the format YYMMDD10.   Thanks a ton in advance!!     ... View more

Hi there!   I'm new to SAS programming, and trying to write the statement "In X patients of study, y% are not having data" in my ods statement, but the values are not getting calculated as expected.   Requirement: I've two macro variables and I'd like to write a string to ods, in that string add a percentage calculated from the two macro variables. %let x = 20; %total = 150; ods rtf text = "~S={outputwidth=100% just=c font=('Times New Roman',12pt)} { *In &x patients of study. (round(&x./&total. * 100,.02)%) are not having data}";   Question: Seems like round function only works in data step, but here it's not working. How can I calculate the percentage on the fly and include in the ods text.   Thanks a lot in advance!     ... View more