About set_all__

LinusH · ‎07-09-2018

If your key is unique within a year, you could even be fine with a single index. What is your application? End users asking for a one key value at the time? And sub second response times? If you are in a Base SAS libref now, consider SPDE instead - parallel IO and better index management and query plans.

LinusH · ‎04-12-2017

Before jumping to any conclusions you need more information. Add Options msglevel =i fullstimer; This will give more information about basic processing and systems constraints. Proc SQL _method; Will give you the SQL plan.

Reeza · ‎10-21-2016

I assume you're running EG locally? I would contact Tech Support with this issue.

Ksharp · ‎10-04-2016

Yes. There are many ways in SAS can solve the same question. data have; input App ModifiedTime anydtdtm32.; date=datepart(modifiedtime); format modifiedtime datetime. date date9.; cards; 001 09/07/16 11:03:08 001 09/08/16 12:26:15 001 09/08/16 11:04:52 001 09/12/16 09:05:10 002 09/01/16 11:03:08 002 09/02/16 12:26:15 002 09/04/16 11:04:52 002 09/09/16 09:05:10 ; run; data want; merge have have(keep=app date rename=(app=_app date=_date) firstobs=2); output; if app=_app then do; do i=date+1 to _date-1; modifiedtime=dhms(i,1,1,1);output; end; end; drop _: i date; run;

ballardw · ‎09-02-2016

I am always very leery of any inserted summary rows inside a data set. What happens if you run the same summary program later on the same data? Or you run a report procedure like Proc Report that generates summary totals. You have now included the summary into a new summary. At a very minimum I would add an indicator variable to show that the row is indeed some sort of summary and the other rows aren't with appropriate label for the indicator.

Astounding · ‎09-02-2016

Since you have nearly working code, you could tweak it simply: if month = 1 then lastmonth = 12; else lastmonth = month - 1; If you wanted to get into the depths of how SAS works with dates, you could modify your first statement: lastmonth = month( intnx('month', "&sysdate9"d, -1)); As before, that gives you the month number which still has be to converted to the name.

set_all__ · ‎09-02-2016

Using some of Reeza's code but adding 'Today' function: Prev_months_year = year(INTNX('month', today(), -1, 'B'));

Xiaoningdemao · ‎09-01-2016

Dear ballardw, Thank you very much for the dead up!! I modified my code according to you suggestion. Best wishes.

set_all__ · ‎09-01-2016

Try this: proc sql; create table new_sample as select * from total_sample where a.ID in (select ID from selected_3000 ); quit; You don't need to have selected_3000 in the main query and also in the subquery. Since you had it in the main query, it was creating a cartesian product. It was returning 3000 times as many rows as you needed.

Online Status	Offline
Date Last Visited	‎11-08-2022 07:58 AM

Re: Does order of the variables in a composite index matter?

Does order of the variables in a composite index matter?

Proc sql join performance with Index

EG 7.12 How to close "Find" window immediately

Re: Filling the missing dates in column

Re: How to identify previous month full name

Re: what is the best way to create a new variable with sum

Re: How to identify prev month's year

Re: import multiple text file

Re: Anything wrong with this simple proc sql code?

Re: How to identify previous month full name

Re: Character values have been converted to numeric values at the plac...

Re: Assigning random numbers in a particular range

Re: How to create sequential field values in an empty dataset

Re: How to identify previous month full name

Re: How to identify prev month's year

Re: import multiple text file

Re: Does order of the variables in a composite index matter?

Re: Proc sql join performance with Index

Re: EG 7.12 How to close "Find" window immediately

Re: Filling the missing dates in column

Re: what is the best way to create a new variable with sum

Re: How to identify previous month full name

Re: How to identify prev month's year

Re: import multiple text file

Re: Anything wrong with this simple proc sql code?

SAS Analytics Explorers