topic Date and time not in proper format in SAS Programming

Date and time not in proper format

takumamih — Fri, 16 Jun 2017 23:04:46 GMT

My date/time in the raw data file is in a mmddyyyy 00:00 format as a single variable, and I cannot get it to show up properly in sas.

Several informats gave me missing values, correct dates with no time, 1960/01/01 dates, etc.

Also, the field has about 20 characters, but it only shows up if I tell sas that it's 30 characters or more.

Every time the next variable in the row is missing (PM25), the date/time is also missing.

154 data burnaby1;

155 set burnaby;

159 input @4 testchar $1. @;

160 drop testchar;

161 if testchar in ('0','1','2','3','4','5','6','7','8','9') then

162 do;

163 input @3 dattim :anydtdtm30.

164 PM25 32-38

165 NO2 43-49;

167 output;

168 end;

169 format dattim datetime20.;

170 run;

Base SAS 9.3 TS1M2

Re: Date and time not in proper format

ballardw — Fri, 16 Jun 2017 23:14:17 GMT

First try the anydtdtm with a 32 width. Sometimes using the full width allowed works better, or don't specify one at all.

What file format is your raw data file? Since you are showing code for a data set already in existence you may want to back up a step.

If you start with Excel and are using Proc import you might try saving the data as CSV before attempting to import it. Use a largish value for a guessingrows parameter.

Re: Date and time not in proper format

Reeza — Sat, 17 Jun 2017 00:02:22 GMT

Your code is nice, but without an example of the data we can't say much.

Re: Date and time not in proper format

Kurt_Bremser — Sat, 17 Jun 2017 07:11:37 GMT

Your code does not make sense. If you already have a dataset, you need no input statement, as the set statement does the read.

If you want to read from an external file, you have to use an infile statement to open the file for INPUTting.

Post an example of your raw data file, as a properly created data step will very probably fix your problems in one sweep.