cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
satyamsachan26
‎06-15-2022
  • 4 Posts
  • 4 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: Date11. Format Issue while reading the raw data in SAS

by Fluorite | Level 6 in SAS Programming
‎06-15-2022 11:45 AM
‎06-15-2022 11:45 AM
Got your point Tom, No need to make Customer_id and TRANS_ID as numeric here. Also thanks a lot for this detailed solution. ... View more

Re: Date11. Format Issue while reading the raw data in SAS

by Fluorite | Level 6 in SAS Programming
‎06-15-2022 11:39 AM
‎06-15-2022 11:39 AM
Hi, Thanks a lot for this detailed explanation. ... View more

Re: Date11. Format Issue while reading the raw data in SAS

by Fluorite | Level 6 in SAS Programming
‎06-15-2022 11:38 AM
‎06-15-2022 11:38 AM
Thanks a lot for this quick solution Paige Miller. ... View more

Date11. Format Issue while reading the raw data in SAS

by Fluorite | Level 6 in SAS Programming
‎06-15-2022 09:22 AM
‎06-15-2022 09:22 AM
Hi All, I am trying to read the below data but I think because of date11. format, data is not correctly read by SAS. Please help how to read this data.   data transaction; infile cards dlm='09'x; input Customer_Id Trans_Id Trans_Date date11. Trans_Amt 5.0; format Trans_Date date9.; cards; 101 111 21-Apr-21 20000 102 167 22-Apr-22 15000 104 345 23-Apr-22 14000 105 112 24-Apr-22 12000 run;   Data is tab-delimited to I used dlm='09'x.   O/P- Trans_Amt is not correct. ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎06-15-2022 03:08 PM
Likes given to
Quick links