</>

TABLE FILE CAR
SUM CNT.MODEL AS 'Nb Country,Model'
BY COUNTRY

SUM CNT.MODEL AS 'Nb Car,Model'
    SALES AS 'Sold'
    COMPUTE AVG_CNTR_MDL /P8.2C =  SALES / C1; AS 'Avg Sold,Per Country'
    COMPUTE AVG_CAR_MDL  /P8.2C =  SALES / C2; AS 'Avg Sold,Per Car'
BY COUNTRY AS 'Country'
BY CAR     AS 'Car'
END

SET ASNAMES=ON
-DEFAULTH &COUNT='';
TABLE FILE CAR
SUM CNT.COUNTRY AS 'COUNT'
ON TABLE HOLD AS COUNT FORMAT ALPHA
END
-RUN 
-READFILE COUNT
-SET &&COUNT = &COUNT;
-TYPE &&COUNT
 

-* A local variable definition
-SET &LOC1 = 'Local';

-* A global variable definition
-SET &&GLB1 = 'Global';

-* From a TABLE file to read more than one value
TABLE FILE CAR
SUM CNT.MODEL
BY COUNTRY
ON TABLE HOLD AS NBMOD
END
-RUN

-SET &NBREC = &LINES;

-REPEAT SETMODVAR FOR &I FROM 1 TO &NBREC STEP 1
-READFILE NBMOD
-SET &CNTR&I.EVAL = TRIM_(BOTH, ' ', &COUNTRY);
-SET &NBMOD&I.EVAL = &MODEL;
-TYPE &CNTR&I.EVAL : &NBMOD&I.EVAL
-SETMODVAR

-* From a TABLE file to read one value of each variable and can rename the name with AS (AS 'NBCAR') 
SET ASNAMES = ON
TABLE FILE CAR
SUM CNT.MODEL
    CNT.CAR AS 'NBCAR'
BY COUNTRY
WHERE COUNTRY EQ 'ENGLAND';
ON TABLE HOLD AS NBMOD
END
-RUN

-READFILE NBMOD

-* Variable are available as is
-TYPE &COUNTRY, &NBCAR, &MODEL

-* Or you can reassign when you need to perform other manipulation such as below
-SET &CNTR = TRIM_(BOTH, ' ', &COUNTRY);
-SET &NBMOD = &MODEL;
-TYPE &CNTR, &NBCAR, &NBMOD

FILEDEF HOLD_TEMP DISK foccache/count.ftm
-RUN
-READFILE HOLD_TEMP
-DEFAULTH &COUNT='';

• The addition of -RUN here is important, or the Dialog Manager code will run before the FOCUS FILEDEF command has executed.
  
• I prefer to define the -DEFAULTH after calling -READFILE, to prevent a warning that the value of the variable gets overwritten by it.
  
• Possibly, you need to add SET HOLDLIST = PRINTONLY where you create your ALPHA file, or the entire matrix will be stored in the ALPHA file - but that should only result in extra variables being set, not in a lack of them.
  

SET ASNAMES = ON
SET HOLDLIST = PRINTONLY

TABLE FILE CAR
SUM CNT.COUNTRY AS 'COUNT'
ON TABLE HOLD AS FOCCACHE/HOLD_TEMP FORMAT ALPHA
END

-* Tell us where it went
WHENCE HOLD_TEMP MASTER

-* Verify readability
-READFILE HOLD_TEMP
-DEFAULTH &COUNT=0;

-TYPE Count: &COUNT

FILEDEF HOLD_TEMP DISK FOCCACHE/hold_temp.ftm
-RUN 

-READFILE HOLD_TEMP
-DEFAULTH &COUNT=0;

-TYPE Count: &COUNT

TABLE FILE CAR
SUM
    CNT.COUNTRY AS 'COUNT'
PRINT
    CAR
BY COUNTRY
ON TABLE HOLD AS foccache/hold_temp FORMAT FOCUS
END
-RUN

-READFILE hold_temp 
-DEFAULTH &COUNT = 0;
-TYPE Count: &COUNT

TABLE FILE hold_temp
PRINT CAR
BY COUNTRY
HEADING
"COUNT: &COUNT"
END