topic using a variable from a dataset to the other dataset . in SAS Studio

using a variable from a dataset to the other dataset .

Shrutibhatnagar — Fri, 15 Feb 2019 17:19:38 GMT

hello,

plz tell how do i use the variable unique id to the other dataset ?

as it shows the error that i have not referenced it .

1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

73 data test;

74 set class.car_sales(keep= unique_id Manufacturer Model);

ERROR: The variable unique_id in the DROP, KEEP, or RENAME list has never been referenced.

75 run;

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

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

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

NOTE: DATA statement used (Total process time):

real time 0.03 seconds

cpu time 0.02 seconds

77 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

Re: using a variable from a dataset to the other dataset .

Astounding — Fri, 15 Feb 2019 17:54:21 GMT

That error is saying you can't use it because it doesn't exist. If you run this program, you will see that UNIQUE_ID does not appear on the list of variables within the data set:

proc contents data=class.car_sales;

run;

Re: using a variable from a dataset to the other dataset .

ballardw — Fri, 15 Feb 2019 17:58:01 GMT

There is no need to attach SAS program files. Please post code or log entries into a code box opened using the forum's {I} icon:

/*Assignment3*/
/*question 1*/
libname class '/folders/myfolders/mysas';
proc import 
datafile='/folders/myfolders/mysas/car_sales.csv'
dbms=csv  out=class.car_sales replace;

data testdata;
retain org_country;
set class.car_sales;
length org_country $10.;
select (Manufacturer);
when('BMW','Audi','Mercedes') 
org_country=('Germany');
when ('Honda','Toyota')
org_country=('Japan');
when('Cadillac','Chevrolet','Chrysler','Dodge','Ford')
org_country=('US');
when('lincoln','Jaguar','Buick')
org_country=('UK');
when ('Hyundai')
org_country=('south korea');
when('Acura','Lexus')
org_country=('Japan');
otherwise org_country=('others');
end;
run;

/*question2*/
Data test;
length unique_id $20;
Set class.car_sales;
unique_id=catt(model,manufacturer);
run;

/* question3*/
data test;
set class.car_sales(keep= unique_id Manufacturer Model);
run;

The error message is quite clear: the variable UNIQUE_ID does not exist on the data set CLASS.CAR_SALES.

You added a variable name unique_id to data set named TEST in the section labeled question 2. But you do not use that set but go back to the original data class.car_sales that did not have the variable.

Each time you use

data test;

<code>;

run;

You will completely overwrite the previous version of the data set test if there are no syntax errors. Make sure that is what you want to do.

I would suggest:

/*question2*/
Data test;
length unique_id $20;
Set class.car_sales;
unique_id=catt(model,manufacturer);
run;

/* question3*/
data test2;
set test(keep= unique_id Manufacturer Model);
run;

if you actually need two different data sets.

Or if you want a single data set with only those three variables:

/*question2*/
Data test;
   length unique_id $20;
   Set class.car_sales;
   unique_id=catt(model,manufacturer);
   keep  unique_id Manufacturer Model;
run;

Re: using a variable from a dataset to the other dataset .

Shrutibhatnagar — Fri, 15 Feb 2019 18:28:26 GMT

please tell how do i refer the unique_id to the last dataset ??

Re: using a variable from a dataset to the other dataset .

Astounding — Fri, 15 Feb 2019 19:59:40 GMT

The data set TEST contains UNIQUE_ID.

The data set CLASS.CAR_SALES does not.

To use TEST, it must appear on the SET statement, not the DATA statement:

data something_new;

set test;

* Now Unique_ID will be available;

run;

Re: using a variable from a dataset to the other dataset .

Shrutibhatnagar — Sat, 16 Feb 2019 03:47:54 GMT

ok thanks 🙂 i am just a beginner .

Re: using a variable from a dataset to the other dataset .

Astounding — Sat, 16 Feb 2019 15:08:16 GMT

We were all beginners at some point. Good to see you posting your questions.