Using ARRAYS as Opposed to PROC TRANSPOSE

jbilenas — Thu, 02 Feb 2023 21:41:43 GMT

A number of SAS learners asked me if using ARRAYS in SAS® for large data sets works better than using PROC TRANSPOSE. Someone asked how he can get 100-character variables, with different variable names, stored as one variable. ARRAYS are stored in memory in SAS which may speed up the runs. My blog shows my answer.

https://jonasbilenascom.wpcomstaging.com/wp-content/uploads/2023/02/Using_ARRAYS_-as_Opposed_to_PROC_TRANSPOSE_to-TRANSPOSE.pdf

Also has some topic of LIBNAME for XLSX if you have SAS 9.4M2 and larger maintenance(M).

topic Using ARRAYS as Opposed to PROC TRANSPOSE in SAS Procedures

Using ARRAYS as Opposed to PROC TRANSPOSE