data study;
input Subj : $3.
Group : $1.
Dose : $4.
Weight : $8.
Subgroup;
x= input(Weight,5.1);
datalines;
001 A Low 220 2
002 A High 90 1
003 B Low 193.6 1
004 B High 165 2
005 A Low 123.4 1
;
Why does X get truncated? X shows up as 22 instead of 220,9
instead of 90 and 19.8 instead of 198? This problem doesnt
happen with the values 193.6 and 123.4.
This does not happen if x is read on the 5. informat instead
of the 5.1 informat
Answer Posted / kumaraswamy maduri
Informat 5.1 or 5.2 tell the SAS processor to allocate
specified number of decimals from right to left of the
value and the remaining to the number.
Informat 5. is good if you have one decimal even this fails
when you have more than one decimal.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How is character variable converted into numeric variable and vice versa?
How do you add a number to a macro variable? : sas-macro
what are the types of interactive display types? : Sas-bi
what are 5 ways to perform a table lookup in sas? : Sas-administrator
What makes sas stand out to be the best over other data analytics tools?
what is ae onset date n what is RDS
What are the different servers in sas? : sas-grid-administration
How will you react when, while consulting a SAS documentation manual to get an answer to a problem, someone says hey, I thought you were supposed to know all that stuff already, and not have to look it up in a book?
Which command is used to save logs in the external file?
What does the RUN statement do?
How would you code a macro statement to produce information on the sas log? This statement can be coded anywhere? : sas-macro
What is the role of administrative users? : sas-grid-administration
explain the proc in sas? : Sas-administrator
Differentiate between format and informat? : sas-grid-administration
What is the use of function Proc summary?