Hi Cynthia, Thanks for a detailed reply, was extremely helpful. I know it just looks from the code that I pasted that all I am doing is trying to format the variable, however there is a lot more to it 🙂 My broader objective was to build a dynamic code and more importantly dynamic array. The only place I was stuck was that I have used arrays to take values from different variables, but I wanted to build an array which can take different values of single variable. I had used a Proc Select into: statement to have the values depicted into a single macro variable &acct. and then Scott helped me in using that to build a dynamic array. Once the above was done, I noticed that my input values were of 16byte however the actual output showed me a value like 60493E45. and hence I just added "FORMAT _ALL_ 16. to the loop, and havent actually pasted the rest of it. But thanks for sending a detailed information, it really helps a lot, since I am also relatively new to SAS. Regards, Tejeshwar ... View more

Thanks Scott. I used the below to generate what i needed, the format is also resolved now data x; array ab ( %sysfunc(countw(&acct)) ) (&acct); do i=1 to dim(ab); format _ALL_ 16.; end; run; ... View more

Thanks Scott. This worked the way I want it to work. I have one more question that I am troubling you with. My actual data values are of length 16, however while producing the output SAS displays it like 6.7392E15 I tried to define the length while defining the array, but it throws me an error ERROR 352-185: The length of numeric variables is 3-8. Will there be a way around this? Regards, Tejeshwar ... View more

Hi, I am trying to input values to the array, and not variable names. For ex: If I define the number of elements in the array, the same syntax works perfectly. For ex: data d; ARRAY accttanttt {3} (123 321 234); run; NOTE: Remote submit to SERVER commencing. 32 data d; 33 ARRAY accttanttt {3} (123 321 234); 34 run; NOTE: The data set WORK.D has 1 observations and 3 variables. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.01 seconds Here is the print of that dataset Obs accttanttt1 accttanttt2 accttanttt3 1 123 321 234 I am confused as to why it doesnt works when we dont define the array elements. Regards, Tejeshwar ... View more

Thank You, I used the Line statement along with compute to get exactly what I wanted. Tejeshwar ... View more

As of now on the other dataset I have referencing the variables created above in below manner. if &MIN0. le scr le &MAX0. then DECILE = &RSCORE0.; else if &MIN1. le scr le &MAX1. then DECILE = &RSCORE1.; else if &MIN2. le scr le &MAX2. then DECILE = &RSCORE2.; else if &MIN3. le scr le &MAX3. then DECILE = &RSCORE3.; else if &MIN4. le scr le &MAX4. then DECILE = &RSCORE4.; else if &MIN5. le scr le &MAX5. then DECILE = &RSCORE5.; else if &MIN6. le scr le &MAX6. then DECILE = &RSCORE6.; else if &MIN7. le scr le &MAX7. then DECILE = &RSCORE7.; else if &MIN8. le scr le &MAX8. then DECILE = &RSCORE8.; else if &MIN9. le scr le &MAX9. then DECILE = &RSCORE9.); run; but this is dependent on me knowing exactly the Macro variables that gets created above. Doing a do loop from 0 TO 9 might not wrk if Proc Rank clubs 2 deciles into 1. ... View more

Hi, Apologies if I was unclear. Lets say I have a data which has some scores like 101, 102, 103,104,201,203,204. Post this I did a Proc Rank to make 10 deciles and look at the distribution. Code- PROC RANK DATA=all (keep = scr ) OUT=all1 (keep = scr RSCORE) GROUPS=10 ; VAR scr; RANKS RSCORE; RUN; Post this I need to define a range that a particular deciles takes, so have done Code- PROC MEANS DATA=ALL1 NOPRINT; VAR scr ; BY RSCORE ; OUTPUT OUT=ALL2 MIN=MINSCORE MAX=MAXSCORE ; RUN; DATA ALL3; SET ALL2; format RANGE $9.; if RSCORE = . then do; RSCORE1 = 'MISSING';RANGE = 'MISSING'; end; else do; do i = RSCORE; if RSCORE = (i) then do; call symput ('MIN'||compress(i),compress(MINSCORE)); call symput ('RSCORE'||compress(i),compress(RSCORE)); call symput ('MAX'||compress(i),compress(MAXSCORE)); RSCORE1 = RSCORE; RANGE = compress(MINSCORE||"-"||MAXSCORE); end; end; end; rename _FREQ_ = F; run; %PUT _GLOBAL_; Once I have the range of each decile, I was hoping to impose that on same variable, however the source and data is different. The objective is to compare the distribution within deciles for these 2 sources. So possibly I was hoping to define the deciles manually on the other dataset through the max and min macro variables that have been generated above and then use a proc sql to get the count for each range. So I am stuck at a point where I am trying to figure out the way to impose the range on new data with &Max and &Min (these will be dynamic based on deciles that gets created and remember we might not get exact same ranks as we mentioned, since at times the 2 deciles are grouped withing one. Regards, Tejeshwar Message was edited by: tejeshwar ... View more

DATA ALL3; SET ALL2; format RANGE $9.; if RSCORE = . then do; RSCORE1 = 'MISSING';RANGE = 'MISSING'; end; else do; do i = RSCORE; if RSCORE = (i) then do; call symput ('MIN'||compress(i),compress(MINSCORE)); call symput ('RSCORE'||compress(i),compress(RSCORE)); call symput ('MAX'||compress(i),compress(MAXSCORE)); RSCORE1 = RSCORE; RANGE = compress(MINSCORE||"-"||MAXSCORE); end; end; end; rename _FREQ_ = F; run; %PUT _GLOBAL_; This is the log _________________ 77 %PUT _GLOBAL_; GLOBAL MIN0 101 GLOBAL MIN1 104 GLOBAL MAX0 103 GLOBAL MIN2 210 GLOBAL MAX1 203 GLOBAL MIN3 402 GLOBAL MAX2 401 GLOBAL MIN4 503 GLOBAL MAX3 502 GLOBAL MIN5 701 GLOBAL MAX4 603 GLOBAL MIN6 802 GLOBAL RSCORE3 3 GLOBAL MAX5 801 GLOBAL MIN7 903 GLOBAL RSCORE2 2 GLOBAL MAX6 902 GLOBAL RSCORE1 1 GLOBAL MAX7 1003 GLOBAL RSCORE0 0 GLOBAL RSCORE7 7 GLOBAL RSCORE6 6 GLOBAL RSCORE5 5 GLOBAL RSCORE4 4 There is another Dataset which will have a variable score where I will need t define the RSCORE for between a range ex: if &MIN0.<=scr<=&&MAX0. then RSCORE1 = &RSCORE. else if &MIN1.<=scr<=&&MAX1. then RSCORE1 = &RSCORE and so on. I was hoping If I could acomplish this inposition in a manner where it isnt dependent on me knowing the ranges and the dynamic varaiables thatget created based on values of RSCORE. Thanks ... View more

Possibly in case you have a sample code, that should be helpful Tej ... View more

Proc Format is one of the option, however in that case I will need to see range of every variable and create these groups manually. Since I am dealing with 250 variables and every single one of them has a different range, so this is something I am hoping to avoid. Something that I am hoping is if SAS can decide these groups by itself depending upon the range and then I can summarize it. I am sure there might be a way, however just I am not able to figure it out by myself. ... View more