Hello everyone,   Kind of struggle to read in completely of this data as below: The issue is the Limitation and Counts variables. If I use Limitation :$ Counts, then there would be printing some values for Counts, However, that way some characters in "Limitation" would be eliminated. Did I miss anything here?   Any help would be highly appreciated. Thanks!   data activity; input Age $ Gender $ 8-9 Race $7. Poverty $4. Limitation :$5. Counts @@; cards; 10–14 M whites low Major 5 10–14 M whites med Major 21 10–14 M whites hig Major 21 10–14 M other low Major 53 10–14 M other med Major 102 10–14 M other hig Major 52 10–14 F whites low Major 1 10–14 F whites med Major 11 10–14 F whites hig Major 15 10–14 F other low Major 21 10–14 F other med Major 52 10–14 F other hig Major 28 15–19 M whites low Major 1 15–19 M whites med Major 13 15–19 M whites hig Major 21 15–19 M other low Major 36 15–19 M other med Major 86 15–19 M other hig Major 40 15–19 F whites low Major 6 15–19 F whites med Major 8 15–19 F whites hig Major 17 15–19 F other low Major 42 15–19 F other med Major 73 15–19 F other hig Major 26 10–14 M whites low Other 2 10–14 M whites med Other 14 10–14 M whites hig Other 6 10–14 M other low Other 16 10–14 M other med Other 36 10–14 M other hig Other 21 10–14 F whites low Other 2 10–14 F whites med Other 2 10–14 F whites hig Other 3 10–14 F other low Other 17 10–14 F other med Other 33 10–14 F other hig Other 12 15–19 M whites low Other 2 15–19 M whites med Other 8 15–19 M whites hig Other 7 15–19 M other low Other 28 15–19 M other med Other 42 15–19 M other hig Other 23 15–19 F whites low Other 3 15–19 F whites med Other 7 15–19 F whites hig Other 2 15–19 F other low Other 31 15–19 F other med Other 36 15–19 F other hig Other 29 10–14 M whites low None 102 10–14 M whites med None 336 10–14 M whites hig None 285 10–14 M other low None 827 10–14 M other med None 1518 10–14 M other hig None 667 10–14 F whites low None 87 10–14 F whites med None 304 10–14 F whites hig None 302 10–14 F other low None 846 10–14 F other med None 1452 10–14 F other hig None 687 15–19 M whites low None 91 15–19 M whites med None 326 15–19 M whites hig None 313 15–19 M other low None 888 15–19 M other med None 1509 15–19 M other hig None 725 15–19 F whites low None 115 15–19 F whites med None 344 15–19 F whites hig None 286 15–19 F other low None 817 15–19 F other med None 1500 15–19 F other hig None 716 ; run; proc print data=activity; run; ... View more

Hello everyone,   [Updated] Thank you very much for all your helps. after saving to CSV file. It worked. Thank you very much   proc import datafile="&dirdata.umaru.csv" out=umaru dbms=csv replace; delimiter=','; getnames=yes; run; proc print data=umaru; run;     I have been a while not use SAS but I am not so sure of this. The data is like this: The biggest column for "id" is 3 integers for variable " back" the biggest space is 6.   What I used was: Data umaru; INFILE "&dirdata.umaru.xlsx" dlm="," dsd; INPUT id 1-3 age beck 7. ivhx 14-15 ndrugtx 16-17 race 18-19 treat 20-21 site 22-23 dfree 24-25; run; Thank you very much! A appreciated all the advice. Thanks!   id age beck ivhx ndrugtx race treat site dfree 1 39 9 3 1 0 1 0 0 2 33 34 2 8 0 1 0 0 3 33 10 3 3 0 1 0 0       ... View more

Hello everyone,   I would like to ask the question as below, and I have searched for the definition of multi array, but I still cannot relate to this question. Any help would be highly appreciated.   multi array array multi{1:2, 2} (1,2); do i=1 to 2; do j=1 to 2; Output=multi{i,j}; The question is: What is the corresponding values of i, j and output?   The answer is 1,1,1     ... View more

Hello everyone,   I wonder may I ask the SAS macro question in terms of "%sysday" as I tested those options in SAS, and except for the first one generating error, the other three seemed worked!   Thank you very much for reading and any advice.   %macro execute; [ insert_statement_here_] proc print data=sashelp.heart; run; %end; %mend execute; %execute The question is: Which statement completes the program so that the PROC PRINT step executes on Thursday?   A.  if &sysday = Thursday then %do.   B. %if &sysday =Thursday %then %do.   C. %if "&sysday"= Thursday %then %do.   D. %if &sysday = "Thursday" %then %do.     I do not really understand the differences among B,C, and D   Thank you!! ... View more