Viewing SAS data table

[bayzid]

Is it possible to view the data table for selected observations? For example, I want to view the following table for drid=1.

[SASKiwi · Accepted solution]

Try a WHERE statement in the command line with VIEWTABLE open: where drid=1  

[bayzid]

Thanks very much.

[BayzidurRahman]

Is it also possible to display only selected variables in the view table?

[PaigeMiller]

You can hide unwanted columns in the Viewtable window. Select the column(s) you want to hide by clicking (plus optionally shift-click or ctrl-click) on the column name(s), then right-click on a column name and select Hide.

You can also create a VIEW which only includes the columns you want to see. Example:

proc sql;
    create view abc as select make,model,msrp,cylinders from sashelp.cars;
quit;

[bayzid]

thanks. It creates a new table.

I was wondering if similar thing could be done from the command line without creating a new table as my dataset is very big.

[PaigeMiller]

---

@bayzid wrote:

thanks. It creates a new table.

I was wondering if similar thing could be done from the command line without creating a new table as my dataset is very big.

---

It does NOT create a new table, it creates a VIEW. These are different. A VIEW doesn't require that a brand new (and very large) data set be created; it allows you to VIEW the data set that already exists in ways that you specify, such as it allows you to view only specified columns of this large data set.

[bayzid]

Thanks. got it

[Ksharp]

keep name
drop name


But it only can handle one variable one time.

[PaigeMiller]

---

@Ksharp wrote:
keep name
drop name


But it only can handle one variable one time.

---

Although this isn't as good a solution (in my opinion) as creating a view, this does work if you want to try it in the command line

hide type;hide drivetrain;hide origin