Previous Page | Next Page

Formatting Prompt Values and Generating Macro Variables from Prompts

Entering Prompt Values in the SAS Stored Process Web Application

The following table explains how to format values for the various prompt types in the SAS Stored Process Web Application:

Guidelines for Entering Prompt Values (U.S. English Locale)
Prompt Type Guidelines Examples
Text Enter any character value. Blank spaces and nonprintable characters can be used, but the value cannot consist completely of these characters. Trailing blanks are stored as part of the value and are included when the value is validated against the minimum and maximum length requirements.
  • you are here

  • eighty-five

  • Bob


Numeric Enter a standard numeric value.
  • If you are working with an integer prompt, then do not use values with decimal places. If you use a value with zeros after the decimal point (for example, 1.00) for an integer prompt, then the zeros and the decimal point are removed before the value is stored (for example, 1.00 is stored as 1).

  • For prompts that allow floating-point values, the unformatted prompt value can contain up to 15 significant digits. Values with more than 15 significant digits of precision are truncated. Note that formatted values can have more than 15 significant digits.

  • 1.25

  • 6000

  • 2222.444


Date For dates of type Day, enter values in one of the following formats:
  • ddmonth-nameyyyy

  • mm/dd/yy<yy>

  • mm.dd.yy<yy>

  • mm-dd-yy<yy>

  • month-name/dd/yy<yy>

  • month-name.dd.yy<yy>

  • month-name-dd-yy<yy>

  • month-name dd, yyyy

  • day-of-week, month-name dd, yy<yy>

  • yyyy/mm/dd

  • yyyy.mm.dd

  • yyyy-mm-dd

  • yyyy.month-name.dd

  • yyyy-month-name-dd 


  • 4APR1860

  • 14January1918

  • 12/14/45

  • 02.15.1956

  • 1-1-60

  • Feb/10/00

  • March.1.2004

  • DEC-25-08

  • SEPTEMBER 20, 2010

  • FRI, Jan 3, 20

  • Monday, January 16, 40

  • 2041/5/13

  • 2050.07.25

  • 2100-1-1

  • 2101.December.31

  • 2400-Aug-8



Here is an explanation of the syntax:
day-of-week

specifies either the first three letters of the day of the week or the full name of the day of the week (the full name of the day must be used for values in .NET). This value is not case sensitive. (That is, the lowercase and uppercase versions of the same character are considered to be the same.)

dd

specifies a one-digit or two-digit integer that represents the day of the month.

mm

specifies a one-digit or two-digit integer that represents the month of the year.

month-name

specifies either the first three letters of the month or the full name of the month. This value is not case sensitive. (That is, the lowercase and uppercase versions of the same character are considered to be the same.)

yy or yyyy

specifies a two-digit or four-digit integer that represents the year. To refer to a year that is more than 80 years in the past or 20 years in the future, use four digits. Valid values for a four-digit year range from 1600 to 2400.



For dates of type Week, enter values in one of the following formats:
  • Www yy<yy>

  • Weekww yyyy

Here is an explanation of the syntax:

ww

specifies a one-digit or two-digit integer that represents the week of the year. Valid values range from 1 to 52.

yy or yyyy

specifies a two-digit or four-digit integer that represents the year. To refer to a year that is more than 80 years in the past or 20 years in the future, use four digits. Valid values for a four-digit year range from 1600 to 2400.

  • W1 08

  • W52 1910

  • Week 20 2020

  • Week 5 2048



For dates of type Month, enter values in one of the following formats:
  • mm/yy<yy>

  • mm.yy<yy>

  • mm-yy<yy>

  • month-name yy<yy>

  • month-name/yy<yy>

  • month-name.yy<yy>

  • month-name-yy<yy>

Here is an explanation of the syntax:

mm

specifies a one-digit or two-digit integer that represents the month of the year.

month-name

specifies either the first three letters of the month or the full name of the month. This value is not case sensitive. (That is, the lowercase and uppercase versions of the same character are considered to be the same.)

yy or yyyy

specifies a two-digit or four-digit integer that represents the year. To refer to a year that is more than 80 years in the past or 20 years in the future, use four digits. Valid values for a four-digit year range from 1600 to 2400.

  • 12/1828

  • 06.65

  • 7-76

  • Jul 08

  • JUNE/2010

  • SEP.20

  • October-2050



For dates of type Quarter, enter values in the following format:
  • quarter-namequarteryy<yy>


Here is an explanation of the syntax:

quarter-name

specifies the quarter of the year. Valid values are 1st, 2nd, 3rd, and 4th.

yy or yyyy

specifies a two-digit or four-digit integer that represents the year. To refer to a year that is more than 80 years in the past or 20 years in the future, use four digits. Valid values for a four-digit year range from 1600 to 2400.

  • 1st quarter 1900

  • 2nd quarter 50

  • 3rd quarter 12

  • 4th quarter 2060



For dates of type Year, enter values in the following format:
  • yy<yy>

Here is an explanation of the syntax:

yy or yyyy

specifies a two-digit or four-digit integer that represents the year. To refer to a year that is more than 80 years in the past or 20 years in the future, use four digits. Valid values for a four-digit year range from 1600 to 2400.

  • 1895

  • 86

  • 08

  • 2035


