cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
jojo
‎03-12-2025
  • 69 Posts
  • 0 Likes Given
  • 1 Solutions
  • 0 Likes Received

Re: get the minimum value of one variable

by Obsidian | Level 7 in SAS Programming
‎12-14-2012 02:52 PM
‎12-14-2012 02:52 PM
Thanks! I need to get all records with the mini value, so I created a dataset view and used proc sql to get those records. Thanks very much for your help. ... View more

Re: get the minimum value of one variable

by Obsidian | Level 7 in SAS Programming
‎12-14-2012 12:18 PM
‎12-14-2012 12:18 PM
Thank you for your help. I know this is for exacting the mini from one table, what I need is to get the mini over several hundred tables. ... View more

get the minimum value of one variable

by Obsidian | Level 7 in SAS Programming
‎12-14-2012 01:00 AM
‎12-14-2012 01:00 AM
I need to extract the observation with the minimum value of one variable ( with all other variables for this observation) from over several hundred tables created in a macro program. I can combine these tables and get the observation with the minimum value of the variable, is there any efficient way to do this? Thanks! %macro runit; %do i =1 %to 15;    %do j = 1 %to 15-&i;        %D(&i,&i, &j, &j);run;  *** will create one table;     %end; %end; ... View more

run same macro many time with different parameters

by Obsidian | Level 7 in SAS Programming
‎12-10-2012 03:57 PM
‎12-10-2012 03:57 PM
I need to run the same macro CT 50 times changing just one of the several parameters. A, B, C...... are 50 variables that need to be replaced in the call macro. %CT(param1=data, param2=inv, param3=A); %CT(param1=data, param2=inv, param3=B); %CT(param1=data, param2=inv, param3=C); ..... ... View more

Re: call a macro in another macro

by Obsidian | Level 7 in SAS Programming
‎12-10-2012 03:47 PM
‎12-10-2012 03:47 PM
two dataset variables. the following code gives errors. %macro B (param1, param2);    Code; %mend B; %macro A(param1,param2);      Code…  ***  here to create a dataset and several variables. two sets of dataset varibles x1, x2, y1, y2 (numerical value) are used for macro B;      %B(x1,x2);  *** call macro B twice;      %B(y1,y2);   %mend A; %A(param=n1,param2=n2); ... View more

call a macro in another macro

by Obsidian | Level 7 in SAS Programming
‎12-10-2012 11:15 AM
‎12-10-2012 11:15 AM
I need to call a macro( B ) in another macro(A). in macro A, two variables x1, x2 are created and used as parameters for macro B.  Thanks for your help in advance. %macro B (param1, param2); Code; %mend B; %macro A(x,y);      Code… to create x1, x2;      %B(x1,x2);     %mend A; %A(n1,n2); ... View more

pava isotonoic regression in SAS

by Obsidian | Level 7 in SAS Programming
‎12-08-2012 07:49 PM
‎12-08-2012 07:49 PM
is there a macro or function for pava isotonic regression  in SAS? ... View more

horizontally list all variables

by Obsidian | Level 7 in SAS Data Science
‎11-01-2012 10:22 AM
‎11-01-2012 10:22 AM
there are many variables in the dataset, is there a way to list all variables in a dataset horizontally? ... View more

Re: cumulative sum by group and under some criteria

