topic Re: Defining Variables for first time in SAS Programming

Defining Variables for first time

edasdfasdfasdfa — Sat, 19 Jun 2021 13:46:44 GMT

So if you have many variables, how can you define them without having to write out each one in the input statement? I know that once you have them defined initially you can use variable lists and there are many other options like using _ALL_ , _NUMERIC_ etc, but how about initially. Do you have to type out 20 different variables?

Re: Defining Variables for first time

Norman21 — Sat, 19 Jun 2021 14:02:10 GMT

You might find this discussion useful:

https://communities.sas.com/t5/SAS-Programming/Assigning-Multiple-Variables/td-p/582197

Re: Defining Variables for first time

Astounding — Sat, 19 Jun 2021 17:39:10 GMT

SAS doesn't know the variable names you want to use unless you tell it. But if there is a pattern to the variable names, you can define them on the INPUT statement. For example:

input @21 (q1-q20) (2. 1.);

This defines 20 variables, the odd-numbered variables being read from 2 characters of the input data line, and the even-numbered variables being read from 1 character. So Q1 comes from columns 21-22, Q2 from column 23, Q3 from columns 24-25 etc.

While there are many variations possible on this theme, you would need to spell out some detail. For a more specific answer we would need to know about what the variable names are, as well as where they appear on the raw data line. It might help to know whether you have an electronic list of the variable names, and what that list looks like (such as how wide they are and whether they are character or numeric). If you have this information, there are a variety of ways available to provide that information to a SAS program. But if you don't have it, there's no way for SAS to know.