Syntax use

ChuksManuel — Thu, 18 Jul 2019 19:49:55 GMT

Hello programmers,

I have a dataset in the form displayed in the pic and i am trying to select only observation in "Label1" that have the "Mean" and "Std Deviation".

Here's a syntax of the code i've written but i'm getting error messages.

861  Data moment11; set moment1;
862  If 'N''Skewness''Uncorrected SS' 'Coeff Variation' ne. Label1 then delete;
                                      -----------------
                                      388
                                      200
                                      76
ERROR 388-185: Expecting an arithmetic operator.

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

ERROR 76-322: Syntax error, statement will be ignored.

863  run;

NOTE: The SAS System stopped processing this step because of errors.
WARNING: The data set WORK.MOMENT11 may be incomplete.  When this step was stopped there were 0
         observations and 12 variables.
WARNING: Data set WORK.MOMENT11 was not replaced because this step was stopped.
NOTE: DATA statement used (Total process time):
      real time           0.04 seconds
      cpu time            0.04 seconds

Data moment11; set moment1;
If 'N''Skewness''Uncorrected SS' 'Coeff Variation' ne. Label1 then delete;
run;

Please what's wrong with my code? I want to leave only observations with Mean and Std deviation in the dataset.

Re: Syntax use

PaigeMiller — Thu, 18 Jul 2019 19:54:39 GMT

I want to leave only observations with Mean and Std deviation in the dataset.

if label1 in ('Mean','Std Deviation');

Please note that (at least in the above code) capitalization, punctuation, location of spaces, etc. must exactly match the values in LABEL1.

Re: Syntax use

ChuksManuel — Thu, 18 Jul 2019 19:55:52 GMT

You rock. Thanks!

topic Re: Syntax use in SAS Programming

Syntax use

Re: Syntax use

Re: Syntax use