@polpel    If there is NONE having age < 18, you will get a missing Value which I thought it is legal value. If you want that such missing value to be handled in your way, let me know. ... View more

data want; array T[11] $ 20 _temporary_ ( "Moins de 18 ans" "De 18 à 24 ans" "De 25 à 29 ans" "De 30 à 34 ans" "De 35 à 39 ans" "De 40 à 44 ans" "De 45 à 49 ans" "De 50 à 54 ans" "De 55 à 59 ans" "De 60 à 64 ans" "65 ans et plus" ); set have; if age < 18 then i = 1; else if age < 25 then i = 2; else if age > 64 then i = 11; I am not sure what you mean by "----- i don't understand what you're doing in the first step...". However, I will explain the logic used.   You require grouping of ages - a total of 11 groups. Each group is labelled and stored in an array T[ ]. Ages 25 to 64 need be grouped into 5-year widths which means 8 intervals(i=3 to i=10). Ages 18 to 24 has a width of 6 years. Rest of the years are falling in open intervals. First interval i = 1 takes ages below 18 years. Ages 18 to 24, 6-year width, will be placed in 2nd interval (i = 2). Ages 65+ will be placed in i = 11. Ages 25 to 64 takes intervals as said above. The corresponding i (i=3, ...,10) is computed using:   else i = 2 + ceil((age - 24) / 5); Hope this clarifies your query.   Kind regards, DataSP ... View more

1. Would the code below be correct (using in ([all of the GROUP results from 1-5]) so that BAND_1_to_5 has a result of 'Yes' when GROUP=1, GROUP=2, GROUP=3, GROUP=4 and GROUP=5 only (see code below)? data test2; set test; length Band_1_to_5 $3; if BAND in ('GROUP = 1', 'GROUP = 2', 'GROUP= 3', 'GROUP = 4', 'GROUP = 5') then BAND_1_to_5 = 'Yes'; else BAND_1_to_5 = 'No'; run; 2. OR can I put the code (if BAND in ('GROUP = 1', 'GROUP = 2', 'GROUP= 3', 'GROUP = 4', 'GROUP = 5') then BAND_1_to_5 = 'Yes'; else BAND_1_to_5 = 'No'; ) in the code written above, so that both that both new variables, BAND and BAND_1_to_5 are BOTH included in the just the one 'test' dataset (i.e. everything is created from just one DATA step). [1] Do you want the combination in 1. to be all 5 to simultaneously true to take value 'YES'? Or if one of them (eg. 'GROUP = 4' ) is true then do you want 'YES'.   A better way will be to add few records in DATALINES and show an output you require out of it. ... View more

@VinitvictorCorr    My program is similar to @Kurt_Bremser .   data k; input SUBJECT $ height weight bmi; datalines; abc 198 87 22.5 pqr 209 98 25 ; run; The following data step uses an array to hold the Labels for names of the variables (Height, Weight, BMI). Another array (V) is used to get the values of the variables. Using Do-Loop they are individually output to the new Data Set (WANT).   data want; array names[3] $ ('Height', 'Weight', 'BMI'); set k; array v height -- bmi; do j = 1 to dim(v); VSTESTCD = names[j]; VSORRES = v[j]; output; end; keep SUBJECT VSTESTCD VSORRES; run; The output is:   ... View more

@VinitvictorCorr    You have given a Data Set as: data k; input subject $ height weight bmi; datalines; abc 198 87 22.5 pqr 209 98 25 ; run; I don't see the variable names as given now as: subject vstestcd vsorres Please clarify your correct specification.  ... View more

@VinitvictorCorr    Your data is Ok. How do you want to re-shape it without using Proc Transpose? Show your Shape. ... View more

@VinitvictorCorr    One way is to use Array.   Give a Data Set, give explanation for transposing with the expected output data set. It will be then easier to help you. ... View more