SAS Programming

DATA Step, Macro, Functions and more
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

Join us for our biggest event of the year!

Four days of inspiring keynotes, product reveals, hands-on learning opportunities, deep-dive demos, and peer-led breakouts. Don't miss out, May 6-9, in Orlando, Florida.

 

View the full agenda.

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
  • 571 views
  • 0 likes
  • 3 in conversation