topic Re: Import of data issues in SAS Programming

Import of data issues

Jackie_ptsafe — Mon, 14 Sep 2020 18:51:08 GMT

I am brand new to SAS and I have imported an excel document. However I do not see any properties with it now in SAS-like length, format, label that was shown in the demo. Is this something I needed to do prior to import? I am not a programmer. I have the screenshot below.

On a different question, I have other files that have character variables for example that are matched with numeric codes. For example 123=CO2014 which would indicate as specific type of a communication issue. 123 would be in one column and CO2014 would be another column. If I were to bring all of these types of variables over into SAS, how should I handle this? I have not yet tried to this yet.

thank you in advance-Jackie

Re: Import of data issues

PaigeMiller — Mon, 14 Sep 2020 19:45:12 GMT

A little more information would help. What SAS interface are you using? Enterprise Guide? Base SAS? SAS Studio? Other?

How did you do the Import? Explain the exact process, step-by-step.

How did you call up the box in the screen capture? Explain the exact process, step-by-step.

Re: Import of data issues

ballardw — Mon, 14 Sep 2020 19:57:42 GMT

For the second question you would be better off providing an example of the data file. If it is a text file of some sort you could copy a few lines using and text handler like Notepad or even the SAS editor and paste into a code box opened on the forum with the </> icon. The code box is important because the main message windows will reformat text and can severely distort what a text file might contain.

If the source is a different file type, such as spreadsheet or database then the specific file type and content layout need to be described or a copy provided.