I'm using SAS 9.4.   I need to read a column in Excel called "site codes" that can look like this:   8X01 B902 WXT5.   How do I tell SAS to look at these 3 site codes  individually and understand there is a space between them?     Thank you. ... View more

Hi,   I can't get the month and year to appear in the ODS PDF FILE, but it works throughout the program.   %let today = %sysfunc( TODAY()); %let month = %sysfunc( PUTN(&TODAY - 28,MONNAME3.)); %let year = %sysfunc( PUTN(&TODAY - 28,YEAR4.));   ODS PDF FILE = 'C:&month&year_VideoCounts.pdf';     Thanks! CEG ... View more

Hello,   I'd like to compare dates by using TODAY and TODAY -1 to see when my incoming date (TODAY) becomes a new month.   Any suggestions?   Thanks, CEG ... View more

Hi,   Is it possible to have one sysin that creates two reports?   Could I add a second report to the example below? Or, do I need additional code (sysin) to create the second report.     "%MYSASROOT%\SASFoundation\9.3\sas.exe" -sysin "%CODEDIR%\Report1.sas" -log "%DATADIR%\Report1.log" -print "%DATADIR%\Report1.lst" -sysparm ""     Thanks, CEG ... View more

Hi,   I just want to add a "1" to variables called "segment."   They look like "ABC," ....."XYZ."   I was wondering why this doesn't work:   If carrier = 'CTL' then segmentplus = segment || "1";   I get ABC not ABC1.     Thanks. ... View more