topic Re: reading data in sas in SAS Studio

reading data in sas

gnrslasher37 — Sat, 04 Jun 2016 05:43:10 GMT

how can i read the following data in .DAT file into sas.

02:05:00:104 20050103|OB_CHANGE|2_YEAR|912828DF4|1|20|ADD |6|26D3918E86D75FF7|25558|20|A|20|20|

Thanks.

Re: reading data in sas

Ksharp — Sat, 04 Jun 2016 06:47:49 GMT

What output would you like to see ?

Re: reading data in sas

ballardw — Sat, 04 Jun 2016 07:46:43 GMT

Looks like data step and use DLM='|'.

If you want an actual datetime value you should read that first bit as character and then parse it for time and date bits.

Being occasionally lazy I might be tempted to use the import wizard on that file and then copy the generated code from the log and modify any missed details. Use a large value for the number of rows to guess, if practical the number of lines in the file.

Your first variable will most like be text as I doubt format is a standard datetime one SAS will recognize.

Parsing the date time bit would look something like:

time = input(scan(dtvariablename,1),time.);

date = input(scan(dtvaraiblename,2), yymmdd.);

and to get an actual datetime variable

datetime = dhms(date, 0,0,time);

You should apply appropriate formats to date, time and datetime suitable to your needs otherwise the values will be pretty meaningless to most humans looking at the data.

Re: reading data in sas

gnrslasher37 — Sat, 04 Jun 2016 08:45:33 GMT

Thanks.

Re: reading data in sas

anoop1409 — Sat, 04 Jun 2016 11:17:47 GMT

Here is the exact SAS code :

data work.datupld ;
infile "/home/anoopyuvaa0/xyz.dat" dlm='|';
length Timestamp $22;
input Timestamp $ var1 $ var2 $ var3 $ num1 num2 var4 $ num3 var5 $ num4 num5 var6 $ num6 num7;
run;
proc print data = work.datupld;
run;

Please see the attached screenshot for the output.

Thanks!

Re: reading data in sas

ballardw — Sun, 05 Jun 2016 04:48:28 GMT

Thank you for posting your exact solution.

For what it may be worth DAT is not any standard file structure. The contents can be a text and delimited as yours of proprietary binary. The first DAT files I ran into had the dat stand for "digital audio tape" and were for sound...