Expected results, data and description don't match. In the first observation, from 9Jan2024 to 11Oct2024 is nine month, why do you expect 3M? ... View more

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;   ... View more

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. ... View more

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

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; ... View more

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. ... View more

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? ... View more

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. ... View more

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. ... View more

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. ... View more

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. ... View more

Please post proc contents of the dataset.      ... View more

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. ... View more

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. ... View more