Hi,   Example, if you have the following format: proc format value $test 'a' = 'Access' 'd' = 'Decline'; run; format example $test.; This will provide the format name $test with a width of 6. If there is a value in the var example such as 'abcdefgh', then it'll be displayed as 'abcdef' and 'gh' will be truncated. How do you set the width of $test or did I misunderstand PROC FORMAT completely when it comes to width?   Thanks!   ... View more

Hi,   For numeric, the default is 8 bytes.   Question 1.: What is the range? When I google this, I see some place say it's 2-8 and some place say it's 3-8?   Question 2: What happens when you need a numeric var to store more than 8 bytes?   For character, the range is 1 to 32,767 bytes.   Question 3: The default size for character var is also 8 bytes? ... View more

Hi,  A sample while loop:   data test; x = 1.5; i=1; do while (i < 5); i = i + x; output; end; run;   The result would have 3 observations with i = 5.5 as the 3rd or last observation.   My question is, how do I make sure that my output is excluding the value N in the DO WHILE condition.  do while (i < n) So, the above would only have 2 observations, with the i = 5.5 observation been excluded. I am asking this as in general, because it seems it'll always include the last observation where it doesn't meet the condition to break the loop. ... View more

Hi,    My answer for Question 6 won't match with the practice question below from SAS official website.I keep getting 1557 for Question 6.   Below is a practice question from SAS official website: Project 3: This project will work with the following program: data work.lowchol work.highchol;   set sashelp.heart;   if cholesterol lt 200 output work.lowchol;   if cholesterol ge 200 output work.highchol;   if cholesterol is missing output work.misschol; run;   This program is intended to:   • Divide the observations of sashelp.heart into three data sets, work.highchol, work.lowchol, and work.misschol   • Only observations with cholesterol below 200 should be in the work.lowchol data set.   • Only Observations with cholesterol that is 200 and above should be in the work.highchol data set.   • Observations with missing cholesterol values should only be in the work.misschol data set.   Fix the errors in the above program. There may be multiple errors in the program. Errors may be syntax errors, program structure errors, or logic errors. In the case of logic errors, the program may not produce an error in the log. After fixing all of the errors in the program, answer the following questions: Question 5: How many observations are in the work.highchol data set? Answer: 3652 Question 6: How many observations are in the work.lowchol data set? Answer: 1405   My version of the corrected code: data work.lowchol work.highchol work.misschol.;   set sashelp.heart;   if cholesterol lt 200 then output work.lowchol;   if cholesterol ge 200 then output work.highchol;   if cholesterol = . then output work.misschol; run; ... View more

Hi,   SAS can store date as a SAS numeric date like 20999. There are a lot of functions to format this value to a readable value like a MM/DD/YYYY format.    My question is, how do you convert a formatted SAS date back to a SAS numeric date?   Thanks! ... View more