Experts: Got this question from my big SAS book but could not understand the answer. Which of the following can determine the length of a new variable? a. the length of the variable's first value b. the assignment statement c. the Length statement d. all of the above. The answer is D. I could not figure out why A is also correct. I thought length is determined during compilation stage so before SAS runs into the first value of any variable? Thank you! ... View more

Experts: Another beginner question. I'm writing the results of a proc freq and a proc print to a CSVAll file, as part of my learning exercise. Unlike the PDF, RTF destinations, I got two CSV files, instead of having both (proc freq and proc print) results in one CSV file. Did I do something wrong? If not, is there an option that we can use so the multiple proc step results can go to a single CSV file? Thank you! ods csvall file='Flight.csv'; proc freq data=sasuser.Europe; tables dest*orig /crosslist; run; proc print data=sasuser.Europe; id Dest; var flight revenue; run; ods csvall close; ... View more

Experts: Is it possible to tell SAS to format a numeric value in dollar format without having to specify the w? Sometimes all I want to make sure is to limit the decimal points. If the format is for a cumulative variable (e.g. total payments from a large number of customers), I'm hoping to avoid the trouble of estimating how large the total will be to make sure dollar w.d has enough width. Thank you! ... View more

Experts: How do I modify the proc report code below to show the result sorted by Total Amount descending? I tried to define Amount as a group or order variable, but those two attempts didn't work. Thank you! data work.test; input Fruit$ Amount; datalines; Apple 100 Kiwi 250 Apple 100 Pear 50 Kiwi 300 ; run; proc print data=work.test; run; proc report data=work.test nowd; column fruit amount; Define fruit / group; run; ... View more

Experts: Should we try to avoid using a variable list and the while / until condition together? It looks like the while / until does not kick in till the last variable value anyway. Thanks. data work.Test; Amount=50; do pay_time = 1,2,3,4 while (Amount LE 100); Amount+ 50; output; end; run; proc print data=work.Test; run; data work.Test1; Amount=50; do pay_time = 1,2,3,4 until (Amount GE 100); Amount+ 50; output; end; run; proc print data=work.Test1; run; ... View more

Experts: Another beginner question. Reviewing the weekday function this morning. What is the best way to convert the weekday function result to 'Sunday...' instead of showing 1-7? Every solution I came up with seemed to be too clumsy. One of them was simply a bad idea. I tried to format the weekday result in weekdate3. :-). Thank you! ... View more