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: 
rmit387
‎10-27-2020
  • 2 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: How to read non-standard dOutside/Open Areas in SAS

by Calcite | Level 5 in SAS Programming
‎10-27-2020 08:10 AM
‎10-27-2020 08:10 AM
Hi Jedi,  Thanks for your reply!    I tried your code but it still didnt work in SAS... I have trouble reading two different formats of date and FATALITY_LOCATION in SAS I intended to read the dates in AU format and FATALITY_LOCATION properly..    Have been trying to work it out for a few hours and still couldnt work it out.. sigh ... View more

How to read non-standard dOutside/Open Areas in SAS

by Calcite | Level 5 in SAS Programming
‎10-27-2020 07:18 AM
‎10-27-2020 07:18 AM
Hi  I have a csv file needed to read in SAS. I struggled to read  FATALITY_LOCATION  (please see attachment)   options LOCALE=en_AU; data fatalities; infile "/group/FATALITIES.csv" delimiter="," firstobs=2 dsd missover; input FATALITY_ID EVENT_ID FATALITY_TYPE$ FATALITY_DATE FATALITY_AGE FATALITY_SEX$ FATALITY_LOCATION$; informat FATALITY_ID EVENT_ID FATALITY_TYPE $10. FATALITY_DATE ddmmyy10. FATALITY_AGE FATALITY_SEX$ FATALITY_LOCATION $80.; format FATALITY_ID EVENT_ID FATALITY_TYPE $10. FATALITY_DATE date9. FATALITY_AGE FATALITY_SEX$ FATALITY_LOCATION $80.; run;   But then it came out with error message stated below:  ERROR 22-322: Expecting a format name. ERROR 76-322: Syntax error, statement will be ignored.    How to read to Outside/Open Areas in SAS?   Thanks in advance!!           ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎10-27-2020 11:31 AM
Quick links