topic Re: How to resolve Macro variable in infile statement. in SAS Programming

How to resolve Macro variable in infile statement.

Swati24 — Sat, 13 Jul 2019 08:50:38 GMT

I have a macro variable with few values i want to use this variable to create a data set having these values with the help of infile statement. I have tried but I'm getting some error. Please help me out in this and thank you in advance.

%let X = "AU","US","IND";

Data one;
infile &terr dlm = ",";
input A $ @@;
run;

Re: How to resolve Macro variable in infile statement.

Kurt_Bremser — Sat, 13 Jul 2019 10:45:14 GMT

%let X = "AU","US","IND"; /* what for is X defined? It's never used */

Data one;
infile &terr dlm = ","; /* where and how is terr defined? */
input A $ @@;
run;

Please supply:

the log of your code; use the {i} button for this
the statement(s) where &terr is defined
an example of your input file

Re: How to resolve Macro variable in infile statement.

KachiM — Sat, 13 Jul 2019 10:59:08 GMT

Are you trying to get this?

%let X = "AU, US, IND";

Data one;
nw = countw(&X);
do i = 1 to nw;
   A = scan(&X,i);
   output;
end;
keep A;
run;

Re: How to resolve Macro variable in infile statement.

Tom — Sat, 13 Jul 2019 14:58:39 GMT

@Swati24 wrote:

I have a macro variable with few values i want to use this variable to create a data set having these values with the help of infile statement. I have tried but I'm getting some error. Please help me out in this and thank you in advance.

%let X = "AU","US","IND";

Data one;
infile &terr dlm = ",";
input A $ @@;
run;

Look at PROC STREAM. https://documentation.sas.com/?docsetId=proc&docsetTarget=n1sak3n3asxfbqn1aw24lxdvez69.htm&docsetVersion=9.4&locale=en

Or use the "_infile_" trick.

%let X = "AU","US","IND";

data one;
  infile cards dsd ;
  input @;
  _infile_ =symget('x');
  length A $8 ;
  do until(a=' ');
      input A $ @ ;
      if not missing(a) then output;
  end;
cards;
-- this line is ignored --
;

Re: How to resolve Macro variable in infile statement.

Reeza — Sat, 13 Jul 2019 18:35:53 GMT

Why do you have a macro variable X, but then the macro variable &TERR in the INFILE statement. Where is TERR defined?

Re: How to resolve Macro variable in infile statement.

Swati24 — Sun, 14 Jul 2019 06:26:44 GMT

Sry it is not &terr it is &X

%let X = "AU","US","IND"; 

Data one;
infile &X dlm = ",";
input A $ @@;
run;

Re: How to resolve Macro variable in infile statement.

Swati24 — Sun, 14 Jul 2019 06:32:50 GMT

After cards; nothing will be written

Re: How to resolve Macro variable in infile statement.

Kurt_Bremser — Sun, 14 Jul 2019 06:37:00 GMT

Replace &X with the contents of X, and you will see that it creates invalid code (consult the documentation of the infile statement).

If that are the names of three different infiles, you can concatenate the files by using brackets around the filenames.

But I strongly believe that "AU" (for instance) is not the name of an external (text) file in your current working directory.

Please describe in more detail what you want to do.

Re: How to resolve Macro variable in infile statement.

Swati24 — Sun, 14 Jul 2019 06:39:39 GMT

run should be there or not

Re: How to resolve Macro variable in infile statement.

Swati24 — Sun, 14 Jul 2019 06:41:08 GMT

As it is throwing data error Saying

NOTE: LOST CARD.

84 OPTIONS NONOTES 15

A=IND _ERROR_=1 _INFILE_= _N_=1

NOTE: SAS went to a new line when INPUT statement reached past the end of a line.

NOTE: The data set WORK.ONE has 3 observations and 1 variables.

Re: How to resolve Macro variable in infile statement.

Kurt_Bremser — Sun, 14 Jul 2019 08:00:07 GMT

Quote from myself:

"Please describe in more detail what you want to do."

Little bits and pieces like this

@Swati24 wrote:

As it is throwing data error Saying

NOTE: LOST CARD.

84 OPTIONS NONOTES 15

A=IND _ERROR_=1 _INFILE_= _N_=1

NOTE: SAS went to a new line when INPUT statement reached past the end of a line.

NOTE: The data set WORK.ONE has 3 observations and 1 variables.

are not helpful.

Re: How to resolve Macro variable in infile statement.

Ksharp — Sun, 14 Jul 2019 11:26:25 GMT

%let X = "AU","US","IND";

data want;
 do i=1 to countw(symget('x'),',"');
  x=scan(symget('x'),i,',"');
  output;
 end;
run;

Re: How to resolve Macro variable in infile statement.

Tom — Sun, 14 Jul 2019 14:33:44 GMT

@Swati24 wrote:

run should be there or not

You include a RUN or QUIT statement to let SAS (and other programmers) know that you have reached the end of a procedure or data step. But a data step that includes in-line data (signaled by the CARDS statement or as it has been renamed DATALINES) ends when the in-line data ends. Any extra RUN statement after that will not have any effect other than confusing some novice programmers into thinking they can insert additional data step statements between the lines of data and the run statement.