Hello everyone,   The code is as below: *Create two way table with Age grouped into two categories; PROC FREQ DATA = books; TITLE 'Patron Age by Book Type: Two Age Groups'; TABLES BookType * Age / NOPERCENT NOROW NOCOL; FORMAT Age agegpb. BookType $typ.; RUN; /* How does PROC FREQ order the categories? For example, why does Non-Fiction get listed before Fiction? The data-set is as below:   17 sci 9 bio 28 fic 50 mys 13 fic 32 fic 67 fic 81 non 38 non 53 non 16 sci 15 bio 61 fic 52 ref 22 mys 76 bio 37 fic 86 fic 49 mys 78 non 45 sci 64 bio 8 fic 11 non 41 fic 46 ref 69 fic 34 fic 26 mys 23 sci 74 ref 15 sci 27 fic 23 mys 63 fic 78 non 40 bio 12 fic 29 fic 54 mys 67 fic 60 fic 38 sci 42 fic 80 fic   I wonder how to answer the question: "Why does Non-Fiction get listed before Fiction"?   Thank you~ ... View more

Hello everyone,   I uploaded the .dat file "Boats" to myfolders, and used &"dirdata" command. but I got error message. Is anyone can help me take a look at what I had done wrong? Thanks!   The code I put in SAS Studio is as below: %let dirdata='/folders/myfolders'; data boats; set '&dirdata/Programs/Week_3/Boats.dat'; run; proc print data=boats; run; The LOG is :     1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 72 73 %let dirdata='/folders/myfolders'; 74 75 data boats; 76 set '&dirdata/Programs/Week_3/Boats.dat'; ERROR: Extension for physical file name "&dirdata/Programs/Week_3/Boats.dat" does not correspond to a valid member type. 77 run; NOTE: The SAS System stopped processing this step because of errors. WARNING: The data set WORK.BOATS may be incomplete. When this step was stopped there were 0 observations and 0 variables. WARNING: Data set WORK.BOATS was not replaced because this step was stopped. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds 78 79 proc print data=boats; 80 run; NOTE: No variables in data set WORK.BOATS. NOTE: PROCEDURE PRINT used (Total process time): real time 0.00 seconds cpu time 0.00 seconds 81 82 83 84 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 97 ... View more

Hello everyone,   The code provided by our instructor was as below:   PROC TABULATE DATA = boats; CLASS Port Locomotion Type; TABLE Port, Locomotion*Type; TITLE 'Number of Boats by Port, Locomotion, and Type'; RUN; Under "Table" command, The "," (comma) means "crossing", and the "*"( the asterisk) means "nesting" I am a bit confused about these two concepts. I know "crossing" is like row and column, but what about "nesting"? Is there anybody would like to elaborate a little bit for me?   Thank you very much! ... View more

Hello everyone,   I started to use SAS 9.4 few days ago. I have some problems with the difference between dirdata, libname perm, and the external data sets which I downloaded in my computer (C drive).   The code I was using was: %let dirdata=C:/Users/jc3992/Downloads; * From week 4: ; data expenses; infile "&dirdata.expensesArray.csv" dlm="," DSD firstobs=2 termstr=CRLF; length ResortName $26 Resort $8; input ResortName Resort OffSeason1-OffSeason6; run; The LOG was as below: 1679 data expenses; 1680 infile "&dirdata.expensesArray.csv" 1681 dlm="," DSD firstobs=2 termstr=CRLF; 1682 length ResortName $26 Resort $8; 1683 input ResortName Resort OffSeason1-OffSeason6; 1684 run; ERROR: Physical file does not exist, C:\Users\jc3992\DownloadsexpensesArray.csv. NOTE: The SAS System stopped processing this step because of errors. WARNING: The data set WORK.EXPENSES may be incomplete. When this step was stopped there were 0 observations and 8 variables. WARNING: Data set WORK.EXPENSES was not replaced because this step was stopped. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds I did not know why it made sense to me that I had defined the path, but SAS could not read it in. Had stuck in it several hours lol I wonder if anyone would kindly help me out?   Thank you!! Any assistance would be appreciated! ... View more