SAS Programming

DATA Step, Macro, Functions and more
BookmarkSubscribeRSS Feed
JasonNC
Quartz | Level 8

Hi,

Can any body please let me know good books for learning Arrays and Hashing.I also want to know is hashing always better than PROC SQL.

3 REPLIES 3
MikeZdeb
Rhodochrosite | Level 12

hi ...

#1  SQL vs HASHING ... depends on the situation

#2  rather than a book, you can learn a lot from papers ... try http://www.albany.edu/~msz03/epi697.html

there are links to several good papers on ARRAYS and if you scroll down to the section "FORMAT ALTERNATIVES" there are links to several papers on hashing (read them in the order shown on the web site)

#3  go to ... http://www.lexjansen.com/

and search for ARRAYS and/or HASHING and you'll find lots of free papers at all kinds of levels

Linlin
Lapis Lazuli | Level 10

Thank you Mike! I want to learn hash too.

Ksharp
Super User

Everyone has its advantage .You cann't simply judge someone is better than others.

SQL is a industrial standard which has already prove its value.

Hashing and SQL has its own advantage respectively . It is hard to compare them.

I recommend to learn both skills. The more skills you have learned ,the more powerful you will be.

Ksharp

sas-innovate-white.png

Our biggest data and AI event of the year.

Don’t miss the livestream kicking off May 7. It’s free. It’s easy. And it’s the best seat in the house.

Join us virtually with our complimentary SAS Innovate Digital Pass. Watch live or on-demand in multiple languages, with translations available to help you get the most out of every session.

 

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
  • 3 replies
  • 1276 views
  • 0 likes
  • 4 in conversation