Maximum columns , that can be extracted from oracle to SAS ? 1

[sarayusam]

Hi,

(1) Using SAS/ACCESS when the data is extracted from oracle data base to SAS what should be the limit of the number of columns? or SAS can handle any number of columns?

(2) Number of columns that an Oracle data base can have?


regards,
sarayu

 

[ChrisW75]

sarayu - I imagine that there IS an upper limit on the number of columns that you can have, but I've never hit it, and I've had tables with more than 100 columns. If you "need" more than that, I would suggest a rethink on what you actually need, as coding to use that many columns will be a bit of a nuisance.