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 2025: Call for Content

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!

Submit your idea!

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

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