Go to Home Page
Questions?
Call 1-800-572-5517
 
  Go to Home Page  
  See all products
  See price schedules
  See manuals, tutorials, articles
  Download a free 30-day trial
  See user testimonials
  About Pacific Systems Group
 
  Welcome Rocket Software MXI Users - Learn about Spectrum SMF Writer for MXI
  Choose Spectrum Writer to add 4GL to your product
  Report Writer Speedup Tips Article
Spectrum Writer 4GL - the economical alternative to SAS, Easytrieve, DYL-280...

SAS Functions with Spectrum Writer Equivalents


SAS Function

Spectrum Writer Function

Description

COMPBL #COMPRESS compress blanks out of a string
INPUT #MAKENUM, #MAKEDATE, #MAKETIME convert character string to numeric, date or time value
LOWERCASE #LCASE make characters all lower case
PUT #FORMAT convert numeric value to character string
SUBSTR #SUBSTR extract a substring from a string
TRANSLATE #TRANSLATE translate all occurences of one character to another character within a string
UPCASE #UCASE make characters all upper case
FLOOR #INT return integer portion of a numeric value
MIN #MIN return lower of two or more values
MAX #MAX return higher of two or more values
MOD #MOD returns the integer remainder after a division of two numbers
ROUND #ROUND change the decimal precision of a numeric value
DATE #TODAY returns the system date
DAY #DAYNUM returns the day part of a date
MONTH #MONTHNUM returns the month part of a date
TODAY #TODAY returns the system date
YEAR #YEARNUM returns the year part of a date
Copyright 2022.
Pacific Systems Group.
All rights reserved.


Spectrum Writer 4GL - the economical alternative to SAS, Easytrieve, DYL-280...

Home | Products | Prices | Documentation | 30-Day Trials | Customer Reviews | Company
Send Your Comments or Questions