Time Enter time values in the following format:
  • hh:mm<:ss> <AM | PM>

Here is an explanation of the syntax:

hh

specifies a one-digit or two-digit integer that represents the hour of the day. Valid values range from 0 to 24.

mm

specifies a one-digit or two-digit integer that represents the minute of the hour. Valid values range from 0 to 59.

ss (optional)

specifies a one-digit or two-digit integer that represents the second of the minute. Valid values range from 0 to 59. If this value is not specified, then the value defaults to 00 seconds.

AM or PM (optional)

specifies either the time period 00:01 - 12:00 noon (AM) or the time period 12:01 - 12:00 midnight (PM). If this value is not specified and you are using the 12-hour system for specifying time, then the value defaults to AM.

Note:   Do not specify AM or PM if you are using the 24-hour system for specifying time.  [cautionend]

  • 1:1

  • 1:01 AM

  • 13:1:1

  • 01:01:01 PM

  • 22:05


Timestamp Enter timestamp values in one of the following formats:
  • mm/dd/yy<yy> hh:mm AM | PM

  • yyyy-mm-ddThh:mm:ss

  • ddmonth-nameyy<yy> :hh:mm:ss

  • <day-of-week,> month-name dd, yyyy hh:mm:ss AM | PM

Here is an explanation of the syntax:

day-of-week (optional)

specifies either the first three letters of the day of the week or the full name of the day of the week. This value is not case sensitive. (That is, the lowercase and uppercase versions of the same character are considered to be the same.)

dd

specifies a one-digit or two-digit integer that represents the day of the month.

mm

specifies a one-digit or two-digit integer that represents the month of the year.

month-name

specifies either the first three letters of the month or the full name of the month. This value is not case sensitive. (That is, the lowercase and uppercase versions of the same character are considered to be the same.)

yy or yyyy

specifies a two-digit or four-digit integer that represents the year. To refer to a year that is more than 80 years in the past or 20 years in the future, use four digits. Valid values for a four-digit year range from 1600 to 2400.

hh

specifies a one-digit or two-digit integer that represents the hour of the day. Valid values range from 0 to 24.

mm

specifies a one-digit or two-digit integer that represents the minute of the hour. Valid values range from 0 to 59.

ss

specifies a one-digit or two-digit integer that represents the second of the minute. Valid values range from 0 to 59.

  • 7/3/08 12:40 AM

  • 2012-11-23T15:30:32

  • 14FEB2020:11:0:0

  • Dec 25, 2020 12:00:00 AM

  • Thursday, November 24, 2050 4:45:45 PM



ss

specifies a one-digit or two-digit integer that represents the second of the minute. Valid values range from 0 to 59.

AM or PM (optional)

specifies either the time period 00:01 - 12:00 noon (AM) or the time period 12:01 - 12:00 midnight (PM). If this value is not specified and you are using the 12-hour system for specifying time, then the value defaults to AM.

Note:   Do not specify AM or PM if you are using the 24-hour system for specifying time.  [cautionend]


Color Enter color values in one of the following formats:
  • CXrrggbb

  • 0xrrggbb

  • #rrggbb

Here is an explanation of the syntax:

rr

specifies the red component.

gg

specifies the green component.

bb

specifies the blue component.

Each component should be specified as a hexadecimal value that ranges from 00 to FF, where lower values are darker and higher values are brighter.

Bright red
  • CXFF0000

  • 0xFF0000

  • #FF0000

Black

  • CX000000

  • 0x000000

  • #000000

White

  • CXFFFFFF

  • 0xFFFFFF

  • #FFFFFF

Data source Enter the name and location of a data source in the following format:
  • /folder-name-1/<.../folder-name-n/>data-source-name(type)

Here is an explanation of the syntax:

/folder-name-1/<.../folder-name-n/>

specifies the location of the data source.

data-source-name

specifies the name of the data source.

type

is the type of data source. The following values are valid unless otherwise noted: Table, InformationMap, and Cube. Use InformationMap for specifying either relational or OLAP information maps.

  • /Shared Data/Tables/OrionStar/Customers(Table)

  • /Users/MarcelDupree/My Folder/My Information Map(InformationMap)

  • /MyCustomRepository/More Data/Order_Facts(Table)


File or directory Enter the name and location of a file or directory in the following format:
  • directory-specification<filename>

Here is an explanation of the syntax:

directory-specification

specifies the location of the file or directory in the file system of a SAS server.

filename

specifies the name of the file. This value is required only if the prompt is a file prompt. Depending on the operating environment that the SAS server runs in, you might need to put a forward slash (/) or a backslash (\) between the directory specification and the name of the file.

  • C:\Documents and Settings\All Users\Documents\myfile.txt


Data library Enter the name and location of a data library in the following format:
  • /folder-name-1/<.../folder-name-n/>library-name(Library)

Here is an explanation of the syntax:

/folder-name-1/<.../folder-name-n/>

specifies the location of the library.

library-name

specifies the name of the library.

  • /Data/Libraries/Customer Data Library(Library)

  • /MyCustomRepository/More Data/OracleData(Library)


Previous Page | Next Page | Top of Page