SAS users.
I am having issues of importing the attached CSV file.
I keep getting missing values for the first 2 columns.
What would be the remedy for this? (FYI, My sas version is 9.1)
The code.
%let log_input = file location/OpenSpan_Process_Log_20130213.csv
DATA LOG_INPUT;
/* Enterprise Guide creates this temporary asterisk delimited text file from the original data source */
INFILE "&log_input."
DELIMITER=','
MISSOVER
DSD
LRECL=32767
FIRSTOBS=2
;
LENGTH
eForm_Date 8
Email_Date $ 18
OS_Start_Date 8
OS_Finish_Date 8
User_Id $ 10
Status $ 9
Unique_ID $ 24
App_Type $ 8
Application_No 8
_T_Application_No $ 12
Outcome $ 10
_W_StringValue $ 22
;
INFORMAT
eForm_Date DATETIME18.
OS_Start_Date DATETIME18.
OS_Finish_Date DATETIME18.
;
FORMAT
eForm_Date DATETIME18.
OS_Start_Date DATETIME18.
OS_Finish_Date DATETIME18.
;
INPUT
eForm_Date : ANYDTDTM22.
Email_Date $
OS_Start_Date : ANYDTDTM22.
OS_Finish_Date : ANYDTDTM22.
User_Id $
Status $
Unique_ID $
App_Type $
_T_Application_No $
Outcome $
;
DROP
_T_Application_No
_W_StringValue
_W_NumericValue
;
LABEL
eForm_Date = "eForm_Date"
Email_Date = "Email_Date"
OS_Start_Date = "OS_Start_Date"
OS_Finish_Date = "OS_Finish_Date"
User_Id = "User_Id"
Status = "Status"
Unique_ID = "Unique_ID"
App_Type = "App_Type"
Application_No = "Application_No"
Outcome = "Outcome"
;
_W_StringValue = _T_Application_No;
LINK CheckForLogicValue;
Application_No = _W_NumericValue;
RETURN;
/* Requires _W_StringValue to be set with the value to be checked */
CheckForLogicValue:
IF UPCASE(TRIM(_W_StringValue)) = "TRUE" THEN
_W_NumericValue = 1;
ELSE
IF UPCASE(TRIM(_W_StringValue)) = "FALSE" THEN
_W_NumericValue = 0;
ELSE
_W_NumericValue = INPUT(_W_StringValue, COMMA32.);
RETURN;
RUN;
When I looked up the details on the ANYDTDTMw. format it doesn't look like it supports the format your data for eForm_date appears in the file. You may need to read and parse the time and date parts of that field separately and combine to get a datetime value.
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.
Select SAS Training centers are offering in-person courses. View upcoming courses for: