topic Re: problem in using select-when in SAS Studio

problem in using select-when

rishabhmehra13 — Wed, 24 Aug 2016 12:54:35 GMT

using select when statements,define a new variable providing the country of origin for each model based on the manufacturer

libname l '/folders/myfolders';
data carselect;
set l.permanent;

select(Manufacturer);
when(Manufacturer="Audi") country="USA";

otherwise country="other";
end;

run;

not getting the desired output,for each model the country should come up

Re: problem in using select-when

Shmuel — Wed, 24 Aug 2016 13:11:55 GMT

1) add LENGTH COUNTRY $n - statement,

otherwise the length will be according to 1st litteral given ("USA" - 3 characters only)

2) change the when statement to:

when ("Audi") country = "USA";

problem using select when

rishabhmehra13 — Wed, 24 Aug 2016 13:13:37 GMT

using select when statements,define a new variable providing the country of origin for each model based on the manufacturer

libname l '/folders/myfolders';
data carselect;
set l.permanent;

select(Manufacturer);
when(Manufacturer="Audi") country="USA";

otherwise country="other";
end;

run;

not getting the desire output for each manufacturer.I want to display country for each manufacturer based on the manufacturer.

Re: problem in using select-when

RW9 — Wed, 24 Aug 2016 13:19:14 GMT

You can use the {i} above your post to post in code retaining the formatting. Code readability is very important:

libname l '/folders/myfolders';

data carselect;
 set sashelp.cars;
 length country $10;
 select(make);
 when("Audi") country="USA";
 otherwise country="other";
 end;
run;

Audi are german by the way 🐵

Re: problem in using select-when

rishabhmehra13 — Wed, 24 Aug 2016 13:27:21 GMT

libname l '/folders/myfolders';
data carselect;
set l.permanent;

select(Manufacturer);
LENGTH country $n;
when("Audi","Acura") country="USA";

otherwise country="other";
end;

run;

log

1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

56 libname l '/folders/myfolders';

NOTE: Libref L was successfully assigned as follows:

Engine: V9

Physical Name: /folders/myfolders

57 data carselect;

58 set l.permanent;

60 select(Manufacturer);

61 LENGTH country $n;

391

202

ERROR 391-185: Expecting a variable length specification.

ERROR 202-322: The option or parameter is not recognized and will be ignored.

62 when("Audi","Acura") country="USA";

65 otherwise country="other";

66 end;

68 run;

NOTE: The SAS System stopped processing this step because of errors.

WARNING: The data set WORK.CARSELECT may be incomplete. When this step was stopped there were 0 observations and 16 variables.

WARNING: Data set WORK.CARSELECT 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

70 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

Re: problem in using select-when

Reeza — Wed, 24 Aug 2016 13:37:39 GMT

The length statement goes outside the select-when code block and you need to fill in a value for N, it's not n.

Re: problem in using select-when

Kurt_Bremser — Wed, 24 Aug 2016 13:47:16 GMT

data carselect;
set sashelp.cars;
length country $5;
select(Make);
  when("Audi","Acura") country="USA";
  otherwise country="other";
end;
run;

Re: problem in using select-when

rishabhmehra13 — Wed, 24 Aug 2016 13:54:27 GMT

and if i want ot include different manufacturers and display the country for them,then how do i do it,

for example for bmw country is germany, how do i do it.Can you give an example

Re: problem in using select-when

Reeza — Wed, 24 Aug 2016 14:00:05 GMT

Add another WHEN line.

The documentation has various examples.

http://support.sas.com/documentation/cdl/en/lestmtsref/68024/HTML/default/viewer.htm#p09213s9jc2t99n1vx0omk2rh9ps.htm

Re: problem in using select-when

Kurt_Bremser — Wed, 24 Aug 2016 14:00:37 GMT

@rishabhmehra13 wrote:

and if i want ot include different manufacturers and display the country for them,then how do i do it,

for example for bmw country is germany, how do i do it.Can you give an example

- increase the length of the target variable so it is sufficient for all counrtry names

- add aditional when clauses within the select block

Re: problem in using select-when

rishabhmehra13 — Wed, 24 Aug 2016 14:02:49 GMT

libname l '/folders/myfolders';
data carselect;
set l.permanent;

select(Manufacturer);
LENGTH country $10;
when("Audi","Acura") country="USA";
when("Bmw") country="germany";

otherwise country="other";
end;

run;

not getting the output for bmw, it is shwoing country as other only.

Re: problem in using select-when

Reeza — Wed, 24 Aug 2016 14:05:44 GMT

Comparison is case sensitive.

Bmw is not the same as BMW.

