![]() ![]() So the alternate line is needed with a different length informat. format needed to read the longer values with AM PM will not read 99:99. If you don't do anything special for 99:99 it will likely be treated as 4:39:00 AM. So this is one example of reading the 3 provided "times" into actual SAS time values: data junk Įlse y=. No but you will have to do some additional coding because you apparently have text values and that may be fun as you will need to use some different formats to read this as the layout is changing.Īlso, is 99:99 actually an indicator for not collected data? That is a very suspect "time" value as minutes seldom go past 59 (60=> a new hour. SAS JMP Statistical Discovery combines powerful of Statistics with the use of graphics dynamically. ![]() Description: SAS JMP Statistical Discovery best tool selection for scientists, engineers and other explorers data in almost every sector of industry and government is. Then i found the time variable became a problem.ĭo i have to read the CSV to fix the time issue? Link download SAS JMP Statistical Discovery 13.2.1 win32 win64 full license. I saved the csv to xlsx and read the xlsx file into sas without issue. I cannot post any data here since they are sensitive. If your data is not too sensitive perhaps you could paste a few lines of the data from the CSV file into a code box opened with the forum's icon or attached as text to show exactly what you have and that we can test code did post the proc import CSV file problem. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2022
Categories |