Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
I need basic solution to a SAS problem on the mainframe
If you're still wondering --- try this on a "vector switch" and save yourself some cpu time of reading the file twice. And yes --- you need that "@;" as a place holder. OPTIONS PAGESIZE=60; DATA MASTER; INFILE...- HerbLR
- Post #4
- Forum: SAS Institute, Inc. solutions
-
Verify data is all numbers.....
I've used the following developed macro's with good success in the past. Hope this helps. PROC FORMAT ; VALUE $XXX '0'-'9' ='NUM' ; RUN; ... %*------------- ; %MACRO NUMCHKS ...- HerbLR
- Post #2
- Forum: SAS Institute, Inc. solutions
-
From Sybase to Oracle
If you're using a UNIX environment for a transfer of SyBase to Oracle, the following has been tested and proven successful in this endeavor. ===> Your UNIX script ::: # # Pulling of Sybase data # isql -U<userid> -P<password> -S<sybase system> < some_code_view.sql bcp dbo.some_code_ora out...- HerbLR
- Post #2
- Forum: Oracle: All versions
