Hello, I have a huge data set with 134 variables. Even though everything is a number, they're all listed as character variables. I want to convert everything to numeric variables without having to write 134 input (var name, blah);  statements or 134 newvar=oldcharvar*1 statements. I am guessing the fastest way to do this is either using an array or a macro loop. But with an array, don't the variables have to have a similar variable name? like temp1 temp2 temp3 etc. Mine are all different. for example, BIRTH_YEAR is a character variable, even though everything listed is a number (1956,1976, etc). and same with AGE. Help? Thanks, Gina ... View more

Hello, In my last post users suggested using arrays. I have looked into arrays and have come across a problem which I think would best be solved using arrays. I had a data set that was in long format. i.e., multiple lines per ID. looked like this: data x; input ID  c0  c1  c2  c3  c4  c5  c6  c7 ; cards; 1    1          5         7        6           3         3       0         2  1    3          2         5        4           3         1       4         3  2    2          1         4        5           7         2       4         8  2    3          1         3        4           5         2       6         7  2    4          1         2        7           3         6       4         4  ; run; I transposed it to wide format. So now it's like: call this data set 'wide' ID    c0_1 c0_2  c0_3 c1_1 c1_2 c1_3 ....... c7_1 c7_2 c7_3 1      1        3         .       5    2        .             2       3        .        2       2       3         4       1   1        1             8       7       4 I want to take a sum for each line of record in the long format above (i.e., sum(c0,c1,c2,c3,c4,c5,c6,c7)) for the first line for ID1, then do it again for the second line for ID1. Then find that sum for the first , second and third lines of ID2. Right now though, I have the data in wide format. How would I find this sum? I guess I could do it while in long format before I transpose it to wide format, but I want to know how to do this using an array. So I want to find the sum of c0_1, c1_1, c2_1,  .... , c7_1. Then find the sum of c0_2, c1_2, c2_2, ......., c7_2 Here I only have 3 times I'd have to do it, but suppose I had 15 C variables? I can't manually do this by hand it'd be by an array.. This is what I started to write, but I find that there is error in my code. Any suggestions how to fix this? Simplest code possible? Thanks! data array1;        set wide;        c1sum=0;        array c(15)_1 c1_1-c15_1;        do i = 1 to 15;             if c(i)_1 then c1sum=sum(c1sum, c(i)_1);             end;             drop i ; run; SAS doesn't like the "c(i)_1" syntax.. it doesn't like the i not at the end of the variable name, I think. ... View more

Hello. Suppose I have a data set that looks something like ID  age_0  age_1  age_2  age_3  age_4  age_5  age_6  age_7...... age_18 1    1          1         1        1           0         0       0         0         ........0 2    0          0         0        1           1         1       0         0         ........0 3    1          1         0        1           1         1       1         0         ........0 . . . 14,000    0          0         0        0           0         0       1         1         ........1 Where age_0 through age_18 represents binary variables which record whether or not a person had a particular disease recur at each age. (1) Suppose we want to know the age onset of the disease. So for ID #1 it would be at age_0, for ID#2 it would be age_3, for ID#3 it would be age_0, for ID #14,000 it would be age_6. (2) Suppose we want to know the last age at which they had the disease. For ID #1 it would be age_3, for ID #2 it would be age_5 etc. (3) Suppose we want to know the duration of the disease. This could have two meanings:           (a) It could be the # of groups of consecutive sequence of 1's (so for ID#1 it is 1, for ID #2 it is 1, for ID # 3 it is 2, for ID #14,000 it is 2).           (b) If we are referring to the # of years they had the disease, it would just be a sum of the number of 1's for each person (for ID # 1 it is 4, for ID#2 it is 3, for ID#3 it is6, for ID#14,000 it is 12). What would be the most efficient way to code this in SAS? I do not know how to use macros.. there has to be an easier way to do this I can find the total number of years they had the illness by creating a summary score of the 1's. But I am not sure how to do the other 3 tasks. Help? I wanted to google this but I'm not even sure what I would type to look this up. Thanks ... View more

