SAS | How to read character using Ampersand(&)

SAS | How to read character of varying length using COLON Modifier

Last Updated : 23 Jul, 2019

We generally face this situation when we have company names or both first and last names of a person in our data set.

We can use a colon modifier “:” to tell SAS to read variable “Name” until there is a space or other delimiter. The $30. refers to the variable as a character variable having max length 30.

data ex1; 
input ID Name :$30. Score; 
cards; 
1 ShubhamMaurya  25 
2 SaurabhPandey  32 
3 NikitaChaudhary  30 
; 
proc print; 
run; 

Output:

The colon modifier is also helpful to read numeric data that contains special characters such as comma(, ).

For example,

1, 000

For example, if you want to read a variable which holds numeric values with the comma in thousands place (or thousand separators) then refer the code below.

data ex2; 
input ID Name:$30. Score fee:$10.; 
cards; 
1 ShubhamMaurya  25 1, 000 
2 SaurabhPandey  32 2, 000 
3 NikitaChaudhary  30 3, 000 
; 
proc print; 
run; 

Output:

In the above program, we have declared “fee” variable with colon modifier to load data and used $ sign to read this variable. It will be stored as a character variable. If you would not use $ sign, it will return missing values. Refer the program below how to store it as a numeric variable.

data ex2; 
input ID Name:$30. Score fee comma5. ; 
cards; 
1 ShubhamMaurya  25 1, 000 
2 SaurabhPandey  32 2, 000 
3 NikitaChaudhary  30 3, 000 
; 
proc print; 
run; 

Output:

Note: comma5 format removes comma and store it as a numeric variable. 5 refers to the width of the input field. To read a bigger number such as 5, 000, 000, you can use comma10.

SAS | How to read character using Ampersand(&)

S

ShubhamMaurya3

Improve

Article Tags :

Similar Reads

How to Create or Modify a Variable in SAS Programming?

This will help you to create or modify a variable. It is common to define a new variable based on the existing variable. Let's create a dataset In the code below, we are creating a dataset named as Example1 which is going to store on WORK(temporary) library. In this dataset, there would be a variabl

SAS | How to read character using Ampersand(&)

We can use ampersand (&) to notify SAS to read the variable until there are two or more spaces encounter as a delimiter. This technique is always useful when the variable contains two or more words. For example: Actual Input: "Geeks for Geeks" Expected Input: "GeeksforGeeks" Example 1: There are

First and last character of each word in a String

Given a string s consisting of multiple words, print the first and last character of each word. If a word contains only one character, print it twice (since the first and last characters are the same).Note: The string will not contain leading or trailing spaces. Examples: Input: s = "Geeks for geeks

SAS | How to specify a list of Variables?

Suppose you have a list of variables. You don't want to type the name of each variable every time to define them within the function or array. You are looking for a shortcut to accomplish this task. Create a dataset with a list of variables data dummy; input a1 a3 a4 a2 a6$ bs$ a5; cards; 2 1 3 5 aa

How to import External Data from Excel or Text file into SAS Programming?

PROC IMPORT: It is a procedure to import external files into SAS. It automates importing process. There is no need to specify the variable type and variable-length to import an external file. It supports various formats of files such as excel, txt, etc. Importing an Excel File into SAS: The main key

How to import data into SAS?

Entering Data Directly: You can enter numbers of lines of data directly in SAS program by using a DATALINES statement. The keywords are as follows: DATA: The DATA step always starts with a DATA statement. The purpose of the DATA statement is to tell SAS that you are creating a new data set i.e. outd

Like Operator in SAS Programming

LIKE Operator: Pattern Matching The LIKE operator used to select data by comparing the values of a character variable to a specified pattern. It is case sensitive. Task 1: To select all students with a name that starts with the letter S. There are two special characters patterns available for specif

SAS | COMPRESS Function with Examples

COMPRESS function is basically used to compress/removes all the spaces/blanks in a character string. In other words, it removes leading, between and trailing spaces from the strings. The COMPRESS function allows null arguments. A null argument is treated as a string that features a length of zero. E

SAS | Delete Empty Rows

Generally, when we import data from external sources such as Excel/CSV files, it loads additional rows that are totally blank. Sometimes empty values in the database also affect the desired output so it's necessary to check missing cases and perform operations accordingly Example: Input: The sample

How to input or read a Character, Word and a Sentence from user in C?

C is a procedural programming language. It was initially developed by Dennis Ritchie as a system programming language to write an operating system. The main features of the C language include low-level access to memory, a simple set of keywords, and a clean style, these features make C language suit