About set_all__

set_all__ · ‎07-09-2018

The data is not sorted. It could possibly take too much time to sort the 100 million records before I need to kick off the next process in a short monthly production window. However, I am testing this out. I am also going to check if separating this dataset into multiple datasets (by year/multiple years) would make it any faster. Thanks for the suggestion!

set_all__ · ‎07-03-2018

Does the order of the data in a composite index matter? I have a composite index of an 8 character key + 4 character year. The year can only be one of 20 past years, the key can be any combination of letters and numbers. If my data has 100 million rows, approximately 5 million for each year, does it matter if I create a composite index as key+year or year+key? I am wondering if the subsetting of the data by year would make the index (year+key) a bit faster than the other way around.

set_all__ · ‎04-12-2017

I have two datasets - Big (100 million rows) and small (200,000 rows). The Big dataset is indexed by a unique key. I have two queries in sequence doing a left join from the small to the big dataset which looks like this: proc sql; select * from a left join b on a.key=b.key; quit; The first time the query runs for 20-30 minutes, but the second time takes only 2-3 minutes. Why does this happen? Is it possible to do something to reduce the runtime for the first query as well?

set_all__ · ‎10-21-2016

I have EG7.12 HF3 (7.100.2.3444) (32-bit) My system is a Thinkpad with Intel i7, 2.7 GHz with 16 GB ram. When I look at a log, I search for "error" using 'Find' function. When I am analyzing code looking for usage of datasets or variables, I use 'Find' function. My problems is: the find window does not close immediately. It takes anywhere from 2 to 5 seconds to close and it gets pretty frustrating. It is not the kind of response I am looking for when I am editing or analyzing SAS code. I have tried using Escape button, I have tried using the 'Close' button on the window, I have tried pressing 'X' button - but all of them give me the same response. Is there any solution to close the find window immediately?

set_all__ · ‎10-03-2016

Are date and time two different variables or one single variable?

set_all__ · ‎09-02-2016

You can use monname format: month_name=PUT(date,monname.); But be aware that this takes a date value as input. format prev_month $20.; Prev_month = put((INTNX('month', today(), -1, 'B')),monname.);

set_all__ · ‎09-02-2016

proc sql; create table sum_row as select 'all' as trial, sum(treat1) as treat1, sum(treat2) as treat2 from have; quit; proc append base=have data=sum_row; run;

set_all__ · ‎09-02-2016

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

set_all__ · ‎09-01-2016

The initial part of the code creates multiple macro variables: read1,read2.. and dset1,dset2.... and max. So for the %put statement, you should rather list all read<n> and dset<n> macro variables: %put &read1; %put &dset1; %put &max; Or you can use this to list all user defined macro variables: %put _user_; For the macro readin, it is meant to read multiple files. But it seems like you have limited it to read only one file, so it is reading only one file. You can change the macro readin as below: %do i=1 to &max.; instead of %do i=1 to 1; This should make the code read all the .txt files in the folder.

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?

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?

SAS Analytics Explorers