About andreas_lds

andreas_lds · ‎01-13-2023

One solution: proc freq for the calculation and and data step merge to add the variable. proc freq data=have noprint; by cluster; table ab / out=count(where=(Ab ='yes')); run; data want; merge have count(keep= cluster percent rename=(percent = value)); by cluster; if first.cluster then value = value / 100; run;

andreas_lds · ‎01-13-2023

Please post the data in usable form.

andreas_lds · ‎01-13-2023

Storing data in macro variable often leads to unnecessary complexity in the following steps. You may want to explain the next steps, so that we could suggest a better approach.

andreas_lds · ‎01-12-2023

@thanikondharish wrote: I have copied some text from Excel and pasted into sas Please define "unexpected".

andreas_lds · ‎01-10-2023

I don't know any way to extract the information using code. While using the old "metabrowse" in the display manager (classic sas programming tool) i wasn't able to find anything useful. Maybe @PaulHomes or @MichelleHomes have an idea.

andreas_lds · ‎01-10-2023

This should work, (EDIT:but only for the first part of your task): data want; set have; length lag_sum v0 - v249 8; retain v0 - v249; array lags[0:249] v0 - v249; if _n_ > dim(lags) then do; lag_sum = sum(of lags[*]); end; lags[mod(_n_ - 1, dim(lags))] = value; drop v0 - v249; run;

andreas_lds · ‎01-09-2023

Please post examples of all datasets in usable form and show the expected result of merging those datasets.

andreas_lds · ‎01-05-2023

Depends on the application used to execute code. Run %put _all_; to get all macro-variable, in SAS Studio and Display Manager there should be a variable named "_SASPROGRAMFILE" pointing to the path of the current program. Using string function to extract the path shouldn't be difficult. In EG 8.3 I see that variable, too.

andreas_lds · ‎01-03-2023

Which encoding is used to send the mail?

andreas_lds · ‎01-02-2023

Compared to https://en.wikipedia.org/wiki/Whitespace_(programming_language) or https://en.wikipedia.org/wiki/Brain**bleep** the code is easier to read, but compared to https://en.wikipedia.org/wiki/Assembly_language the runtime is worse.

andreas_lds · ‎01-02-2023

Talk to the sas admins, the email host needs to be configured. I don't think that those options can be changed in an active session.

andreas_lds · ‎12-30-2022

This seems to be a datetime variable, that is a numeric variable with a format attached displaying the value as date and time. Maybe it is a string. Impossible to know without seeing the result of proc contents of the dataset containing the variable.

andreas_lds · ‎12-30-2022

And the question is?

andreas_lds · ‎12-29-2022

Is the sas session running on your computer or on a server? If it is not running on your computer, you have to move the file to a location that is accessible by the sas server.

andreas_lds · ‎12-29-2022

Don't use proc import, write a data step reading the file.

Re: problem with ODS in SAS EG 8.3

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

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

Fix ""buggish-like" behavior of DOPEN() and DNUM() functions.

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

Re: Identifying consecutive values

Re: Copy the file

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

Re: problem with ODS in SAS EG 8.3

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: How to assign a proportion to a cluster in multilevel

Re: Extend Dates to the existing SAS Dataset

Re: Create multiple macro variables to store counts

Re: how to find unexpected characters in a string

Re: How to extract SAS Management console information (SASApp - Worksp...

Re: Calculate sum of the specific number of row before and after each ...

Re: Narrow to Wide

Re: Find Path of SAS program

Re: sending emails in Hebrew

Re: General SAS

Re: Sending email from SAS

Re: month of time

Re: Sunday for every year 1st JAN

Re: import unsuccessful. see sas log for details.

Re: Blanks in column name

CoDe SAS German