topic Re: Creating a macro Variable using %Let statement. in SAS Programming

Creating a macro Variable using %Let statement.

rnmishra — Fri, 02 Aug 2013 13:18:58 GMT

Is it possible to create a macro variable this way

%LET i= 40 LT Score LE 60;

So that if I have a data set have

Data have;

INPUT SN Score;

DATALINES;

1 25

2 30

3 80

4 76

5 35

6 50

7 40

8 35

;

And Want,

DATA Want;

SET Have;

Where &I;

RUN;

I made some silly attempts, does not seem to work.

Any help would be highly appreciated!

RichardinOz — Fri, 02 Aug 2013 13:21:47 GMT

Show us the error messages you are getting.

At a guess, it might work with %LET SN = etc etc ;

Richard

rnmishra — Fri, 02 Aug 2013 13:25:39 GMT

This is the error

ERROR: Open code statement recursion detected.

RichardinOz — Fri, 02 Aug 2013 13:31:51 GMT

This error is usually generated when you forget the semicolon on the end of a macro statement.

Close your session and start afresh.

BTW a closer look at your code would lead me to retract my previous "guess".

It should work in a new session.

Richard

rnmishra — Fri, 02 Aug 2013 13:38:43 GMT

Thanks Richard!

Silly me!!!