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
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.
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.
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 16. 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.