PERMANENT FIX TO REMOVE DOLLAR SIGN IN FRONT OF VALUES

Reply
Frequent Contributor
Posts: 107

PERMANENT FIX TO REMOVE DOLLAR SIGN IN FRONT OF VALUES

CAN SOME ONE RECOMMEND ME ANY PERMANENT FIX REMOVING DOLLAR SIGN($) IN FRONT OF RECORDS(Numbers). NOT THE (INFORMAT) AS THE TABLES ARE MOVING FROM SQL TO SAS. THE VARIABLES SHOULD NOT CHANGE FROM NUMERIC TO CHARACTER.

Grand Advisor
Posts: 17,316

Re: PERMANENT FIX TO REMOVE DOLLAR SIGN IN FRONT OF VALUES

DON'T TYPE IN ALL CAPS

What do your variables look like, are they character or numeric to start with? What format/informat and how are you moving the tables that you are having this problem?

Frequent Contributor
Posts: 107

Re: PERMANENT FIX TO REMOVE DOLLAR SIGN IN FRONT OF VALUES

Hi Reeza,

Thanks for your prompt response. The tables were created in SQL.

Ex: The values for a variable called Invoice like

Invoice

$20,000

$3,23,000

I want those values with out $. Tried (Informat Invoice comma11.). Did not work and dollar was still there. Used a complicated process

1) compress(It converted Invoice to character)

2) then used Input( to convert them to numerice)

I know there must be a best way to do it which I am not aware of. What can we do to permanently fix this by creating a piece of code to avoid doing all those stuff above?

Sorry I am very new to SAS.

Grand Advisor
Posts: 17,316

Re: PERMANENT FIX TO REMOVE DOLLAR SIGN IN FRONT OF VALUES

INformat controls how a variable is IMported.

Format is how it is display. Apply a format, such as BEST32. instead to see the result.

data want;

set have;

format var best32.;

run;

Frequent Contributor
Posts: 107

Re: PERMANENT FIX TO REMOVE DOLLAR SIGN IN FRONT OF VALUES

Thanks for your reply.But I want the dollar to be removed and the variable should end up with numeric values. It is possible using compress and Input but I want a piece of code that does that job without writing code again.

Grand Advisor
Posts: 17,316

Re: PERMANENT FIX TO REMOVE DOLLAR SIGN IN FRONT OF VALUES

Then you either need to fix it in your SQL tables or in however you bring it into SAS, which you haven't explained. 

Note that format will leave the variable as numeric and is more efficient than compress/input.

Frequent Contributor
Posts: 107

Re: PERMANENT FIX TO REMOVE DOLLAR SIGN IN FRONT OF VALUES

Hi Reeza.That worked on a sample code that I created. Will try on the original code tomorrow and let you know.Thank you very much.

Ask a Question
Discussion stats
  • 6 replies
  • 1002 views
  • 5 likes
  • 2 in conversation