1) When I did a proc print of the initial dataset given, it looped and turned forever and when it finally stopped it gave me the above log. 1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 72 73 data xyz; 74 set sashelp.heart; 75 run; NOTE: There were 5209 observations read from the data set SASHELP.HEART. NOTE: The data set WORK.XYZ has 5209 observations and 17 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds user cpu time 0.00 seconds system cpu time 0.00 seconds memory 2330.21k OS Memory 28332.00k Timestamp 09/06/2023 10:18:11 PM Step Count 60 Switch Count 2 Page Faults 0 2) When i tried to categorize the dataset into 3 categories using if- then-else statement, then followed by a proc sort statement. This is what i got in the log. , but i got my output, and well categorized. 1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 72 73 74 data work.lowchol work.highchol; 75 set sashelp.heart; 76 if cholesterol < 200 then output = 'work.lowchol'; 77 else if cholesterol ge 200 then output = 'work.highchol'; 78 else if cholesterol = '.' then output = 'work.misschol'; 79 run; NOTE: Character values have been converted to numeric values at the places given by: (Line):(Column). 78:26 NOTE: There were 5209 observations read from the data set SASHELP.HEART. NOTE: The data set WORK.LOWCHOL has 5209 observations and 18 variables. NOTE: The data set WORK.HIGHCHOL has 5209 observations and 18 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds user cpu time 0.01 seconds system cpu time 0.00 seconds memory 3835.15k OS Memory 31408.00k Timestamp 09/06/2023 10:29:25 PM Step Count 96 Switch Count 4 Page Faults 0 Page Reclaims 690 Page Swaps 0 Voluntary Context Switches 23 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 4120 3) When i tried to do a proc print of the data that i categorized and sorted so i could answer the questions that followed. I did not get any result for the proc print but this is what i got in the log. 1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 72 73 proc sort data = work.lowchol work.highchol; _____________ 22 201 ERROR 22-322: Syntax error, expecting one of the following: ;, (, ASCII, BUFFNO, DANISH, DATA, DATECOPY, DETAILS, DIAG, DUPOUT, EBCDIC, EQUALS, FINNISH, FORCE, IN, ISA, L, LEAVE, LIST, MESSAGE, MSG, NATIONAL, NODUP, NODUPKEY, NODUPKEYS, NODUPLICATE, NODUPLICATES, NODUPREC, NODUPRECS, NODUPS, NOEQUALS, NORWEGIAN, NOTHREADS, NOUNIKEY, NOUNIKEYS, NOUNIQUEKEY, NOUNIQUEKEYS, NOUNIQUEREC, NOUNIQUERECS, NOUNIREC, NOUNIRECS, OSA, OUT, OVERWRITE, PAGESIZE, PRESORTED, PSIZE, REVERSE, SIZE, SORTSEQ, SORTSIZE, SORTWKNO, SWEDISH, T, TAGSORT, TECH, TECHNIQUE, TESTHSI, THREADS, UNIOUT, UNIQUEOUT, WKNO, WORKNO. ERROR 201-322: The option is not recognized and will be ignored. 74 by output; 75 run; NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE SORT used (Total process time): real time 0.00 seconds user cpu time 0.00 seconds system cpu time 0.00 seconds memory 1354.84k OS Memory 28840.00k Timestamp 09/06/2023 10:34:52 PM Step Count 103 Switch Count 0 Page Faults 0 Page Reclaims 247 Page Swaps 0 Voluntary Context Switches 0 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 0 76 proc print data = work.lowchol work.highchol; _____________ 22 201 ERROR 22-322: Syntax error, expecting one of the following: ;, (, BLANKLINE, CONTENTS, DATA, DOUBLE, GRANDTOTAL_LABEL, GRANDTOT_LABEL, GRAND_LABEL, GTOTAL_LABEL, GTOT_LABEL, HEADING, LABEL, N, NOOBS, NOSUMLABEL, OBS, ROUND, ROWS, SPLIT, STYLE, SUMLABEL, UNIFORM, WIDTH. ERROR 201-322: The option is not recognized and will be ignored. 77 run; NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE PRINT used (Total process time): real time 0.00 seconds user cpu time 0.01 seconds system cpu time 0.00 seconds memory 1405.15k OS Memory 28840.00k Timestamp 09/06/2023 10:34:52 PM Step Count 104 Switch Count 0 Page Faults 0 Page Reclaims 252 Page Swaps 0 Voluntary Context Switches 0 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 0 78 79 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 80 81 proc sort data = work.lowchol work.highchol; _____________ 22 201 ERROR 22-322: Syntax error, expecting one of the following: ;, (, ASCII, BUFFNO, DANISH, DATA, DATECOPY, DETAILS, DIAG, DUPOUT, EBCDIC, EQUALS, FINNISH, FORCE, IN, ISA, L, LEAVE, LIST, MESSAGE, MSG, NATIONAL, NODUP, NODUPKEY, NODUPKEYS, NODUPLICATE, NODUPLICATES, NODUPREC, NODUPRECS, NODUPS, NOEQUALS, NORWEGIAN, NOTHREADS, NOUNIKEY, NOUNIKEYS, NOUNIQUEKEY, NOUNIQUEKEYS, NOUNIQUEREC, NOUNIQUERECS, NOUNIREC, NOUNIRECS, OSA, OUT, OVERWRITE, PAGESIZE, PRESORTED, PSIZE, REVERSE, SIZE, SORTSEQ, SORTSIZE, SORTWKNO, SWEDISH, T, TAGSORT, TECH, TECHNIQUE, TESTHSI, THREADS, UNIOUT, UNIQUEOUT, WKNO, WORKNO. ERROR 201-322: The option is not recognized and will be ignored. 82 by output; 83 run; NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE SORT used (Total process time): real time 0.00 seconds user cpu time 0.00 seconds system cpu time 0.00 seconds memory 1356.71k OS Memory 29608.00k Timestamp 09/06/2023 10:29:25 PM Step Count 97 Switch Count 0 Page Faults 0 Page Reclaims 241 Page Swaps 0 Voluntary Context Switches 0 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 0 84 85 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 3) When i tried to do a proc sort of the data i categorized above, i could see values for work.lowchol
... View more
