Hi
I tried to open a .dat file in order to see the contents/data in the file. I stored the file in a shared location and try to open it in the browser. It din't open , moreover it was downloaded. can u pls help me in opening the opening the file to see what data we have in that file.
Thank you
P.S. attached the .dat file
The reason the file was downloaded and not opened is that a .DAT file isn't a SAS file. In fact .DAT is an extension used for many different types of files which can sometimes only be opened by the application that created them. You might, however, be in luck if the .DAT files you want to read are text based delimited files like CSVs. Try opening them in a text editor to check out the format and if it's a plain text delimited file try Proc Import.
The reason the file was downloaded and not opened is that a .DAT file isn't a SAS file. In fact .DAT is an extension used for many different types of files which can sometimes only be opened by the application that created them. You might, however, be in luck if the .DAT files you want to read are text based delimited files like CSVs. Try opening them in a text editor to check out the format and if it's a plain text delimited file try Proc Import.
Thanks can u explain more about proc import
Proc Import is a SAS supplied routine you can use to convert many different file types into SAS Data Sets - you can find the documentation here -> http://documentation.sas.com/?docsetId=acpcref&docsetTarget=p0mqdq52ktqgjjn1vseqoiuyt3v1.htm&docsetV... and numerous online examples via a Google Search.
Anytime you encounter a SAS problem, do a (google) search for "sas text_of_your_problem". This works well with statements, functions, formats, procedures, but also ERROR or WARNING messages.
See Maxim 6.
Thanks
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.