Re: problem in using select-when

rishabhmehra13 — Wed, 24 Aug 2016 14:25:09 GMT

libname l '/folders/myfolders';
data carselect;
set l.permanent;

select(Manufacturer);
LENGTH country $15;
when("Honda","Lexus","Mitsubis","Infiniti") country="Japan";
when("Hyundai") country=""SouthKorea";
when("BMW","Audi"," Mercedes") country="germany";
when("Jaguar") country="India";

when("Acura","Buick","Cadillac","Chevrole","Chrysler","Dodge","Ford","Jeep","Lincoln") country="USA";

otherwise country="other";
end;

run;

Can you check upon this

Log

57 data carselect;

58 set l.permanent;

60 select(Manufacturer);

61 LENGTH country $15;

62 when("Honda","Lexus","Mitsubis","Infiniti") country="Japan";

63 when("Hyundai") country=""SouthKorea";

__________

388

64 when("BMW","Audi","Mercedes") country="germany";

___ ____________ ________

49 49 49

65 when("Jaguar") country="India";

____________ ________

49 49

NOTE 49-169: The meaning of an identifier after a quoted string might change in a future SAS release. Inserting white space

between a quoted string and the succeeding identifier is recommended.

ERROR 388-185: Expecting an arithmetic operator.

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

67 when("Acura","Buick","Cadillac","Chevrole","Chrysler","Dodge","Ford","Jeep","Lincoln") country="USA";

___ ___ ___ ___ ___ ___ ____________ _____________________

49 49 49 49 49 49 49 49

NOTE 49-169: The meaning of an identifier after a quoted string might change in a future SAS release. Inserting white space

between a quoted string and the succeeding identifier is recommended.

71 otherwise country="other";

72 end;

74 run;

76 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

77 ODS HTML CLOSE;

78 &GRAPHTERM; ;*';*";*/;RUN;

NOTE: The SAS System stopped processing this step because of errors.

WARNING: The data set WORK.CARSELECT may be incomplete. When this step was stopped there were 0 observations and 16 variables.

WARNING: Data set WORK.CARSELECT was not replaced because this step was stopped.

NOTE: DATA statement used (Total process time):

real time 0.06 seconds

cpu time 0.06 seconds

78 ! QUIT;

79 QUIT;RUN;

80 ODS HTML5 (ID=WEB) CLOSE;

82 ODS RTF (ID=WEB) CLOSE;

83 ODS PDF (ID=WEB) CLOSE;

NOTE: ODS PDF(WEB) printed no output.

(This sometimes results from failing to place a RUN statement before the ODS PDF(WEB) CLOSE statement.)

84 FILENAME _GSFNAME;

NOTE: Fileref _GSFNAME has been deassigned.

85 DATA _NULL_;

86 RUN;

NOTE: DATA statement used (Total process time):

real time 0.01 seconds

cpu time 0.01 seconds

87 OPTIONS NOTES STIMER SOURCE SYNTAXCHECK;

Re: problem in using select-when

Reeza — Wed, 24 Aug 2016 17:55:27 GMT

Length statement goes outside the select block.

Re: problem in using select-when

Kurt_Bremser — Thu, 25 Aug 2016 06:10:26 GMT

The enhanced editor of SAS quickly shows the location of the error.

When program code suddenly appears in the color of string literals, you have an unmatched quote.

libname l '/folders/myfolders';
data carselect;
set l.permanent;
length country $15;
select(Manufacturer);
  when("Honda","Lexus","Mitsubis","Infiniti") country="Japan";
  when("Hyundai") country=""SouthKorea";
  when("BMW","Audi"," Mercedes") country="germany";
  when("Jaguar") country="India";
  when ("Acura","Buick","Cadillac","Chevrole","Chrysler","Dodge","Ford","Jeep","Lincoln") country="USA";
  otherwise country="other";
end;
run;

vs.

data carselect;
set l.permanent;
length country $15;
select(Manufacturer);
  when("Honda","Lexus","Mitsubis","Infiniti") country="Japan";
  when("Hyundai") country="SouthKorea";
  when("BMW","Audi"," Mercedes") country="germany";
  when("Jaguar") country="India";
  when("Acura","Buick","Cadillac","Chevrole","Chrysler","Dodge","Ford","Jeep","Lincoln") country="USA";
  otherwise country="other";
end;
run;

Two consecutive double quotes before SouthKorea.

Re: problem in using select-when

Kurt_Bremser — Thu, 25 Aug 2016 06:12:00 GMT

And for better readability, DON'T WRITE THE LENGTH STATEMENT INTO THE SELECT BLOCK.

There. You were told three times.