topic Re: Help wiht input funciton in New SAS User

Help wiht input funciton

West26 — Tue, 15 Oct 2019 19:08:18 GMT

data a;
a='1234-01';
b=input(a,best12.);
run;

I need to convert '1234-01' to number format like 1234-01 . Please help.

Re: Help wiht input funciton

Reeza — Tue, 15 Oct 2019 19:10:48 GMT

That's not a number. What do you want to happen with the dash?

Re: Help wiht input funciton

West26 — Tue, 15 Oct 2019 19:22:57 GMT

Well, one set of case numbers are in character format and other set are in numeric format. I need to combine both to one set.

I agree with your statement. Dash has to be included, but now I believe it is not possible.

Thank you.

Re: Help wiht input funciton

mkeintz — Tue, 15 Oct 2019 21:30:03 GMT

If you store the variable as a number you can insert the dash when displaying the number by designing your own format. Let's assume you store you numbers as whole number that can take up to six digits, as in:

proc format; 
  picture myfmti other='9999-99';
run;

data w;   
  format x myfmti.;
  do x=123456,23456,3456;
    put "Numeric " x=comma7.0 " formatted " x=;
  end;
run;

which results in:

458  data w;
459    format x myfmti.;
460    do x=123456,23456,3456;
461      put "Numeric " x=comma7.0 " formatted " x=;
462    end;
463  run;

Numeric x=123,456  formatted x=1234-56
Numeric x=23,456  formatted x=0234-56
Numeric x=3,456  formatted x=0034-56

Instead of storing integers, it might be psychologically easier to store the number as 1234.56, and make a format such that a dash replaces the decimal in the printed value, as in:

proc format;
  picture myfmtd  other='9999-99' (multiplier=100);run;
data w;
  format x myfmtd.;
  do x=1234.56,234.56,34.56;
    put "Numeric " x=7.2 " formatted " x=;
  end;
run;

which generates:

467  data w;
468    format x myfmtd.;
469    do x=1234.56,234.56,34.56;
470      put "Numeric " x=7.2 " formatted " x=;
471    end;
472  run;

Numeric x=1234.56  formatted x=1234-56
Numeric x=234.56  formatted x=0234-56
Numeric x=34.56  formatted x=0034-56

Re: Help wiht input funciton

ballardw — Tue, 15 Oct 2019 23:21:27 GMT

You may want to show us the results of Proc Contents on that "other set" and tell us which of the variables is supposed to match "1234-01" numerically.

Re: Help wiht input funciton

Reeza — Wed, 16 Oct 2019 01:26:57 GMT

Your numeric values will not have a dash unless they have a custom format applied. If that's the case you can strip the dash and use a direct merge. Either way you need to make one look like the other but you've only shown what one value looks like.

Re: Help wiht input funciton

West26 — Sat, 19 Oct 2019 12:18:39 GMT

Hi Reeza,
Thanks for taking time and providing the insights into the issue. The values which have a dash were stored as characters only. I'm able to merge all of those, except the ones with dash. I can't make the other set which is already in numeric format, as character format and merge both, as I need to a lot of count and order by later on. Will try formatting them for now, and see what will happen.

Thanks,
Ravindra

Re: Help wiht input funciton

Reeza — Mon, 21 Oct 2019 05:51:06 GMT

Count and order by don’t require numeric variables.