SAS command bar/ right syntax

[michtka]

Hi,

anyone can help me to write the next syntax in the command bar of the sas toolbox:

OnceI I open a dataset typing in the command bar

vt work.new

I would like to know what is the right syntax I need to type in the command bar to:

1. keep only the variables: age subjid sex race

2. drop the variables: usubjid dob nationality

3. select an specific observation: for example observation number 36,

4. select a number of observations: for example from 36 to 57.

Thanks in advance.

[art297]

I don't think you can do all of that, via commands, with vt.  However, you can with FSView, which can also be called from the command prompt.  Take a look at: http://communities.sas.com/message/102793#102793

[michtka]

Hi, thanks art.

after a quick search, i found this:

1. We can use

columns 'age subjid sex race' .

2. we can use hide 'usubjid dob nationality'

If we want to recovery the variables again we can type unhide in the command var.

3. and 4 is more complicate because I just read that viewtable (VT) dont support first obs= and obs.= statements

Maybe fsview can support it, I need to search more.

[Tom]

You can use a WHERE statement on VT.

Why would you want to look at particular rows unless those rows correspond to particular values of some variables in dataset?

[michtka]

it just to go to the specific row where I found the uniqual value comparing two datasets that have to be the same Tom.

Just, pointed out straight forward the missmatch of the row 4567 in a dataset of 65000 row, for example.