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

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

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

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

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

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

@DLehwidi wrote: I have about million customers in the list, a client requested a name search, so it can be any name in the world , Hunter and Peter was just for the sake of concept I just tried to point you in the right direction, with less success than expected, it seems. The variable resident_customer will always contain the first name entered, only. If more than one name is entered, "hunter" and "peter" in your example, sas will create additional macro-variables, one for each value entered. If the client needs to be able to provide multiple names with each execution of the program, you have to process the variables created by the prompting-framework. I will try to post some useful code later.   ... View more

EG creates a macro variable for each value in the list. With a variable named "cust_name" and two values, %put _user_; returns: GLOBAL CUST_NAME hunter GLOBAL CUST_NAME0 2 GLOBAL CUST_NAME1 hunter GLOBAL CUST_NAME2 peter GLOBAL CUST_NAME_COUNT 2   ADD-ON: To make things a bit more interesting, sas the variables cust_nameX are not created, if only one value is provided, in this case you get cust_name and cust_name_count, only. ... View more

Your are sure that yymmdd10 is the correct informat to read  '2035-07-02'? It could be yyddmm10, too.   ... View more