how to compare two numeric value with macro code using

[uspanchal]

I need to write following same code with using macro code

data test;
do n = 1 to 5;
output;
end;
run;

data comp;
set test;
do k=1 to 3 ;
array d (3);
do i=1 to k ;
if n >= i then d(i) = 1;
end;
output;
end;
run;

[Kurt_Bremser]

There is absolutely nothing that calls for macro programming.

[uspanchal]

not understand from reply. 

[LinusH]

What @Kurt_Bremser is trying to say, is he don't understand why you to make this into macro code - there is no obious need.

So can you please state your objective?

Side note: in macro language, the default behaviour is to treat everything as text, not numerical values.

[ErikLund_Jensen]

@uspanchal 

Would you care to explain your problem. It might be possible to simulate a data step using I/O functions in a macro, but it would be downright stupid to do it, so what are you trying to achieve?

[uspanchal]

I want to compare numeric variable of data set using macro code so I need input how to write macro code for compare numeric value.

[Kurt_Bremser]

Forget your macro obsession. You want to deal with data, not dynamically generated program code, so no macro action is needed.

Comparisons of variables within one dataset is done in a data step (or proc sql), and comparison across different datasets is done with proc compare.

For detailed suggestions/solutions, provide existing data in usable form (data step(s) with datalines), and what you expect out of it.

[uspanchal]

here with attached dataset file HTWT

Write a macro to compare two numeric values.

 Use proc print and Use %if %then %do statement

[PaigeMiller]

---

@uspanchal wrote:

I want to compare numeric variable of data set using macro code so I need input how to write macro code for compare numeric value.

---

Macro language is a text processor, to help you make your code dynamic so it changes as circumstances change. Numeric calculations should be performed in a data step or PROC, not in macro language.

[Astounding]

Macro language can easily compare two numeric values.  If you have two macro variables (in this example, &N and &K), and they both contain integers only, you can use:

%if &n > &k %then %do;

However, so far you do not have any macro variables.  It's not clear what you are trying to compare.

If you need to use macro language, you need to learn macro language.  Read a book.  Take a course.  You cannot learn macro language by asking a question or two on a message board.  To give you some examples ...

What if your macro variables do not contain integers?  Decimal points are not considered integers.  Macro language returns the opposite result for these two comparisons:

%if 10 > 4 %then %do;

%if 10. > 4. %then %do;

While there are ways to handle this, the real message is that you need to learn macro language.  Without that knowledge, any answers you get are dangerous to apply.

Relating to your original post ...

There is no equivalent to a DATA statement in macro language.

There is no equivalent to a SET statement in macro language.

There is no equivalent to an ARRAY statement in macro language.  (Skillful macro programmers can use macro programming statements to mimic the behavior of an array.)

There is no equivalent to an OUTPUT statement in macro language.

%IF %THEN statements almost always have to appear within a macro definition.  (It's not clear that you know what that means, and that would also be basic information you would learn from a book or a course.)

Your first task in tackling your homework is to find out what the question means.  Your .csv file contains no macro variables.  So what are you supposed to compare?

[uspanchal]

thanks a lot very useful information