You need to provide a few details. What does your file look like? When you say ASC, do you mean an ascii text file? Can you include a couple of lines of the file?
Tom
Provide an example of the file.
Open the file with a text editor, Copy a few lines and then paste them into a text box opened on the forum with the </> icon above the message window.
If you have any documentation about the data file then provide that information or a link to the description.
How are you trying to "extract data"? Use one of the tools to import the data? The tools generally are for simple well structured files. If you have a complex or non-standard file then those tools are likely going to have a problem.
And 'receive error message' with no details of what specific task or the actual message is not very helpful.
There should also be a .sas program file for each .ASC text file.
You will probably need to made a small edit to the program file before running it to make sure that the program has the name of where you stored the ASC file.
Just open the program file in your SAS editor and look for the INFILE statement. In the programs I got they started with a PROC FORMAT step to define some format first so the DATA step that actual reads the file starts later in the file.
Unless they have made changes since I last loaded HCUP_NIS data files.
For that you need to understand what variables you have and what they mean.
For example is there a variable that indicates a state? How is it coded?
Is there a variable that indicates disease? How is it coded? Is Lyme Disease actually one of the diseases in the database?
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!
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.