topic select all variables whne I open a talbe in SAS Studio

select all variables whne I open a talbe

Ccasagran737 — Fri, 28 Jun 2019 07:32:24 GMT

Hy,

when I open a dataset often sas studion does not select all the variables but only some. If I want to see all the columns in the dataset I have to select them manually. Is there a way to let sas studio show all the columns every time I open a dataset ?

If the problem is not clear please let me know.

Thanks for your help,

Daniele

Re: select all variables whne I open a talbe

koyelghosh — Fri, 28 Jun 2019 09:34:43 GMT

I think if you scroll to the right, you should be able to see all the columns. Since screen width is fixed and limited, only so many columns can be seen at a time. By default Studio outputs 100 rows (you can see rest of rows by clicking arrow at the top) and a few columns.

Re: select all variables whne I open a talbe

Ccasagran737 — Fri, 28 Jun 2019 12:40:41 GMT

Thaks but I mean a different thing.
As you can see in the picutere (red box) sas does not select all the variables when I open the dataset but I have to do it (orange arrows).

Since I lose time doing this, I was wondering if there was a way to automatically display all the variables when the dataset was opened (maybe in the "SAS Preferences").

Thanks!

Re: select all variables whne I open a talbe

koyelghosh — Fri, 28 Jun 2019 13:17:00 GMT

I see your problem. I had a hunch that I was underestimating your problem and I did. I don't have the perfect answer but there is a two step workaround.

In the Columns box (which you highlighted as a red box) ..if you go up it says "Seleziona tutto" .. I guess that means "select all". If you click, it will select all columns and solve the problem. However you are right, you will have to do it for every dataset that you open.

I guess it happens from 33 columns onwards. May be it displays 32 columns only and rest you have to select.

May be this is a default setting in SAS and there may be a way how we can override this.

SAS experts may please comment on this.

Re: select all variables whne I open a talbe

jennifert — Fri, 28 Jun 2019 13:21:38 GMT

HI @Ccasagran737 ,

By default, SAS Studio displays 30 columns, or variables, in the table viewer. Does this data set have more than 30 columns?

You can change the value of the Columns displayed option on Tables page of the Preferences window from 30 to either 50 or 100.

I hope that helps!

Jennifer

Re: select all variables whne I open a talbe

koyelghosh — Fri, 28 Jun 2019 13:30:37 GMT

@jennifert Thank you from my side .. even though I am not the one who asked.

Re: select all variables whne I open a talbe

Ccasagran737 — Fri, 28 Jun 2019 13:31:08 GMT

Hi!

Thanks for your advice but I couldn't find this option.

Coul you send me a screenshot?

Thanks!

Re: select all variables whne I open a talbe

koyelghosh — Fri, 28 Jun 2019 13:33:15 GMT

@jennifert .. Does it also take into account "total" width of all columns? Are there two checks?

One for number of columns and one for total width. Which ever one fails first, it stops displaying onwards.

I am asking this because looking at the height of the scroll bar for columns ..may be there are not 30 columns .. Regardless, I thought I will ask this.

Re: select all variables whne I open a talbe

jennifert — Fri, 28 Jun 2019 13:45:21 GMT

Hi @Ccasagran737 ,

What version of SAS Studio are you running? I've attached a screenshot of the Preferences window in SAS Studio 3.8.

thanks,

Jennifer

Re: select all variables whne I open a talbe

jennifert — Fri, 28 Jun 2019 13:49:28 GMT

Hi @koyelghosh ,

I don't believe there is an option that considers the width of the columns like you describe. You can use the Size grid columns to content option on the General page of the Preferences window to automatically adjust the width of the columns to fit the size of the column content, but that doesn't affect how many columns SAS Studio displays.

thanks,

Jennifer

Re: select all variables whne I open a talbe

Ccasagran737 — Fri, 28 Jun 2019 13:54:42 GMT

Hi,

I'am runing this version: Release: 3.71 (Edizione Enterprise).

Unlukly I can't see this option in my preferece windows. It's a pity because it is very useful also for my collegues.

I've attached the screenshot (it is italian lenguage).

Re: select all variables whne I open a talbe

jennifert — Fri, 28 Jun 2019 14:09:54 GMT

Hi @Ccasagran737 ,

I'm sorry that this is not an option in SAS Studio 3.71. You could use the Select all option at the top of the Columns list to quickly select all of the columns in the data set instead of having to add each column individually.

The documentation about opening and viewing data in SAS Studio 3.71 that talks about this option is here:

Opening and Viewing Data

thanks,

Jennifer

Re: select all variables whne I open a talbe

Ccasagran737 — Fri, 28 Jun 2019 14:31:37 GMT

Ok thanks for your help!