BookmarkSubscribeRSS Feed
Jackie_ptsafe
Calcite | Level 5

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.

 

Jackie_ptsafe_0-1600109383156.png

 

 

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

2 REPLIES 2
PaigeMiller
Diamond | Level 26

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.

--
Paige Miller
ballardw
Super User

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.

 

 

sas-innovate-white.png

Missed SAS Innovate in Orlando?

Catch the best of SAS Innovate 2025 — anytime, anywhere. Stream powerful keynotes, real-world demos, and game-changing insights from the world’s leading data and AI minds.

 

Register now

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 608 views
  • 0 likes
  • 3 in conversation