by Obsidian | Level 7 in SAS Data Science
‎10-25-2012 12:40 PM
‎10-25-2012 12:40 PM
is it possible to include the hash table while reading each observation and find the cumulative sum for each observation? I am trying to use more efficient code, I need to run this on a giant dataset that includes over 500 million obs. Specifically, can the second data step be included in the first step? %let userN = 10; %let p01 = 0.05; %let p02= 0.05; %let p11 = 0.25; %let p12 = 0.25; data s1_A;   do n1 = 2 to &userN-2;     do m1 = 2 to &userN-2 while ((m1 + n1) < &userN-2);              do y1 = 0 to n1-1 ;             do x1 = 0 to m1-1 ;            p11 = x1/m1;                  p12 = y1/n1;                                  if p11 > p12 then do;               p11_final = (m1 * x1/m1 + n1 * y1/n1)/(m1+n1);                  p12_final = p11_final;               end;                                       else do;                        P11_final = p11;               P12_final = p12;                        end;                  term1_p1 = pdf('BINOMIAL', x1, &p11, m1)* pdf('BINOMIAL', y1, &p12, n1);                  term1_p0 = pdf('BINOMIAL', x1, &p01, m1)* pdf('BINOMIAL', y1, &p02, n1);            term1_p0p1 = pdf('BINOMIAL', x1, &p01, m1)* pdf('BINOMIAL', y1, &p12, n1);                  output;            end;      end;       end; end;   run; data s1_B; if _n_=1 then do;       if 0 then set s1_A(rename=(term1_p0=bt1p0 term1_p1=bt1p1 term1_p0p1=bt1p0p1 p12_final=bp12 p11_final=bp11));          dcl hash h(dataset:'s1_A(rename=(term1_p0=bt1p0 term1_p1=bt1p1 term1_p0p1=bt1p0p1 p12_final=bp12 p11_final=bp11))', multidata:'y');          h.definekey('n1','m1');          h.definedata('bp12','bp11', 'bt1p0', 'bt1p1', 'bt1p0p1') ;          h.definedone();   end;     set s1_A;        ct1p0H=0;           ct1p1H=0;           ct1p0p1H=0;           ct1p0L=0;           ct1p1L=0;               ct1p0p1L=0;        rc=h.find();        do rc=0 by 0 while (rc=0);           if bp12<=p12_final then do;              ct1p1H + bt1p1;                       ct1p0H + bt1p0;                       ct1p0p1H + bt1p0p1;                       end;                 if bp11<=p11_final then do;              ct1p1L + bt1p1;                       ct1p0L + bt1p0;                                        ct1p0p1L + bt1p0p1;                       end;           rc=h.find_next();                        end; drop b: rc; if ct1p1H <=0.15 or ct1p1L <= 0.15; run; ... View more

Re: data step with a huge dataset-message 'lack of resources'

by Obsidian | Level 7 in SAS Data Science
‎10-24-2012 03:39 PM
‎10-24-2012 03:39 PM
Thank you, Tom. I won't do proc summary, but need to calculate cumulative sum for each observation within each group (same n, m, n1, m1, x, y, x1, y1)  and need to keep those observations that the cumulative sum is less than a prespecified cutoff. ... View more

Re: data step with a huge dataset-message 'lack of resources'

by Obsidian | Level 7 in SAS Data Science
‎10-24-2012 02:37 PM
‎10-24-2012 02:37 PM
  My hard drive is about 200 GB. This is the error in the log file, the userN = 50, userN need to be up to 80. ERROR: Write to WORK.S2_A.DATA failed. File is full and may be damaged. NOTE: The SAS System stopped processing this step because of errors. NOTE: There were 18914 observations read from the data set WORK.S1_B. WARNING: The data set WORK.S2_A may be incomplete. When this step was stopped there were 656636456 observations and 28 variables. WARNING: Data set WORK.S2_A was not replaced because this step was stopped. NOTE: DATA statement used (Total process time): real time 3:29:41.39 cpu time 36:00.33 ... View more

Re: data step with a huge dataset-message 'lack of resources'

