You actually have a directory named FILE(HOME) ?  With all capital letters and parentheses?   Note that ( and ) are normally special characters to Unix so using them as part of a filename could be a problem.    Can you rename the directory first to something more normal?   You might try adding escape characters for the (). Not sure if that really works however. filename in '/home/u50158717/FILE\(HOME\)'; You might try adding quotes around the whole name (inside the quotes needed for SAS to see a character string). filename in '"/home/u50158717/FILE(HOME)"'; So it sounds like you actually do you have directory named macros.   Not sure where you saw something saying you should use  filename in '/home/u50158717/FILE(HOME)'; Perhaps you are just confused by the SAS notation of how to reference a file within a directory as it is done in the INFILE statement in your code: infile in('*') filename=fname ; In that line IN is the name of the FILEREF that was defined previous with the FILENAME statement to point to the directory.  And the stuff inside the parentheses is the name of the individual file from that directory to read.  In this case it is using the * wildcard character to read ALL of the files. ... View more

@johnwassenaar Welcome to the SAS Communities. What's your question? Please never piggy-back on old questions but ask a new one. Eventually reference an older existing discussion if it's related to your question. Also be aware that many people won't look at Excel attachments because of security concerns.  ... View more

Thank you very much Kurt!    This was enlightening (truely!) ... just let me remark, that SASROOT can be resolved automatically by the  filename line ... i.e. the following code also works: filename maccode "!SASROOT/sasautos/dftest.sas"; data _null_; infile maccode; input; put _infile_; run;   ... View more

Hello @MaryA_Marion ,   OK, You have SAS 9.4 Maintenance Level 6. So, no access to Visual Forecasting in SAS VIYA.   Do I understand it correctly that you are a student and not an employee of a company that licensed SAS? How are you using SAS? Is SAS installed on a server somewhere at your university (on-premise installation)?  Or are you in a SAS for Learners program? Or are you using SAS For Academics (formerly University Edition)?   [EDIT] OK, I see the title (subject line) now. You are using SAS on Demand. Let me find out if Forecast Server is available with that offering.   Thanks, Koen ... View more

Here is an updated sas file. ... View more

Hello @MaryA_Marion,   You can create the "Differences of Least Squares Means" table in a separate PROC MIXED step. With suitable preparations, partly depending on your ODS destination, the output will look (almost) like it was created by a single PROC MIXED step.   Example with ODS HTML: %let data = sashelp.cars; %let depvar = mpg_city; %let indvar = origin; ods html file='C:\Temp\mixed_model.html' options(pagebreak='no'); ods select ModelInfo ClassLevels Dimensions Nobs Type3 CovParms FitStatistics SolutionF Tests3 LSMeans; proc mixed data=&data method=type3; class &indvar; model &depvar=&indvar / solution; lsmeans &indvar / alpha=.05 cl; run; title; ods noproctitle; ods select Diffs; proc mixed data=&data; class &indvar; model &depvar=&indvar; lsmeans &indvar / pdiff alpha=.05 cl; lsmeans &indvar / pdiff adjust=BON alpha=0.05 cl; lsmeans &indvar / pdiff adjust=DUNNETT alpha=0.05 cl; lsmeans &indvar / pdiff adjust=GT2 alpha=.05 cl; *Sidaks SMM; lsmeans &indvar / pdiff adjust=SCHEFFE alpha=0.05 cl; lsmeans &indvar / pdiff adjust=SIDAK alpha=.05 cl; lsmeans &indvar / pdiff adjust=simulate(seed=4938371 report) alpha=.05 cl; lsmeans &indvar / pdiff adjust=TUKEY alpha=0.05 cl; run; ods html close; title 'The SAS System'; ods proctitle;   For LISTING output you may want to add options nonumber nodate formdlim=' '; before the second PROC MIXED step and options number date formdlim=''; after it (if these are the option settings that you want to restore). ... View more

I have a similar question. I used the dscf option in proc npar1way and obtained the table below. Then I found the referenced dscf macro and compared outputs. The macro does not give the pvalue so I assumed that the dscf value was gaussian normal and used my calculator to find the pvalue. However looking at the macro, I think it has a studentized range distribution. For a one-way analysis of 40 observations put in 4 groups of 10 I need to input the df. That is 40-03=37? The cutoff at alpha=.05(.05/6?) is 3.63315. The p-value computed below is .053681? Why is not not less than.05? data temp; qalpha=probmc("RANGE",3.74730,.,40,4); qalpha2=1-qalpha; proc print; run; ... View more