andreas_lds Tracker

Re: Assign variable values to time intervals

andreas_lds — Thu, 07 May 2026 11:18:21 GMT

Expected results, data and description don't match.

In the first observation, from 9Jan2024 to 11Oct2024 is nine month, why do you expect 3M?

Re: Need help with first.

andreas_lds — Thu, 30 Apr 2026 05:12:56 GMT

It is not clear what you expect to see in the resulting dataset. Here's an example using sashelp.class, sorted by sex and age to display what "not first.variable means:

proc sort data=sashelp.class out=work.class_sorted;
    by Sex Age;
run;

data work.selection;
    set work.class_sorted;
    by Sex Age;
    
    not_first = not first.Age;
    
run;

Re: display of datasets in the data library with timestamp in property

andreas_lds — Wed, 22 Apr 2026 05:54:48 GMT

I don't think this could be done at all, because afaik there aren't any options to add information to the library list. SAS could add such an option, of course. You should contact sas tech support, maybe there is an option i don't see, or they could get in on the wish list for a future release.

Re: Error in writing to text file using put statement

andreas_lds — Thu, 05 Feb 2026 07:30:33 GMT

The code posted does not make any sense at all. Please post the complete data step / macro.

Re: Find client number

andreas_lds — Tue, 03 Feb 2026 11:57:41 GMT

Most likely i overlook a detail of the specs. I am not sure what "As I said the client number should be matching to all Id numbers under the application (This is the criteria)" means exactly: why is "033948333" mapped to 1 and not to 3?

If always the first appearance in tbl2 defined the correct mapping from ID_number to client_number, a feature of hash objects can be used to simplify the code:

data work.want;
    set work.tbl1;

    if _n_ = 1 then do;
        if 0 then set work.tbl2; /* adds variables to the pdv */

        declare hash h(dataset: "work.tbl2", ordered: "yes");
        h.defineKey("ID_number");
        h.defineData("client_number");
        h.defineDone();
    end;

    if h.find() = 0;
run;

Re: problem with ODS in SAS EG 8.3

andreas_lds — Thu, 29 Jan 2026 06:46:49 GMT

One of the interesting differences between EG 7.x and 8.x is the change of the default output type. In the earlier version it was SAS Report, beginning with 8.x it is html.

If you can't provide the code used, please provide at least some more information about what the code does.

Re: How to Sleep/Rest during loops AND FREE all the resouce[not freeze the panel]?

andreas_lds — Mon, 26 Jan 2026 07:02:26 GMT

Please post the code "taking hours to finish". Recent versions of SAS Enterprise Guide don't freeze while executing code, which client do you use?

Re: problem with where clause on numeric

andreas_lds — Wed, 14 Jan 2026 14:23:04 GMT

The number is to large. See https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/hostunx/p12zsdbylnn6c2n1i48z7djr6uzo.htm for details.

The largest integer sas can represent exactly is 9,007,199,254,740,992.

Re: Code to search for .zipx files in a Windows directory and export list to Excel?

andreas_lds — Thu, 18 Dec 2025 06:01:24 GMT

Do you have to use sas to solve the issue?

In Powershell i would use:

Get-ChildItem <PATH>*.xlsx -Recurse | Select-Object -Property FullName | Export-Csv -Path file_list.csv -NoTypeInformation -Encoding UTF8

Output is not a native excel-file, but should run faster.

Re: order of data sets that appear in window

andreas_lds — Wed, 10 Dec 2025 07:20:26 GMT

Two chars are missing in my previous post:

Can't replicate your problem with EG 8.5 or 8.6 - maybe a problem with an older version or with some option set in EG itself.

Re: order of data sets that appear in window

andreas_lds — Tue, 09 Dec 2025 12:54:43 GMT

Can replicate your problem with EG 8.5 or 8.6 - maybe a problem with an older version or with some option set in EG itself.

Re: How to Save Out PLOT from PROC SGPLOT into A PIC FILE with explicit filename and location?!

andreas_lds — Fri, 28 Nov 2025 07:12:07 GMT

Hardly possible to suggest something useful without knowing the code of the macro.

The ods gpath option may be used to set the location images are stored, see https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/grstatug/p0cmojsdkiab8cn1k2qk3rp3a8s0.htm for details.

Re: Improving performance of a CSV export

andreas_lds — Mon, 24 Nov 2025 11:42:42 GMT

Please post proc contents of the dataset.

Re: the highest result needs to be selected if ID has more than one value

andreas_lds — Wed, 19 Nov 2025 11:55:36 GMT

Easy to solve after PDL1 has been converted to a numeric variable.

proc format;
    invalue pdl2num
        "N/A" = .
        "<1" = 0
        other = [best.]
    ;
    value pdlprio
        . = 0
        0 = 1
        1 - 49 = 3
        50 - HIGH = 4
    ;
run;

data fixed;
    set have(rename= (pdl1 = pdl1_str));

    pdl1 = input(pdl1_str, pdl2num.);
    priority = put(pdl1, pdlprio.);
run;

Use the code posted by @LinusH to get the final result.

Re: message -Large results were detected

andreas_lds — Mon, 17 Nov 2025 06:54:45 GMT

You need to disable the creation of the result in Enterprise Guide, and depends on the selected result formats in then config of EG.

To solve the issue open then properties of the program in EG, select "Results", activate "Custom..." and uncheck everything.

Re: Storage full error

andreas_lds — Thu, 13 Nov 2025 08:43:24 GMT

To solve this error contact the responsible system administrator. Anybody else is hardly able to fix a config issue.

Re: Copy the file

andreas_lds — Tue, 28 Oct 2025 11:48:43 GMT

Things to check/do:

- Is sas running local or on a server? If it is running on a server, you can't copy local files.

- Is xcmd enabled?

- Change noxwait to xwait.

- Post the log.

Re: proc sql view vs table

andreas_lds — Wed, 17 Sep 2025 05:27:10 GMT

First thought: looks like a bug.

Second thought: it is logical that the option is ignored.

The options inobs and outobs are processed during the execution of proc sql, but are not included in the code of the created views. The contents of a view is created on accessing the view. Should be noted in the documentation, though.

Re: data sets in work-order

andreas_lds — Mon, 15 Sep 2025 05:30:27 GMT

SAS Studio, Enterprise Guide, Display Manager and even the sas-addon for VS Code display library contents always in alphabetical order. But if you should have access to your work-folder with Windows Explorer, too, so that you use it to display datasets in the required order.

Re: SAS Enterprise Guide multiple values in Prompt

andreas_lds — Mon, 08 Sep 2025 13:09:38 GMT

Using the idea provided by @Tom the following code creates a dataset using the names entered in the prompt:

data work.selected_customer;
    length
        cust_name $ 50
    ;

    %if &resident_customer_count = 1 %then %do;
        cust_name = "&resident_customer";
        output;
    %end;
    %else %do;
        do i = 1 to &resident_customer_count;
            cust_name = symget(cats("resident_customer", i));
            output;
        end;
    %end;

    drop i;
run;

And a small demonstration of the usage together with sashelp.class, because i am to lazy to make up a dataset with four name-variables:

proc sql;
    select c.*
        from sashelp.class as c, work.selected_customer as s
            where find(c.Name, s.cust_Name, 'it')
    ;
quit;