topic Re: my code is wrong temp data set where country is this and mode is that...why? in SAS Programming

my code is wrong temp data set where country is this and mode is that...why?

MarySasbegginer — Mon, 10 Oct 2022 17:59:09 GMT

Using the SAS data set Bicycles, create two temporary SAS data sets as follows: Mountain_USA consists of all observations from Bicycles where Country is USA and Model is Mountain Bike. Road_France consists of all observations from Bicycles where Country is France and Model is Road Bike. Print these two data sets.

here is my code what am i doing wrong?

data Mountain_USA;
set '/home/u62245181/Today/bicycles.sas7bdat';
where Country = "USA" and Model = "Mountain_Bike";
run;

Re: my code is wrong temp data set where country is this and mode is that...why?

Tom — Mon, 10 Oct 2022 18:52:26 GMT

And what happens when you run it? Do you get error messages? If it works how is the result different than you expected.

Does the value of MODEL include the underscore you used in the code? Or the space you used in your description?

Re: my code is wrong temp data set where country is this and mode is that...why?

PaigeMiller — Mon, 10 Oct 2022 18:56:01 GMT

@MarySasbegginer

When you have code that isn't working, SHOW US the log (we need to see the ENTIRE log for this DATA step, not parts of the log).

Re: my code is wrong temp data set where country is this and mode is that...why?

MarySasbegginer — Mon, 10 Oct 2022 22:07:42 GMT

OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

69 data Mountain_USA;

70 set clean.'/home/u62245181/Today/bicycles.sas7bdat';

______

201

ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, ;, CUROBS, END, INDSNAME, KEY, KEYRESET, KEYS,

NOBS, OPEN, POINT, _DATA_, _LAST_, _NULL_.

ERROR 201-322: The option is not recognized and will be ignored.

71 run;

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

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

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

NOTE: DATA statement used (Total process time):

real time 0.00 seconds

user cpu time 0.01 seconds

system cpu time 0.00 seconds

memory 902.09k

OS Memory 24488.00k

Timestamp 10/10/2022 10:05:40 PM

Step Count 30 Switch Count 1

Page Faults 0

Page Reclaims 120

Page Swaps 0

Voluntary Context Switches 8

Involuntary Context Switches 0

Block Input Operations 0

Block Output Operations 16

72 where Country = "USA" and Model = "Mountain_Bike";

_____

180

ERROR 180-322: Statement is not valid or it is used out of proper order.

73 run;

75 title "USA models";

76 proc print data=Mountain_USA noobs;

77 run;

Re: my code is wrong temp data set where country is this and mode is that...why?

Tom — Tue, 11 Oct 2022 00:16:47 GMT

That is NOT the code you originally posted. Can you see the difference?

set clean.'/home/u62245181/Today/bicycles.sas7bdat';
set '/home/u62245181/Today/bicycles.sas7bdat';

You can either reference the data with a quoted physical filename such as one of these :

set '/home/u62245181/Today/bicycles.sas7bdat';
set '/home/u62245181/Today/bicycles';

Or you can create a libref pointing to the directory and use normal SAS syntax instead.

libname clean '/home/u62245181/Today' ;
....
set clean.bicycles;
...