How do I reset a macro variable in SAS?

To delete SAS macro variables, you can use the %SYMDEL statement or the CALL SYMDEL routine. %SYMDEL and CALL SYMDEL is a data step call routine that is used to delete macro variables from the global symbol table.

What is the maximum length of the macro variable in SAS?

65,534 bytes
Macro variable values have a maximum length of 65,534 bytes. The length of a macro variable is determined by the text assigned to it instead of a specific length declaration. So its length varies with each value that it contains. Macro variables contain only character data.

What does %put mean in SAS?

text. specifies text that is written to the SAS log. Text can be literal text or a text expresson. If text is longer than the current line size, the remainder of the text appears on the next line. The %PUT statement removes leading and trailing blanks from text unless you use a macro quoting function.

How do you clear a variable in SAS?

To delete variables in SAS, you can use the DROP statement in a DATA step. Suppose you want to delete variables x1 , x2 , and x3 in SAS data set old1 and save it to a new SAS data set new1 .

How do you delete a macro variable?

Delete All Macro Variables

1. Define a local macro variable macro_vars_to_delete.
2. Use the SQL procedure to populate the local macro variable.
3. The PUT statements show the macro variables that will be deleted.
4. Use the %SYMDEL statement to delete the macro variables.

How many character long can a macro name be?

When the parent macro variable is called, all raw data values are decoded. This significantly increases the maximum number of characters which can be encoded into a single macro – specifically, this theoretical upper-limit increases from 65,534 to 623,883,680 characters.

How long can a valid SAS variable label be?

32 characters
SAS variable names may be up to 32 characters in length. The first character must begin with an alphabetic character or an underscore. Subsequent characters can be alphabetic characters, numeric digits, or underscores. A variable name may not contain blanks.

How do you resolve a macro variable in SAS?

These examples using text expressions show how to assign the text generated by macro LOCATE or assign the value of the macro variable NAME: x=resolve(‘%locate’); x=resolve(‘&name’); the name of a DATA step variable whose value is a text expression.

What does %include do in SAS?

The %INCLUDE statement executes statements immediately. The INCLUDE command brings the included lines into the SAS Studio Code tab but does not execute them. You must issue the SUBMIT command to execute those lines.

How do you delete in SAS?

Use the DELETE statement to delete one or more data sets from a SAS library. If you want to delete more than one data set, then list the names after the DELETE keyword with a blank space between the names.