DATA Step, Macro, Functions and more

Numbers Truncated After Conversion from Character

Accepted Solution Solved
Reply
Contributor
Posts: 24
Accepted Solution

Numbers Truncated After Conversion from Character

[ Edited ]

I'm having a simple issue where my numbers are truncated after using the input function to convert characters to numeric. Perhaps I am missusing the input function or using the wrong informat? Code Below

 

 

data test;
length x $11 y $9;
input x y $;
datalines;
-117.088178 32.706038
;
run;

data test_t;set test;
x_t=input(x,11.6);
y_t=input(y,9.6);
run;

When I print the dataset I would expect:

 

                                                            x                   y                    x_t              y_t  

-117.08817832.706038-117.08817832.706038

 

But I get:

 

     x                   y                    x_t              y_t  
-117.08817832.706038-117.08832.7060
 

 

Any ideas? I'm currently using SAS 9.4 TS1M1


Accepted Solutions
Solution
‎02-10-2017 04:08 PM
PROC Star
Posts: 7,366

Re: Numbers Truncated After Conversion from Character

You are using the input function correctly. Add a format statement when you print the file. e.g.:

 

proc print data=test_t;
  format x_t y_t best32.;
run;

HTH,

Art, CEO, AnalystFinder.com

 

View solution in original post


All Replies
Solution
‎02-10-2017 04:08 PM
PROC Star
Posts: 7,366

Re: Numbers Truncated After Conversion from Character

You are using the input function correctly. Add a format statement when you print the file. e.g.:

 

proc print data=test_t;
  format x_t y_t best32.;
run;

HTH,

Art, CEO, AnalystFinder.com

 

Contributor
Posts: 24

Re: Numbers Truncated After Conversion from Character

Thanks! So the data is stored correctly. It is just the default format for printing the data does not show those extra decimels. 

PROC Star
Posts: 7,366

Re: Numbers Truncated After Conversion from Character

Correct. I would include the format statement while creating the file. Then, procs (like proc print) would always honor it.

 

Art, CEO, AnalystFinder.com

 

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 149 views
  • 1 like
  • 2 in conversation