About aarony

aarony · ‎01-15-2017

Thx so much. Will do!

aarony · ‎01-15-2017

Hi reeza thx for ur email. Still no difference when I turn everything off...sigh... Is this an unusual problem?

aarony · ‎01-15-2017

Hi reeza, sas is 9.4ts1mo and my windows is 7 pro. Thanks so much!

aarony · ‎01-15-2017

i think it is the view as i am doing the view table? it takes ages to open up work.d1.

aarony · ‎01-15-2017

i essentially double click on data d1 in the work file. super simple and small data. it takes 30+ seconds to actually view table. i am not a sas expert but would really love to get your helps. thank you.

aarony · ‎01-15-2017

hi chrisnz, i am using just work. is that what you mean? i m not opening sashelp. i m just trying to open my data. Thanks so much

aarony · ‎01-15-2017

i just purchased a computer with i7 and 16gb ram etc. for some reason though, when I double click on the data in the explorer tab, the view table takes ages to pop up (30 seconds ish). This is super abnormal because my personal desktop with lesser spec is a lot faster. It opens view table at an instant like most other computers that I used in my life. Did you by any chance know the solution to this?

aarony · ‎01-02-2017

thank you so somuch!!! 🙂 this was very very helpful!

aarony · ‎01-02-2017

Dear Tom, thank you so much for your kind guidance. For some reason, the code is not grabbing the value from most recent date. I am really puzzled why this is. Could it be because of the date format? My date format is YYMMDDN8. I get crazy numbers on my DIFF variable...i.e., 20112614

aarony · ‎01-02-2017

Thanks so much for your guidance. I am super new to this. Do u mind sharing how to do the left join??

aarony · ‎01-02-2017

i am trying something like: proc sql; create table f32 as select a.*, b.* from m2 as a, t3 as b where a.ticker=b.ticker and b.date-a.date=min(b.date-a.date); quit; but this does not work. any one has any insights?

aarony · ‎01-02-2017

Hi Cynthia. They are date variables. Thanks for your reply.

aarony · ‎01-02-2017

i have two variables date1 date2 diff (date2-date1) 20080101 20080104 3 20080101 20071230 -2 how do i calculate the difference date2-date1 as above? i wanted to know how many days over and under date2 is vs date1 thank you.

aarony · ‎01-02-2017

i have a dataset (dataset1). ticker date value a 19991231 1 a 20011231 2 a 20031231 3 i have another dataset (dataset2). ticker date a 20020101 i want to find the most recent date from dataset 1 in reference to dataset 2. (ie., find in the dataset1 the closest recent date to the date in dataset2 to rrive at the following): ticker date value a 20020101 2 could you provide me of your guidance? thx in advance.

aarony · ‎01-02-2017

hi astounding, sorry but would u mind helping me once more? for some reason, i am not getting the value 2. rather i am getting 3. thx much

Online Status	Offline
Date Last Visited	‎02-07-2017 01:19 AM

Re: sas view table really slow

Re: sas view table really slow

Re: sas view table really slow

Re: sas view table really slow

Re: sas view table really slow

Re: sas view table really slow

sas view table really slow

Re: merging by identifying the most recent date relative to the refern...

Re: merging by identifying the most recent date relative to the refern...

Re: merging by identifying the most recent date relative to the refern...

Re: have first year and last year in one row. how do i make a panel?

Re: want to drop variables with same suffix

Re: how do i keep the latest date possible of that year. (rows)

Re: drop variable if the variable starts with 60

Re: dropping variables that are not one word

drop variable if the variable starts with 60

Re: drop variables with same prefix

want to drop variables with same suffix

want to merge the two datas by year but error says they are different ...

Re: sas view table really slow

Re: sas view table really slow

Re: sas view table really slow

Re: sas view table really slow

Re: sas view table really slow

Re: sas view table really slow

sas view table really slow

Re: merging by identifying the most recent date relative to the refern...

Re: merging by identifying the most recent date relative to the refern...

Re: merging by identifying the most recent date relative to the refern...

Re: merging by identifying the most recent date relative to the refern...

Re: how to count days between two variables (negative and positive)

how to count days between two variables (negative and positive)

merging by identifying the most recent date relative to the refernce d...

Re: merging dataset with the nearest earlier date