Hello all - I am trying to use PROC IMPORT to read data from an EXCEL file, code below.  The columns that are giving me trouble are timestamps that are formatted like this (12/11/2018 4:02:39 PM) in the excel spreadsheet.  The issue is that if the first row has an empty cell then the format of the data changes.  If the first row has a timestamp then the data comes in formatted like this (09JUN2020 12:13:14), if the first row is blank then the rows that have timestamps come in formatted like this (06/09/2020 12:13:14).  I have tried to force the data type by using the DBDSOPT option and I used DATETIMEw, ANYDTDTTMw and CHAR(w) and none worked.  Any help is appreciated. PROC IMPORT OUT=&outfile. DATAFILE= &infile. DBMS=EXCELCS REPLACE; RANGE="&sheetname.$"; DBDSOPTS= " DBTYPE=('UNDER_REVIEW_TS'='DATETIME19.' 'final_status_ts'='DATETIME19.' ) "; TEXTSIZE=32767; SCANTEXT=YES; USEDATE=YES; SCANTIME=YES; SERVER="server_name"; PORT=1235; SERVERUSER=&user_id.; SERVERPASS=&pass_word.; RUN; ... View more

Hello - I have some code that reads an excel file, there are two columns in this file.  One is a customer identification number and the other is a date or a datetime.  I have no control over the contents of the excel file so I need to be able to read the date/datetime field and convert it to a date.  When I use the datepart function and the column is a date it turns the date to 1/1/1960 but works perfectly fine if the column is a datetime value.  I have searched long and hard for a reasonable solution without success. Is there a way to make the value a date value without compromising the data, regardless of the datatype (date/datetime) of the column? ... View more

Hello - I am trying to pass a query (as a string) to a macro.  When I PUT the query variable this is what it looks like in the log.   QUERY_TXT=select a.cust_id, a.order_dt, prod_type, prod_subtype from  VPS_PRM.order_data a where a.order_dt = '2020-05-09'   This is the code that I am using... string = cats('%nrstr(%RunReport(ISD=',strip(Start_Dt),',IED=',strip(End_Dt),',Days=',strip(Lookback_Days),', AT=',strip(Attachment_Type),', Query=',%quote(Query_Txt),'));'); This is the error that I am getting... ERROR: All positional parameters must precede keyword parameters.   Subsequent errors point to the query_txt variable ERROR 180-322: Statement is not valid or it is used out of proper order.   Any help to resolve my issue is much appreciated.   Thank you.   CALL EXECUTE(string); ... View more