About andreas_lds

andreas_lds · ‎09-04-2025

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

andreas_lds · ‎08-21-2025

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

andreas_lds · ‎08-18-2025

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?

andreas_lds · ‎08-15-2025

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.

andreas_lds · ‎08-13-2025

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.

andreas_lds · ‎08-07-2025

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

andreas_lds · ‎08-06-2025

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.

andreas_lds · ‎08-05-2025

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?

andreas_lds · ‎08-01-2025

@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.

andreas_lds · ‎07-31-2025

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

andreas_lds · ‎07-31-2025

If you have to create a report with complex formatting, have a look at the Report Writing Interface. Most layouts can be created, but this takes time.

andreas_lds · ‎07-30-2025

Afaik this won't work with ods text. Try proc odstext instead. Docs: https://documentation.sas.com/doc/de/pgmsascdc/9.4_3.5/odsproc/p01vqfrzpxj3bgn1x9elf98takez.htm

andreas_lds · ‎07-30-2025

Follow-up for https://communities.sas.com/t5/Administration-and-Deployment/Default-file-encoding-in-EG-8-6/td-p/969650 Enterprise Guide 8.6 changes the file encoding on save. If a program, encoded in utf-8, is opened and saved, EG changes the encoding to utf8-bom. Git recognises this as modification, of course. Even worse: SAS Studio changes utf-8-bom to utf-8. Are there any options in EG or Studio to prevent this mess?

andreas_lds · ‎07-29-2025

Posting data as excel-file is not helpful, please post the data as data step using datalines or cards. If the sample_data contains multiple observations, only the value of the first obs will be in &policy. You need ods escapechar= "^"; before using ods text.

andreas_lds · ‎07-23-2025

Replace the %let-statements as they are not necessary at all. Don't overwrite "test" with the data step. The informat-statement changes the informat attribute of a variable and has no effect, unless the variable is used in an input statement. A format changes the appearance of a value, not the value itself. so maybe removing the assigned format solves the issue.

Re: problem with where clause on numeric

Re: Code to search for .zipx files in a Windows directory and export l...

Re: order of data sets that appear in window

Re: order of data sets that appear in window

Re: How to Save Out PLOT from PROC SGPLOT into A PIC FILE with explici...

Re: Improving performance of a CSV export

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

Re: message -Large results were detected

Re: Storage full error

Re: Copy the file

Re: Identifying consecutive values

Re: Copy the file

Fun With SAS and Emoji: What Might a Rebus-Influenced Programming Lang...

Re: Getting bizarre input into a SAS data set

Re: SAS Enterprise Guide multiple values in Prompt

Re: Code to search for .zipx files in a Windows directory and export l...

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

Re: Copy the file

Re: proc sql view vs table

Re: do while is not working

Re: struggle with different date format in a string

Re: do while is not working

Re: SAVE ERROR, WARNING LOG FROM SAS STUDIO TO DATABASE

Re: How do I share SAS codes with other SAS ODA users?

Re: Default file encoding in EG 8.6

Re: faild to start SASMeta- metadata Server Service after a Backup Res...

Re: Allocate Accounts to Different Groups Based on Scoring

Re: SAS-Format

Re: Subset variables from a dataset based on pattern matching

Re: Macro variables not resolving

Re: How to output macro variable value in RTF using ODS TEXT in SAS?

Re: How to output macro variable value in RTF using ODS TEXT in SAS?

Default file encoding in EG 8.6 - continued

Re: How to output macro variable value in RTF using ODS TEXT in SAS?

Re: Reset special numeric missing values to original value to output/e...

CoDe SAS German