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.    ... View more

The question : create results.output36 from cleandata36 Ensure that all values for variable Kilograms are between 40 and 200, inclusively. If the value is missing or out of range, replace the value with the MEDIAN Kilograms value for the respective group (A,B) calculated in step 2. The answer is : data results.output36; set cleandata36; if Kilograms < 40 or Kilograms > 200 then do; if group='A' then kilograms=79; else kilograms=89; end; run;   My question is that: if Kilograms <40 or Kilograms > 200 then do; else group='A' then kilograms=79; didn't work. My question is why I should not use 'else' in red. It is hard to understand. Thank you so much for your help.  ... View more

Would you mind letting me know the difference of those two codes? I really don't know functionally what the difference is / what makes the difference of the 2 observations.   1)  data cleandata36; set cert.input36; if upcase(Group) in ('A', 'B') then do; end; run; proc contents data=cleandata36; run;   2)  data cleandata36; set cert.input36; if upcase(Group) in ('A', 'B'); run; proc contents data=cleandata36; run;   "Then do" is one difference. So, the only one difference of two codes is 'observation' 1)  Observations 5000 2)  Observations 4992   Thank you.  ... View more

I am still learning SAS.  There was no "libname.sas" in EPG1VS. I am on the Lesson 6. It is required to move to the next question. But I can't find it. Please help me.  ... View more

data storm_new; set pg1.storm_damage; drop Summary; YearsPassed=yrdif(Date, today(), "age"); Anniversary=mdy(month(Date), day(Date), year(today())); format YearPassed 4.1 Date Anniversary mmddyy10.; format Cost dollar20. YearPassed 4.; run;   YearPassed 4. didn't work.  Still it shows like this " 15.084931507   I don't know why "YearPassed 4." didn't work in the statement. Please help me.  ... View more