Hello, I have a bunch of variables but I'll just focus on 3 here. So for example, I have two cities CITYA and CITYB. I am looking at differences between education levels and ethnicities of providers in CITYA vs. CITYB. So the provider is either in one or the other, so both are dichotomous variables. ethnicity is a categorical variable (1=Caucasian, 2=African American, etc.). I have education level, which is categorical (1=college, 2= graduate school, etc.) For simplicity sake, here is just the table of city by ethnicity: proc tabulate data=h.april17; class city ethnicity; format ethnicity ethnicity.; table city all, (ethnicity='ethnicity (count)' all)*n*f=4. (ethnicity='ethnicity%' all)*PCTN/BOX='spa by ethnicity'; run; proc freq data=h.april17; title 'chisquare: city by ethnicity';tables city*ethnicity/chisq;run; So what I end up getting is a table with the counts and the percentages. then I ran the proc freq to get the chi-square p-value. However, I'd like to produce a table with a column on the side with the chi-square test statistic as well as the p-value. How may I do this? I really wanted a word document with a big, simple table that's easy to read however I'm not sure how to do that (I'd need a macro?) so for now I'm trying this. Thanks! ... View more

hello, I was wondering how I can export my sas data set, along with its formats, to an spss data set? If I use the export feature from file > export data, I get an error message saying " ERROR: The format YESNOM was not found or could not be loaded. ERROR: The format YESNOM was not found or could not be loaded. ERROR: The format YESNOM was not found or could not be loaded. ERROR: The format BLANK was not found or could not be loaded. ERROR: The format YESNOM was not found or could not be loaded. ERROR: The format BLANK was not found or could not be loaded." etc. So I looked it up online and am having trouble writing the correct code. My library is called "h" and my data set is called "april17" so, it is h.april17. my format file is h.formatsMAR27. If I put this in LIBNAME h SPSS XPORT "E:\work\codebook\CBTdata.dat"; proc formats library=library cntlout=formts; proc copy in=h out = cbt; select april17; run ; SAS tells me "ERROR: Libname H is not assigned." How can I export the data set with its formats so my PI can read in the data set to SPSS? Thanks!' ps I tried using this website but it was confusing http://staff.washington.edu/glynn/sasspss.pdf , ... View more

Hello, I have to compute some 3 summary scores, and there are N=61 participations, each of which would receive 3 summary scores (IPTFACTOR, DTFACTOR and CBTFACTOR). Each factor is the summary score of 5 or 6 variables. I have defined them: CBTFACTOR = SUM(PP_05, PP_07, PP_08,  PP_11, PP_12, PP_14); DTFACTOR = SUM(PP_02, PP_06, PP_10, PP_13, PP_16); IPTFACTOR = SUM(PP_01, PP_03, PP_04, PP_09, PP_15); -- Here's a way of wording  it. Example: Looking at CBTFACTOR: We should probably impute a score for those items that are missing on the scale (i.e., summary score) for those who completed 75% of the items of the scale (i.e., summary score). If they miss more than that, our imputation may not be very good estimate. So for example, the CBT FACTOR has 6 items. But the person is missing one score. Let's say they scored 3, 3, 3, 4, 5, [missing/no response]. Then their average is 3.6. So they would get a 3.6 for PP_14. So their average score will be 3.6, but their total CBT factor score will be 21.6. So I tried writing this in SAS, for the CBT score: IF nmiss(PP_05, PP_07, PP_08,  PP_11, PP_12, PP_14)>4 then CBTFACTOR=MEAN(PP_05, PP_07, PP_08,  PP_11, PP_12, PP_14)*6; But now, I want to tell SAS to make the missing entry, PP_14 (if you see how CBTFACTOR is calculated above, PP_14 is the last entry), 3.6. How do I do this? I just have the above code but not sure what to do with it. I hope I am being clear...  But if they have more than 75% of entries missing then we won't impute. Any ideas on how to code this in SAS? I don't think  it is supposed to be too  difficult, but I'm not sure what  to write after the line of code above. Thanks, Gina ... View more