topic Re: What error is in my sas syntax ? in Statistical Procedures

Can I get help fixing this SAS syntax error ?

FestusAdejoro — Wed, 13 Jul 2022 14:54:30 GMT

Here is the syntax I tried to run. It shows an error message that I need to include '=' somewhere but I can't figure where and why.

Any effort would be appreciated.

Data gain;

Label v1-v6=gain;

Input Treatment$ Block$ v1-v6;

Cards;

T1 R1 51.64304736 28.60340054 49.6 1.530405121 1.6 17.87712534

T1 R2 45.61911079 25.26693844 52.4 1.297341041 1.51 16.73307181

T1 R3 41.32557044 22.88888639 42.45 1.376310403 1.57 14.57890853

T1 R4 36.79370562 20.37883419 47.9 1.11925154 1.57 12.98014917

T1 R5 52.38605109 29.01492609 44 1.698368637 1.52 19.08876716

T2 R1 44.11789607 24.43546453 56.75 1.181806026 1.6 15.27216533

T2 R2 39.24314426 21.73549841 52.85 1.108883343 1.57 13.8442665

T2 R3 39.80628109 22.04740154 48.65 1.196865307 1.57 14.04293092

T2 R4 36.67429515 20.31269662 44.75 1.17401272 1.51 13.45211697

T2 R5 46.42807171 25.71499552 42.6 1.542159358 1.6 16.0718722

T3 R1 41.21164786 22.82578838 48.5 1.241993957 1.61 14.17750831

T3 R2 36.36072575 20.13902075 49 1.087404909 1.56 12.90962869

T3 R3 33.11588878 18.34181133 52.8 0.936411589 1.54 11.91026709

T3 R4 31.33307271 17.35436762 45.75 0.98654175 1.5 11.56957841

T3 R5 46.86195947 25.9553118 45.8 1.474270386 1.53 16.96425608

T4 R1 44.64555998 24.72772038 55.3 1.219383271 1.5 16.48514692

T4 R2 37.12680959 20.56332962 43.55 1.212976306 1.51 13.61809909

T4 R3 35.85177318 19.85712852 50.1 1.054479527 1.55 12.81105066

T4 R4 36.21592279 20.05881912 43.8 1.178147807 1.6 12.53676195

T4 R5 46.70096601 25.86614278 41 1.596407568 1.55 16.68783405

;

proc univariate plot normal;

title 'gain';

var v1-v6;

run;

Proc MIXED;

CLASS Treatment Block;

MODEL v1-v6 = Treatment/;

RANDOM block Treatment*Block;

LSMEANS Treatment/TDIFF ADJUST= TUKEY;

Run;

Re: What error is in my sas syntax ?

PaigeMiller — Wed, 13 Jul 2022 14:54:47 GMT

Here's the log showing the error

2243  Label v1-v6=gain;
              -
              73
              200
ERROR 73-322: Expecting an =.

ERROR 200-322: The symbol is not recognized and will be ignored.

You cannot use a list of variables, such as v1-v6, in the LABEL statement.

Similarly in PROC MIXED

2303  MODEL v1-v6 = Treatment/;
              -
              73
              200
ERROR 73-322: Expecting an =.
ERROR 200-322: The symbol is not recognized and will be ignored.

You can have only one variable to the left of the equal sign in PROC MIXED.

Re: What error is in my sas syntax ?

ballardw — Wed, 13 Jul 2022 14:58:21 GMT

If you have a syntax error the LOG will show you. If you do not understand what the log tells you then copy the text of the log including the entire procedure or data step code plus all the notes, messages, warnings or errors. The on the forum open a text box using the </> icon above the message window and paste the text.

You have at least one error with the LABEL statement.

Label v1-v6=gain;

Is not valid. the structure of a label statement is

Label variablename="quoted text for the label". You can have multiple variables but each must have it's own variablename='text' component.

Re: What error is in my sas syntax ?

data_null__ — Wed, 13 Jul 2022 15:17:55 GMT

attrib a1-a6 label='Gain';

You can use a SAS-Variable-list in an ATTRIB statement.

PROC MIXED allows only 1 dependent variable. You might consider transposing V1-V6 to rows and using a BY statement.

Re: What error is in my sas syntax ?

FestusAdejoro — Wed, 13 Jul 2022 15:19:41 GMT

Thank you. How do I then handle the model statement?

Re: What error is in my sas syntax ?

DanObermiller — Wed, 13 Jul 2022 15:35:00 GMT

If you take the transpose route, you will have a column that identifies the V1-V6, let's call that column V_ID. The values would then be a column, let's call that GAIN.

Your model statement would be MODEL GAIN = TREATMENT ....

and then you would use BY V_ID.

Re: What error is in my sas syntax ?

Reeza — Wed, 13 Jul 2022 16:04:39 GMT

The method for many models is illustrated in this post:

https://blogs.sas.com/content/iml/2017/02/13/run-1000-regressions.html

Re: What error is in my sas syntax ?

PaigeMiller — Wed, 13 Jul 2022 16:29:49 GMT

In PROC MIXED, you would have to run six models, each with one variable to the left of the equal sign.

Or you could switch to PROC GLM and have six response variables, but this estimates results differently than PROC MIXED.