Regarding Formula

Reply
Occasional Contributor
Posts: 6

Regarding Formula

I have used Meany Formula SAS.

U have any formula Like Excel Vlookup like formula.

Occasional Contributor
Posts: 6

Re: Regarding Formula

Hi,

I'm run the program in Proc Report after RUN I have received the error Log....................

NOTE 49-169: The meaning of an identifier after a quoted string might change in a future SAS release.  Inserting white space between a quoted string and the succeeding identifier is recommended.

Pls provide the Resolution

Esteemed Advisor
Posts: 6,646

Re: Regarding Formula

Please post code and complete log for the proc report.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Grand Advisor
Posts: 10,210

Re: Regarding Formula

This specific message often comes from something like:

Put "The value of variable y is:"y;

It is only saying that at some time in future the behavior may change from the current. It is not an error but the same program might generate slightly different appearing output sometime in future.

If you have something that looks like that change it to:

Put "The value of variable y is:" y;

(add a space before the variable)

Occasional Contributor
Posts: 6

Re: Regarding Formula

Dear Sir,

Thank you so much for your comments.

I have clear the issue according to your comments.

Esteemed Advisor
Posts: 5,198

Re: Regarding Formula

Please give some example of what you wish to do?

There are many lookup techniques that you can use in SAS, like SQL join, user defined formats, data step key or hash table....

Data never sleeps
Esteemed Advisor
Posts: 6,646

Re: Regarding Formula

DO NOT compare Excel with SAS, they're not even apples and oranges.

Excel is a spreadsheet calculator, SAS is statistics on top of a simple, yet effective database system.

What do you want to achieve?

(and please try to write proper English, as most contributors here are not native English speakers/writers)

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Ask a Question
Discussion stats
  • 6 replies
  • 247 views
  • 1 like
  • 4 in conversation