topic How to view a specific number of record in viewtable? in SAS Programming

How to view a specific number of record in viewtable?

DrAbhijeetSafai — Tue, 27 Feb 2024 07:48:24 GMT

I have a dataset which has say one lakh records. Now when I have to go to record number 13744, I have to scroll down to that record. I want to ask if there is any better way to directly go that recored?

In editor, if one has to go to line number 537, one can use ctrl+g and type 537 there and we can directly go that line number. I want to ask if there is anything similar for viewtable.

Thanks in advance.

- Dr. Abhijeet Safai

Re: How to view a specific number of record in viewtable?

FreelanceReinh — Tue, 27 Feb 2024 09:20:24 GMT

Hello @DrAbhijeetSafai,

For VIEWTABLE see ballardw's solution Re: In VIEWTABLE, How Can I Directly Go to Certain Observation? .

Personally I prefer the SAS Universal Viewer (see https://support.sas.com/downloads/browse.htm?fil=&cat=74) in those rare situations when I want to scroll through a dataset. I'm using version 1.42 (which is not the most recent one) and it offers the "Go to row [number]" feature:

SAS Universal Viewer (version 1.42)

Whether this field is available, however, depends on the "Data Paging" settings. For smaller (!) datasets you may need to reduce the number of observations per page (see menu Tools → Options → Paging). Also, after "Go to row n" the nth row (observation) is the first of the page, so if you actually want to see, e.g., rows n ± 10, you should better "Go to row n−10".

Re: How to view a specific number of record in viewtable?

DrAbhijeetSafai — Tue, 27 Feb 2024 09:46:37 GMT

Thank you @FreelanceReinh for the information. I wanted this to happen in work library, so Universal Viewer will not work there. However, another thing which you pointed out helped.

You brought my attention to ballardw's solution Re: In VIEWTABLE, How Can I Directly Go to Certain Observation? again. I had read it many many times but was not able to understand it. This time I got to know why I was not able to understand it.

I was not able to understand the meaning of command line. It can be enabled from Tools > Options > Preferences > View. Once this command line is enabled, use of forward on command line was the think I was looking for.

Your information about Tools > Options etc., helped me to look for it and that helped to understand command line and after that ballardw's solution made sense. Thanks to ballardw and to you @FreelanceReinh !

- Dr. Abhijeet Safai

Re: How to view a specific number of record in viewtable?

FreelanceReinh — Tue, 27 Feb 2024 10:03:24 GMT

@DrAbhijeetSafai wrote:

I wanted this to happen in work library, so Universal Viewer will not work there.

Why not? You just need to know the path to the directory, which you can retrieve, e.g., from the WORK= system option:

%put %sysfunc(getoption(work));

Re: How to view a specific number of record in viewtable?

DrAbhijeetSafai — Tue, 27 Feb 2024 10:17:02 GMT

Interesting! Thanks! 🙂

- Dr. Abhijeet Safai

Re: How to view a specific number of record in viewtable?

DrAbhijeetSafai — Wed, 10 Apr 2024 10:36:11 GMT

Hi @FreelanceReinh ,

Greetings!

I tried using what you had shared.

%put %sysfunc(getoption(work));

The statement is giving me the current location of the work folder, which is in SAS Temporary Files folder on C drive.

I am able to understand that this path needs to be changed to other path. And files can be accessed from that folder where I can use SAS Universal Viewer.

But I am not able to understand how to set this path. I tried following things:

libname sandbox "Path of the folder";
options work = sandbox;

But that is not working.

Thanks in advance.

Thanking you,

Yours sincerely,

- Dr. Abhijeet Safai

Re: How to view a specific number of record in viewtable?

FreelanceReinh — Wed, 10 Apr 2024 11:04:29 GMT

Hi @DrAbhijeetSafai,

I answered this question last week in your more recent thread: https://communities.sas.com/t5/SAS-Programming/How-to-copy-values-of-a-column-in-SAS-viewtable/m-p/923170/highlight/true#M363472

Re: How to view a specific number of record in viewtable?

DrAbhijeetSafai — Wed, 10 Apr 2024 12:00:55 GMT

Yes @FreelanceReinh , to which, I had asked a further query here(same as the query above), below the same thread. Please let me know if I am missing something while using 'options work' statement etc. Thanks in advance.

Thanking you,

Yours sincerely,

- Dr. Abhijeet Safai

Re: How to view a specific number of record in viewtable?

FreelanceReinh — Wed, 10 Apr 2024 12:17:41 GMT

@DrAbhijeetSafai wrote:

Yes @FreelanceReinh , which, I had asked a further query here, below the same thread.

The answer I linked to was the reply to that further query.

Please let me know if I am missing something while using 'options work' statement etc.

The WORK= system option is one of those options which cannot be changed via the OPTIONS statement. (Note that "OPTIONS statement" is not listed in section "Valid in:" at the top of the documentation of the option.) This is because using an OPTIONS statement requires a running SAS session, which in turn needs an established WORK library. Luckily, you don't need to change the WORK= system option, as explained in my reply of last week starting with "There is no need to change anything. ..."

Re: How to view a specific number of record in viewtable?

DrAbhijeetSafai — Wed, 10 Apr 2024 12:18:03 GMT

@FreelanceReinh Thank you very very much!

I understood now that what you mean to say was to find out where the work files are stored on the computer by using

%put %sysfunc(getoption(work));

to find out 'path' of these work folder files.

Once found out, going opening that file in SAS Universal viewer is expected.

This really helped me to understand it in detail. The 'App Data' folder insider the folder of name of users is generally hidden (it needs to be made unhide).

So finally I was able to view the files in work folder by using SAS Universal Viewer. Thank you for your patience.

Thanks once again!

- Dr. Abhijeet Safai