topic Re: Regarding Formula in SAS Programming

Regarding Formula

amit2thakur — Fri, 22 May 2015 05:01:07 GMT

I have used Meany Formula SAS.

U have any formula Like Excel Vlookup like formula.

Re: Regarding Formula

amit2thakur — Mon, 01 Jun 2015 11:21:35 GMT

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

Re: Regarding Formula

LinusH — Mon, 01 Jun 2015 12:08:36 GMT

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....

Re: Regarding Formula

Kurt_Bremser — Mon, 01 Jun 2015 12:12:39 GMT

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)

Re: Regarding Formula

Kurt_Bremser — Mon, 01 Jun 2015 17:31:49 GMT

Please post code and complete log for the proc report.

Re: Regarding Formula

ballardw — Mon, 01 Jun 2015 17:49:49 GMT

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)

Re: Regarding Formula

amit2thakur — Tue, 02 Jun 2015 05:03:17 GMT

Dear Sir,

Thank you so much for your comments.

I have clear the issue according to your comments.