by Obsidian | Level 7 in SAS Data Science
‎10-24-2012 12:13 PM
‎10-24-2012 12:13 PM
this is the code: %let userN = 40; %let p01 = 0.05; %let p02= 0.05; %let p11 = 0.25; %let p12 = 0.25; data s1_A;   do n1 = 2 to &userN-2;     do m1 = 2 to &userN-2 while ((m1 + n1) < &userN-2);              do y1 = 0 to n1-1 ;             do x1 = 0 to m1-1 ;                                   term1_p1 = pdf('BINOMIAL', x1, &p11, m1)* pdf('BINOMIAL', y1, &p12, n1);                  term1_p0 = pdf('BINOMIAL', x1, &p01, m1)* pdf('BINOMIAL', y1, &p02, n1);            term1_p0p1 = pdf('BINOMIAL', x1, &p01, m1)* pdf('BINOMIAL', y1, &p12, n1);                  output;            end;      end;       end; end;   run; data s2_B;      set s1_A;           do n = n1+1 to &userN-(m1+1);                do m = m1+1 to &userN-(n1+1) while (n+m <= &userN);                do y = y1 to n while (y1<=y<n);                     do x = x1 to m while (x1<=x<m);                                                                              term2_p0 = pdf('BINOMIAL', x1, &p01, m1)* pdf('BINOMIAL', y1, &p02, n1)                        *pdf('BINOMIAL', (x-x1), &p01, (m-m1))* pdf('BINOMIAL', (y-y1), &p02, (n-n1));             term2_p1 = pdf('BINOMIAL', x1, &p11, m1)* pdf('BINOMIAL', y1, &p12, n1)                        *pdf('BINOMIAL', (x-x1), &p11, (m-m1))* pdf('BINOMIAL', (y-y1), &p12, (n-n1));             term2_p0p1 = pdf('BINOMIAL', x1, &p01, m1)* pdf('BINOMIAL', y1, &p12, n1)                        *pdf('BINOMIAL', (x-x1), &p01, (m-m1))* pdf('BINOMIAL', (y-y1), &p12, (n-n1));                output;                                  end;           end;                   end;    end; run; ... View more

Re: data step with a huge dataset-message 'lack of resources'

by Obsidian | Level 7 in SAS Data Science
‎10-24-2012 11:25 AM
‎10-24-2012 11:25 AM
Also I need to do other calculations based on this data, I tried to separate the whole data to several subsets, but it's not working, SAS still can't handle it. ... View more

Re: data step with a huge dataset-message 'lack of resources'

by Obsidian | Level 7 in SAS Data Science
‎10-24-2012 11:21 AM
‎10-24-2012 11:21 AM
I need to calculate some probabilities in the data step (see the following code), I removed the calculation to make the code clear in the message above. data A;       set B(keep=n1 m1 x1 y1);  *** about 5000 obs in B;       do n = n1 +1 to &total-(m1-1);           do m = m1+1 to &total-(n1+1) while (n+m <= &total);  *** &total could be 90-100;                do y = y1 to n while (y1<=y<n);                    do x = x1 to m while (x1<=x<m);                term2_p0 = pdf('BINOMIAL', x1, &p01, m1)* pdf('BINOMIAL', y1, &p02, n1)                        *pdf('BINOMIAL', (x-x1), &p01, (m-m1))* pdf('BINOMIAL', (y-y1), &p02, (n-n1));                term2_p1 = pdf('BINOMIAL', x1, &p11, m1)* pdf('BINOMIAL', y1, &p12, n1)                        *pdf('BINOMIAL', (x-x1), &p11, (m-m1))* pdf('BINOMIAL', (y-y1), &p12, (n-n1));                    end; end; end; end; run; ... View more

data step with a huge dataset-message 'lack of resources'

by Obsidian | Level 7 in SAS Data Science
‎10-24-2012 10:58 AM
‎10-24-2012 10:58 AM
I need to run data step for a dataset that may contain over 1000 million obs, it seems that it is too huge for SAS to handle it, it gave a message 'lack of resources' and stoped to process it, Is there any other way to handle this in SAS? this the data I need to create: data A;       set B(keep=n1 m1 x1 y1);  *** about 5000 obs in B;       do n = n1 +1 to &total-(m1-1);           do m = m1+1 to &total-(n1+1) while (n+m <= &total);  *** &total could be 90-100;                do y = y1 to n while (y1<=y<n);                    do x = x1 to m while (x1<=x<m);                    end; end; end; end; run; ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎03-12-2025 07:56 PM
Quick links