Thanks all And i'll try options suggested by you all Regards ... View more

Can anybody assist me with regard to Proc Sort Optimisation ? ... View more

And total variables are 30 ... View more

Hi There are about to sort 2 variables Dataset capacity is 3 GB Observation number is more than 1.5 million System capacity is 4 GB in specific drive where only we are working  And actual time is more than 3 to 4 hrs. ... View more

Thanks for help I learned so many new concepts from you ... View more

Yes Sir you are right that in your code as the condition is satisfied, other will be disregarded But in this case, we need all the IF's statement to execute If i use IF-THEN/ELSE, only first time SAS will execute the statement as the condition is true and second ELSE statement won't execute So collasping will not be done in all the regions I may be wrong in SAS concepts but i got the output just because of you sir Thanks again Nice to Meet you ... View more

The code is as follow if region26 eq 1  then do;if marriage in (2, 5) then marriage=2; end; if region26 eq 1  then do;if marriage in (3, 4) then marriage=3; end; if region26 eq 2  then do;if marriage in (3, 4) then marriage=3; end; if region26 eq 4  then do;if income in (1, 2) then income=2; end; if region26 eq 4  then do;if marriage in (2, 5) then marriage=2; end; if region26 eq 4  then do;if marriage in (3, 4) then marriage=3; end; if region26 eq 5  then do;if marriage in (3, 4) then marriage=3; end; if region26 eq 6  then do;if marriage in (2, 5) then marriage=2; end; if region26 eq 6  then do;if marriage in (3, 4) then marriage=3; end; if region26 eq 7  then do;if marriage in (3, 4) then marriage=3; end; if region26 eq 9  then do;if marriage in (3, 4) then marriage=3; end; if region26 eq 10  then do;if marriage in (3, 4) then marriage=3; end; if region26 eq 11  then do;if marriage in (3, 4) then marriage=3; end; if region26 eq 12  then do;if marriage in (3, 4) then marriage=3; end; if region26 eq 13  then do;if marriage in (3, 4) then marriage=3; end; if region26 eq 15  then do;if marriage in (3, 4) then marriage=3; end; if region26 eq 16  then do;if income in (1, 2) then income=2; end; if region26 eq 16  then do;if income in (3, 4) then income=4; end; if region26 eq 16  then do;if marriage in (2, 5) then marriage=2; end; if region26 eq 16  then do;if marriage in (3, 4) then marriage=3; end; if region26 eq 17  then do;if marriage in (3, 4) then marriage=3; end; if region26 eq 18  then do;if marriage in (3, 4) then marriage=3; end; if region26 eq 19  then do;if marriage in (3, 4) then marriage=3; end; if region26 eq 20  then do;if marriage in (2, 5) then marriage=2; end; if region26 eq 20  then do;if marriage in (3, 4) then marriage=3; end; if region26 eq 21  then do;if income in (1, 2) then income=2; end; if region26 eq 21  then do;if income in (1, 2) then income=2; end; if region26 eq 21  then do;if marriage in (2, 5) then marriage=2; end; if region26 eq 21  then do;if marriage in (3, 4) then marriage=3; end; if region26 eq 23  then do;if income in (1, 2) then income=2; end; if region26 eq 23  then do;if marriage in (3, 4) then marriage=3; end; if region26 eq 24  then do;if income in (1, 2) then income=2; end; if region26 eq 24  then do;if marriage in (2, 5) then marriage=2; end; if region26 eq 24  then do;if marriage in (3, 4) then marriage=3; end; if region26 eq 25  then do;if income in (1, 2) then income=2; end; if region26 eq 25  then do;if marriage in (2, 5) then marriage=2; end; if region26 eq 25  then do;if marriage in (3, 4) then marriage=3; end; if region26 eq 25  then do;if marriage in (3, 4) then marriage=3; end; if region26 eq 26  then do;if income in (1, 2) then income=2; end; if region26 eq 26  then do;if income in (1, 2) then income=2; end; if region26 eq 26  then do;if marriage in (2, 5) then marriage=2; end; ... View more

Hi Sir I got the output I made some changes in your code as follows data _null_;   file "C:\changes_new.sas";   set collapse;   if _n_ eq 1 then counter=0;   if count lt 10 then do;     counter+1;      put "if region26 eq " @;     put region26 " then do;" @;     put "if " var "in (" @;     if var eq 'marriage' then do;       if group in (2, 5) then put "2, 5) then marriage=2;";       if group in (3, 4) then put "3, 4) then marriage=3;";     end;     else if var eq 'income' then do;       if group in (1, 2) then put "1, 2) then income=2;";       if group in (3, 4) then put "3, 4) then income=4;";       if group in (5, 6) then put "5, 6) then income=6;";     end;   end; put "end;"; run; data want;   set copy;   %include "C:\changes_new.sas"; run; After trying this code, all the regions are matching with orignal data Without your help, it could never be possible I'll post some more questions with referance to the same, i hope you will resolve my problem Thanks I learned a lot ... View more

Hi i ran the syntax that you send But still i'm facing problem in some categories Please see the output of region26 = 4 Without Collapsing                                       Cumulative    Cumulative                    marriage    Frequency     Percent     Frequency      Percent                           1         101       57.06           101        57.06                           2           5        2.82           106        59.89                           3          14        7.91           120        67.80                           4           4        2.26           124        70.06                           5          53       29.94           177       100.00 Collapsing with my syntax                                          The FREQ Procedure                                                         Cumulative    Cumulative                    marriage    Frequency     Percent     Frequency      Percent                           1         101       57.06           101        57.06                           2          58       32.77           159        89.83                           3          18       10.17           177       100.00 Collapsing by using your code                                       Cumulative    Cumulative                    marriage    Frequency     Percent     Frequency      Percent                           1         101       57.06           101        57.06                           2          50       28.25           151        85.31                           3          18       10.17           169        95.48                           5           8        4.52           177       100.00 I'm facing the same problem in four more regions (21,24,25,26) Please help me out Thanks ... View more

And the CHANGES file contains the following data data.collapse; set data.collapse; run; Please tell me if i'm doing wrong ... View more

Yup i ran the same code And if i'm comparing the data with my original data, it is absolutaly non-matching. ... View more

Hi I built one file containing collapsed dataset as follow data collapse; set data.collapse; run; and then i ran the following syntax data want; set coded; %include "c:\changes.sas"; run; But here the error is coming ERROR 22-322: Syntax error, expecting one of the following: a quoted string, a numeric constant, a datetime constant, a missing value, iterator, (. Please tell me if i'm going wrong Thanks ... View more

Thanks Sir But can you please tell me in FILE statement which file i should keep I got your point but i've little bit confusion in FILE statement Thanks ... View more