topic Re: "Input" didn't work. in SAS Programming

"Input" didn't work.

dooheekim01 — Wed, 05 Jan 2022 00:10:12 GMT

This is my code;

Data NewClams_2010_2013;
Set tca.claims_2010_2013;
NewClaimNumber=input(Claim_Number, 15.);
run;

But, still the format is Chat.

I have attached the file.

Re: "Input" didn't work.

novinosrin — Wed, 05 Jan 2022 00:24:18 GMT

Hi @dooheekim01 Claim_Number is ought to be character as that is the variable being read. However , check your NewClaimNumber. This should be numeric

Remember, you can't change the metadata i.e. data type of a variable from a dataset that is being read. You are basically assigning its values to a new numeric variable.

Re: "Input" didn't work.

dooheekim01 — Wed, 05 Jan 2022 00:24:43 GMT

Thank you.

Re: "Input" didn't work.

SASKiwi — Wed, 05 Jan 2022 00:36:13 GMT

Unless you are doing calculations on claim number it is best left as character to avoid numeric precision problems. Please be aware that SAS numbers can only hold at most 15 digits accurately so you are right on the border of introducing precision errors.

Re: "Input" didn't work.

Patrick — Wed, 05 Jan 2022 00:50:28 GMT

I'd keep claim_number as character for the reasons @SASKiwi explained.

But "just for fun" and using your code here how you could get to a numerical variable claim_number.

Data NewClams_2010_2013;
  Set tca.claims_2010_2013;
  NewClaimNumber=input(Claim_Number, 15.);
  drop Claim_Number;
  rename NewClaimNumber=Claim_Number;
run;

Re: "Input" didn't work.

Reeza — Wed, 05 Jan 2022 16:17:21 GMT

You've circled the wrong variable.

You named the new numeric variable NewClaimNumber which is at the bottom of the list of variables as numeric.

@dooheekim01 wrote:

This is my code;

Data NewClams_2010_2013;
Set tca.claims_2010_2013;
NewClaimNumber=input(Claim_Number, 15.);
run;

But, still the format is Chat.

I have attached the file.