topic Accessing an element of a dataset in SAS Programming

Accessing an element of a dataset

WhiteSquirrel — Mon, 10 Sep 2018 22:54:52 GMT

I want to create a new dataset with only the element in the second row of the second column. Is there a way to do this? I would prefer not to use proc iml

For example, I want to transform data1 to data2

data test1;
 input a b;
 datalines;
10 40 70
50 60 90
18 70 30 
;
run;

data test2;
input c;
datalines;
60
;
run;

Re: Accessing an element of a dataset

ballardw — Mon, 10 Sep 2018 23:01:09 GMT

Pretty peculiar request:

In the dataset options in the second data step FIRSTOBS= is the row number to start reading data, OBS = is the row number to stop reading data.

data test1;
 input a b;
 datalines;
10 40 70
50 60 90
18 70 30 
;
run;

data want;
   set test1 (firstobs=2 obs=2  keep=b);
run;

If you really want the variable to be named C add a rename, either statement or dataset option.