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

From my point of view the first error is moving data from a dataset into macro variables, which is not necessary in most cases. ... View more

I don't understand the purpose of saving error messages in a database, but maybe i am missing something.  Can you explain what your want to do in more detail? ... View more

Haven't used ODA for a while myself, but i don't remember shared folder or something similar. GitLab or GitHub could be used, depending on general conditions. ... View more

It is even worse: https://communities.sas.com/t5/Administration-and-Deployment/Default-file-encoding-in-EG-8-6-continued/m-p/971665.   I'd love to see an option to set the default encoding. The IT is using utf-8-bom on most code files, the statisticians still have their code in latin1. Avoiding national language chars in labels would render them useless.  ... View more

Reading the logs is recommended. Most times the reason for a failed start can be found there. ... View more

What have you tried? Please post data in usable form: a data step with datalines/cards. Reduce the number of observation, so that every case is present. I would start with proc freq to calculate the percentages. ... View more

Sorry, but i don't understand the problem. SASApp_utf8 is just a name, you have to check the encoding option to verify that unicode is active. Unicode supports both sorbian chars and umlauts.  Can you show the code and the result?     ... View more

@NewUsrStat wrote: Dear all, I'm trying to subset from a dataset all columns (variables) containing a pattern (named "Q1"). I tried the following:   data myout; set mydata; keep Q1; run; but it keeps also Q11,Q12, ... Can anyone help me please? No, the keep statement selects only Q1. Nothing else. ... View more

The issue that should be fixed is the creation of 10 macro variables.  So: what do you want to do after macro chk? ... View more