LIBNAME XXX 'c:\users\wagdy'; NOTE: Libref XXX was successfully assigned as follows:      Engine:       V9      Physical Name: c:\users\wagdy 3   DATA XXX.KARIMI4; 4   set XXX.KARIMI3; 5 6     /* scale # 1: attitude towards Israel (4 items) */ 7   Isr = sum (Q4a, Q47a, Q56a, Q65a); 8   Isr = 0; 9   IF Isr NE . THEN Isr= Sum (Q4a, Q47a, Q56a, Q65a); 10 11   /* scale # 2: PV middle-east religiously based political views (5 items)*/ 12   PV = sum (Q2a, Q14a, Q22a,Q61a, Q76a); 13   PV = 0; 14   IF PV NE . THEN PV= sum (Q2a, Q14a, Q22a,Q61a, Q76a); 15 16   /* scale # 3:NEGATIVE attitude toward Women, (5 ITEMS)*/ 17   W = SUM (Q30a,Q40a, Q46a, Q62a, Q70a); 18   W = 0; 19   IF W NE . THEN W = SUM (Q30a,Q40a, Q46a, Q62a, Q70a); 20 21   /* scale # 4:NEGATIVE ATTITUDES TOWARDS THE WESTERN CULTURE (5 ITMS)*/ 22   WC = SUM (Q5a, Q10a,Q28a,Q38a,Q55a); 23   WC =0; 24   IF WC NE . THEN WC = SUM (Q5a,Q10a,Q28a,Q38a,Q55a); 25 26 27   /* scale # 5: superiority Sup (6 items) */ 28 29   SUP = SUM (Q9a,Q17a,Q26a,Q27a,Q36a,Q79a); 30   SUP = 0; 31   IF SUP NE . THEN SUP= SUM (Q9a,Q17a,Q26a,Q27a,Q36a,Q79a); 32 33   /* scale # 6: JE (8 items) based attitude of Condoning fight, 34   believe in the use of force, ideology of Jihad, non-tolerance 35   for others, uncompromising thinking, and no peaceful solution 36   is possible)*/ 37 38   JE = SUM (Q6a, Q19a, Q24a,Q29a,Q34a,Q39a, Q44a, 39           Q50a); 40 41   JE = 0; 42   IF JE NE . THEN JE= SUM (Q6a,Q19a, Q24a, Q29a,Q34a,Q39a, Q44a, Q50a); 43 44   /* religiously thinking person; religious is very important 45   to this person, STRONG RELIGIOUS BELIEFS/IDEOLOGIES (25 items) */ 46   /* religious */ 47   REL= sum 48   (Q13a,Q21a, Q33a,Q45a,Q54a,Q73a); 49 50   REL=0; 51   IF REL NE . THEN REL = sum 52   (Q13a,Q21a, Q33a,Q45a,Q54a,Q73a); 53 54 55   /* TOTALBDS TOTBDS(33)*/ 56   TOTBDS = sum 57   (Q2a, Q4a, Q5a, Q6a, 58   Q10a,Q13a,Q14a, Q19a, 59   Q21a, Q22a,Q24a, Q28a,Q29a, 60   Q30a, Q33a,Q34a, Q38a,Q39a, 61   Q40a, Q44a,Q45a, Q46a,Q47a, 62   Q50a, Q54a,Q55a, Q56a, 63   Q61a, Q62a,Q65a, 64   Q70a, Q73a,Q76a); 65   TOTBDS=0; 66 67   IF TOTBDS NE . THEN TOTBDS = sum 68   (Q2a, Q4a, Q5a, Q6a, 69   Q10a,Q13a,Q14a, Q19a, 70   Q21a, Q22a,Q24a, Q28a,Q29a, 71   Q30a, Q33a,Q34a, Q38a,Q39a, 72   Q40a, Q44a,Q45a, Q46a,Q47a, 73   Q50a, Q54a,Q55a, Q56a, 74   Q61a, Q62a,Q65a, Q70a, Q73a,Q76a); run;   NOTE: Missing values were generated as a result of performing an operation on missing values.      Each place is given by: (Number of times) at (Line):(Column).      1 at 7:7     1 at 9:23   1 at 12:6   1 at 14:21   1 at 17:5   1 at 19:20   1 at 22:6   1 at 24:22   1 at 29:7      1 at 31:23   1 at 38:6   1 at 42:21   1 at 47:6   1 at 51:24   1 at 56:10   1 at 67:30 NOTE: There were 1245 observations read from the data set XXX.KARIMI3. NOTE: The data set XXX.KARIMI4 has 1245 observations and 97 variables. NOTE: DATA statement used (Total process time):      real time           0.09 seconds      cpu time           0.06 seconds     75 76   proc fsedit; run;   Q1. When I proc fsedit it gives me only 891 observations When I run proc freq it gives me 1244 observation? How to fix this? ... View more

      Karimi2 FILE                   Orignal4 file was created using exactly same program. LIBNAME XXX 'c:\users\wagdy'; Data XXX.karimi2;         set XXX.karimi1;               if Q1=1 or Q1=2 then q1=0;       if Q1=3 or Q1=4 then q1=1;       if Q2=1 or Q2=2 then q2=0;       if Q2=3 or Q2=4 then q2=1;       if Q3=1 or Q3=2 then q3=0;       if Q3=3 or Q3=4 then q3=1;       Continue to         if Q80=1 or Q80=2 then q8=0;       if Q80=3 or Q80=4 then q8=1;   Isr = sum (Q4, Q47, Q56, Q65); Isr = 0; IF Isr NE . THEN Isr= Sum (Q4, Q47, Q56, Q65);   PV = sum (Q2, Q14, Q22,Q61, Q76); PV = 0; IF PV NE . THEN PV= sum (Q2, Q14, Q22,Q61, Q76);   W = SUM (Q30,Q40, Q46, Q62, Q70); W = 0; IF W NE . THEN W = SUM (Q30,Q40, Q46, Q62, Q70);   WC = SUM (Q5, Q10,Q28,Q38,Q55); WC =0; IF WC NE . THEN WC = SUM (Q5,Q10,Q28,Q38,Q55);   SUP = SUM (Q9,Q17,Q26,Q27,Q36,Q79); SUP = 0; IF SUP NE . THEN SUP= SUM (Q9,Q17,Q26,Q27,Q36,Q79);     JE = SUM (Q6, Q19, Q24,Q29,Q34,Q39, Q44,Q50); JE = 0; IF JE NE . THEN JE= SUM (Q6,Q19, Q24, Q29,Q34,Q39, Q44,Q50);                     REL= sum (Q13,Q21, Q33,Q45,Q54,Q73); REL=0; IF REL NE . THEN REL = sum (Q13,Q21, Q33,Q45,Q54,Q73);   TOTBDS = sum (Q2, Q4, Q5, Q6, Q10,Q13,Q14, Q19, Q21, Q22,Q24, Q28,Q29, Q30, Q33,Q34, Q38,Q39, Q40, Q44,Q45, Q46,Q47, Q50, Q54,Q55, Q56, Q61, Q62,Q65, Q70, Q73,Q76); TOTBSD=0;   IF TOTBDS NE . THEN TOTBDS = sum (Q2, Q4, Q5, Q6, Q10,Q13,Q14, Q19, Q21, Q22,Q24, Q28,Q29, Q30, Q33,Q34, Q38,Q39, Q40, Q44,Q45, Q46,Q47, Q50, Q54,Q55, Q56, Q61, Q62,Q65, Q70, Q73,Q76); run; ... View more

Thanks. I just did. ... View more

thanks for your response. my question is: how to change variable name from q1a to q1 without affeting my data. regards ... View more

Thanks. Not sure what you mean ... View more

Thanks. What would be the command I use? ... View more

1. re 1st question: sorry. the 1st question has not been answered. you asked me to send more info. & I did via email last night.   2. re second question: I highlight the excel file & after saving it as exclpdf. I go to sas & try to import it. the problem is I can not save it as XXX.FILENAME.   please excuse my ignorance with SAS I used it while doing my master & PH.D more that 30 years ago. I am trying to help some one else using my data/.  appreciate your help.  ... View more

hi, I have excel file & would like to make it SAS file.   I go to SAS then import the file. it forces me to save it as work file. but I can't open it after. I am used to xxx.file name. How to do this? thanks in advance        ... View more

Many thanks. Very helpful suggestions. Regards ... View more

Many thanks. I did not want to bore you with the whole program. all what I need to know is how to initialize a variable.  regards ... View more