BookmarkSubscribeRSS Feed
gsw8
Calcite | Level 5

I need to import just a single excel cell using the proc import.  Can anyone tell me how to do that or provide a piece of code that does?

Many thanks,

2 REPLIES 2
art297
Opal | Level 21

You only need to define the range to be that one particular cell you want.  However, if you sheet has any special characters in it that could pose a problem.  If so, or if not, the following tech note supplies the code you need: http://support.sas.com/kb/19/827.html

gsw8
Calcite | Level 5

Thanks for the help.  The key is to use the ranges as described but to set the GETNAMES equal to NO.

g

SAS Innovate 2025: Save the Date

 SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!

Save the date!

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

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
  • 1071 views
  • 0 likes
  • 2 in conversation