I followed a quick-start in SAS Studio to open a .flw file, but it is not opening. The doc has a screenshot red underlined .flw file. It is not displaying as sas flow. Please help. ... View more

Hi Team,   I am trying to output the proc freq output of two datasets side by side using ODs PDF, but I am getting the first page as blank.   code :   ods pdf file='path.pdf' style=journal startpage=no; ods layout gridded columns=2 advance=table column _width=(45% 45%);   ods region; title "data1"; proc freq data=table1; table unit*class/nopercent nocum norow nocol; run;   ods region; title "data2"; proc freq data=table2; table unit*class/nopercent nocum norow nocol; run; ods layout end; ods pdf close;   When I run the above code, I get the first page as blank. How do we avoid the black page in the output pdf.       ... View more

I tried using SELECTION=ADJRSQ AIC BIC, but it checks the AIC/BIC for each variable. How can I check the AIC and BIC for the whole model? ... View more

I'm trying to grasp the functional differences between the way SAS calculates its confidence intervals with PROC Surveymeans and a traditional Z-score-based calculation:   PROC Surveymeans produces a wider interval for my data than calculating the interval using the estimated mean, standard error, and Z-score (e.g., ~1.96 for 95%). For reference:  expected 95% CI [44592, 69542] To get the CIs produced by PROC Surveymeans with the Z score method (for this dataset), you would need to use something closer to Z=1.99 rather than 1.96. I found this paper that suggests an adjustment is being applied to CIs produced by PROC Surveymeans to account for unequal weights in the data: https://support.sas.com/resources/papers/proceedings17/0970-2017.pdf. However, the method of adjustment is not detailed therein.  SAS code used to produce these estimates and the CI: proc surveymeans data = DATA nobs sum clsum varsum cvsum nosparse; class DUM; cluster psu; strata stratum; weight wt; var DUM; run;   My questions: Is there information on the correction applied that would cause this difference in CI calculation? The formula used to calculate the bounds of the interval would be ideal. What is the theory/justification behind applying further adjustment to a confidence interval calculation when the error estimates already account for survey design/weights? Thank you! ... View more

Hi there, I have the following dataset of the school where one course is offered at different classrooms. But in this case some classrooms are not full (ROOM_LOAD) for a given course. I wanted to redistribute the students in classrooms where there is still a capacity left and thus clear out a room and make it available for other use.  DATA HAVE; INPUT COURSE $ ROOM_NO $ ROOM_CAPACITY ROOM_LOAD; DATALINES; CHEM101 C101 20 7 CHEM101 C102 20 11 CHEM101 C103 10 8 CHEM101 C104 15 10 BIO302 HB102 22 20 BIO302 HB106 24 12 BIO302 HB902 30 29 BIO302 W102 30 31 BIO302 AB102 40 27 ; RUN;  As a output, I want a table like this which will give me new student number (NEW_ROOM_LOAD) of each room after redistribution and also flag the room that come available (Room_Status). I have about 150 courses. That's why I need help with a dynamic code. Any help will be appreciated. I will really appreciate any help you can provide. Thanks.   COURSE ROOM_NO ROOM_CAPACITY ROOM_LOAD NEW_ROOM_LOAD Room_Status CHEM101 C101 20 7 17   CHEM101 C102 20 11 19   CHEM101 C103 10 8 0 Available CHEM101 C104 15 10 0 Available BIO302 HB102 22 20 20   BIO302 HB106 24 12 0 Available BIO302 HB902 30 29 30   BIO302 W102 30 31 30   BIO302 AB102 40 27 39   ... View more