topic Trying to run old glm model (MANOVA) from older version of SAS but doesn't work in SAS Studio in Statistical Procedures

Trying to read data from older version of SAS but doesn't work in SAS Studio

eag14 — Wed, 12 Feb 2020 13:34:30 GMT

I am trying to rerun an old glm model (MANOVA) with code that works in SAS 9.4 but is not working in SAS Studio. Again, this exact code works in older versions of SAS but not this one. I think it may be the data I am inputting that is not getting read correctly, but I don't know what the problem is. Any help is much appreciated! I've attached the original text file with codes as well as screenshots of the output and error messages. Thanks so much!

Eric

ericgriffin742@gmail.com

Trying to run old glm model (MANOVA) from older version of SAS but doesn't work in SAS Studio

eag14 — Thu, 06 Feb 2020 06:13:12 GMT

Hi everyone,

Eric

ericgriffin742@gmail.com

Re: Trying to run old glm model (MANOVA) from older version of SAS but doesn't work in SAS Studio

Kurt_Bremser — Thu, 06 Feb 2020 07:05:14 GMT

Add this statement in the data step that reads the data:

infile cards dlm='09'x dsd truncover;

as you have tabs as delimiters.

Re: Trying to run old glm model (MANOVA) from older version of SAS but doesn't work in SAS Studio

eag14 — Thu, 06 Feb 2020 14:51:33 GMT

Thanks so much for your quick reply. Unfortunately, that still did not work. I attached the new code txt file as well as the error messages.

It says "statement not valid or it is used out of proper order." I should put this code right before the data, correct?

Later it also says "NODATALINES or INFILE statements" (screenshots attached).

Thanks so much again!

Eric

Re: Trying to run old glm model (MANOVA) from older version of SAS but doesn't work in SAS Studio

eag14 — Thu, 06 Feb 2020 15:38:39 GMT

I'm not sure whether this page is relevant to my question, but could the problem be that my data are separated by spaces rather than tabs?

https://communities.sas.com/t5/SAS-Programming/Tab-delimiter-error-with-Datalines/td-p/302748

-Eric ric

Re: Trying to run old glm model (MANOVA) from older version of SAS but doesn't work in SAS Studio

Tom — Thu, 06 Feb 2020 16:20:49 GMT

The first step in your program is reading the data into a dataset.

Get that working first. Then you can work on the actual GLM code.

The problem might be that some editor you used as inserted tabs into your file. (40 years ago editors used to replace spaces with tabs to help save bytes in the documents. A single tab character could replace 2 to 8 space characters.) In SAS Display Manager it would happily replace the tabs with spaces before sending the code to run. But in SAS/Studio it does not provide this service for you and actual tab characters in program files end up being part of the source that SAS reads.

Try telling SAS to expand the tabs in your data lines.

data want;
  infile datalines expandtabs;
  input ...
datalines;
....
;;;;

Or perhaps just save the lines of data to a separate file and have the data step read from that.

data want;
  infile 'myfile.txt' expandtabs ;
  input .... ;
run;

Re: Trying to run old glm model (MANOVA) from older version of SAS but doesn't work in SAS Studio

eag14 — Tue, 11 Feb 2020 04:53:48 GMT

Great, this was really helpful. The model is working now!