About Kethy

Kethy · ‎07-01-2013

Awesome explanation.Thank you Uma Shanker Saini.

Kethy · ‎06-30-2013

Can someone please help me in understanding the resolving of values for ''a" in below case? I know like for &a is usa, but the rest are quite confusing with the output that i see in sas log and the way how i understood conceptually. Much help is appreciated if someone can explain me as to how SAS interprets here. %let a=usa; %let usa=america; %let america=states; %put &a &&a &&&a &&&&a &&&&&a &&&&&&a;

Kethy · ‎01-18-2013

Hi, Im a newbie .. i have a basic question on drilling capability. Cascading filters applied on a relational table is it equivalent to drilling facility in web report studio? or Drilling facility can be applied only Cubes.? Thanks in advance.

Kethy · ‎09-27-2012

Thanks Shiva and BIC_User for the info.

Kethy · ‎09-11-2012

Is it not possible to directly use a metadata(sas table object) without using Info Map to create reports in web report studio? Could anyone help me on this question! Thanks in advance.

Kethy · ‎01-02-2012

Hi Doc@Duke, Thanks for your reply. Actually here i'm only trying to import a MS access table which has got 30 millions of records into a SAS dataset using the File-> Import data options in SAS Enterprise guide. But this import fails due too many observations. Is it possible to define prior the total number of observations that a SAS dataset could hold in it.?

Kethy · ‎12-28-2011

Hi, I have a table on MS Acess which has got more than 30 millions records. i want to convert that table into a dataset so tried importing the table in SASEG but since the number of records are more it errors out with a data load error message. Can anybody help me to fix this issue. Thanks!

Kethy · ‎12-03-2011

If i want to transpose a dataset that has millions of records which method wolud be efficient enough either a proc tranpose or arrays. Thanks.

Kethy · ‎10-09-2011

Great! Thanks art.

Kethy · ‎10-09-2011

I mean when the macro %doit() is called irrespective of the positive or negative values being passed as parameters, it should create a macro variable which will hold the start of the month date corresponding to its values passed .

Kethy · ‎10-09-2011

Right now im creating the macro variable "st" based on the i values as st&i, when %doit(1,2) is called st1 and st2 will be the macro variables being created(no issues here) when %doit(-2,-1) is called as pointed out by you and Tom negatives cannot be included in macro variables, so in that case is there any better way where i can create a macro variable(instead of st&i) which would work fine in both the cases [ %doit(1,2) and %doit(-2,-1)]

Kethy · ‎10-09-2011

i want to save the past month start date values into macro variables.how can this be done in above case?

Kethy · ‎10-09-2011

how can i define then for negative values? any suggestion!

Kethy · ‎10-09-2011

i have this below code working fine for positive parameters but throws an error for negative values. could anyone help! %macro doit(m,n); %do i=&m %to &n; %global st&i ; data _null_; st=intnx('month',today(),&i,'b'); call symput("st&i",put(st,date9.)); %end; %mend; %doit(-2,-1) %put &st-1 &st-2;

Online Status	Offline
Date Last Visited	‎09-01-2015 07:11 AM

Re: macro resolving issue

macro resolving issue

doubt in drilling

Re: data source

data source

Import issue

Import issue

array or proc tranpose

macro loop error

macro loop error

Re: macro resolving issue

macro resolving issue

Re: macro resolving issue

macro resolving issue

doubt in drilling

Re: data source

data source

Import issue

Import issue

array or proc tranpose

macro loop error

macro loop error

macro loop error

macro loop error

macro loop error

macro loop error