I wrote the following code:   data sexact; input male female year calyear ; datalines; 0.63 0.51 1 1991 0.62 0.52 3 1993 0.63 0.57 5 1995 0.58 0.51 7 1997 0.59 0.49 9 1999 0.53 0.46 11 2001 0.56 0.5 13 2003 0.55 0.5 15 2005 0.55 0.5 17 2007 0.53 0.48 19 2009 0.54 0.48 21 2011 0.52 0.47 23 2013 0.45 0.4 25 2015 0.41 0.37 27 2017 ; run;     And this code does not generate and output table Could you help me know what the problem is?   The log page says: 1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 72 73 data sexactivity; 74 input male female year calyear; 75 datalines;   NOTE: Invalid data for male in line 76 1-16. NOTE: Invalid data for female in line 77 1-16. NOTE: Invalid data for year in line 78 1-16. NOTE: Invalid data for calyear in line 79 1-16. RULE: ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0   79 CHAR 0.58.0.51.7.1997 ZONE 32330323303033332222222222222222222222222222222222222222222222222222222222222222 NUMR 0E5890E5197919970000000000000000000000000000000000000000000000000000000000000000 NOTE: Invalid data errors for file CARDS occurred outside the printed range. NOTE: Increase available buffer lines with the INFILE n= option. male=. female=. year=. calyear=. _ERROR_=1 _N_=1 NOTE: Invalid data for male in line 80 1-16. NOTE: Invalid data for female in line 81 1-17. NOTE: Invalid data for year in line 82 1-17. NOTE: Invalid data for calyear in line 83 1-17.   83 CHAR 0.55.0.5..15.2005 ZONE 32330323003303333222222222222222222222222222222222222222222222222222222222222222 NUMR 0E5590E5991592005000000000000000000000000000000000000000000000000000000000000000 NOTE: Invalid data errors for file CARDS occurred outside the printed range. NOTE: Increase available buffer lines with the INFILE n= option. male=. female=. year=. calyear=. _ERROR_=1 _N_=2 NOTE: Invalid data for male in line 84 1-17. NOTE: Invalid data for female in line 85 1-17. NOTE: Invalid data for year in line 86 1-17. NOTE: Invalid data for calyear in line 87 1-17.   87 CHAR 0.52.0.47.23.2013 ZONE 32330323303303333222222222222222222222222222222222222222222222222222222222222222 NUMR 0E5290E4792392013000000000000000000000000000000000000000000000000000000000000000 NOTE: Invalid data errors for file CARDS occurred outside the printed range. NOTE: Increase available buffer lines with the INFILE n= option. male=. female=. year=. calyear=. _ERROR_=1 _N_=3 NOTE: Invalid data for male in line 88 1-17. NOTE: Invalid data for female in line 89 1-17. NOTE: LOST CARD. 90 ; NOTE: Invalid data errors for file CARDS occurred outside the printed range. NOTE: Increase available buffer lines with the INFILE n= option. male=. female=. year=. calyear=. _ERROR_=1 _N_=4 NOTE: SAS went to a new line when INPUT statement reached past the end of a line. NOTE: The data set WORK.SEXACTIVITY has 3 observations and 4 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds     90 ; 91 run; 92 93 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 105     ... View more

HELP. My SAS studio license expired on August 2, 2020. Now it doesn't work. I saw in another post that I needed to download the updated .ova file, but I don't know where to find this file. I also hit the  SAS University Edition Information Center updates button and it did not work. Can someone help me, please? ... View more

Hi, I am struggling to generate different groups in proc means. I am trying to generate weekly average temperature groups using id variable and IN operator, and then get their average of each group. I developed the following syntax, but something is wrong. Could someone help me find what the mistake is? thank you.   This is my syntax :   proc means data= id80_00_20a; where id (in (1,2,3,4,5,6, 7))=1; where id (in (8,9,10,11,12,13,14, 15))=2 ; where id (in (16,17,18,19,20,21,22,23))=3; where id (in (24,25,26,27,28,29,30, 31))=4; class id; var avg1 avg2 avg3 ; run;     This is what the log page says:   1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 72 73 proc means data= id80_00_20a; 74 where id (in (1,2,3,4,5,6, 7))=1; ERROR: Function IN requires a character expression as argument 1. 75 where id (in (8,9,10,11,12,13,14, 15))=2 ; ERROR: Function IN requires a character expression as argument 1. 76 where id (in (16,17,18,19,20,21,22,23))=3; ERROR: Function IN requires a character expression as argument 1. 77 where id (in (24,25,26,27,28,29,30, 31))=4; ERROR: Function IN requires a character expression as argument 1. 78 class id; 79 var avg1 avg2 avg3 ; 80 run; ... View more

Hi everyone, I am quite new with SAS University Edition and I have had problems getting my code in a pdf file. Could you help me generate a pdf file of my code and my log (in separate documents) using the ods pdf statement or with another tool? ... View more

Hello, I am looking for some advice since I have had problems creating two data sets composed of females and males from a permanent data set in SAShelp. I used the if statement, but the data set that was created from there was empty. Could you help me see what the problem is? Thanks in advance I added the code and log data. libname assignew " /folders/myfolders/study4"; data assignew; set SASHELP.HEART; run; proc print data=assignew (obs=10); run; proc contents data=assignew varnum; run; data fem; set SASHELP.HEART; if sex = 'f' then output Fem; run; data male; set SASHELP.HEART; if sex = 'm' then output male; run; proc freq data=FEM ; tables Smoking_Status; run; LOG   1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 72 73 libname assignew " /folders/myfolders/study4"; NOTE: Libref ASSIGNEW was successfully assigned as follows: Engine: V9 Physical Name: /folders/myfolders/study4 74 data assignew; 75 set SASHELP.HEART; 76 run;   NOTE: There were 5209 observations read from the data set SASHELP.HEART. NOTE: The data set WORK.ASSIGNEW has 5209 observations and 17 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds     77 proc print data=assignew (obs=10); 78 run;   NOTE: There were 10 observations read from the data set WORK.ASSIGNEW. NOTE: PROCEDURE PRINT used (Total process time): real time 0.06 seconds cpu time 0.06 seconds     79 proc contents data=assignew varnum; 80 run;   NOTE: PROCEDURE CONTENTS used (Total process time): real time 0.05 seconds cpu time 0.05 seconds     81 data fem; 82 set SASHELP.HEART; 83 if sex = 'f' then output Fem; 84 run;   NOTE: There were 5209 observations read from the data set SASHELP.HEART. NOTE: The data set WORK.FEM has 0 observations and 17 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.01 seconds     85 data male; 86 set SASHELP.HEART; 87 if sex = 'm' then output male; 88 run;   NOTE: There were 5209 observations read from the data set SASHELP.HEART. NOTE: The data set WORK.MALE has 0 observations and 17 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds     89 proc freq data=FEM ; 90 tables Smoking_Status; 91 run;   NOTE: No observations in data set WORK.FEM. NOTE: PROCEDURE FREQ used (Total process time): real time 0.00 seconds cpu time 0.00 seconds     92 93 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 105   ... View more

I'm trying to create a defined format for the values of the variable HV201, but I'm not seeing the updated format in the proc freq and print tables of the variable HV201. I tried to change the name of the variable in the proc format step to the value HV201fmt, but it did not work. Could you please tell me if I am doing something wrong? Thank you for your help This is the SAS code : libname Assig2 "/folders/myfolders/study3"; data work.homework2; set Assig2.homework2; run; proc format; value HV201fmt 11="Piped into dwelling" 12= "Piped to yard/plot" 13= "Public tap/standpipe" 21= "Tube well or borehole" 31= "Protected well" 32= "Unprotected well" 41="Protected spring" 42= "Unprotected spring" 43= "River/dam/lake/ponds/stream/canal/irrigation channel" 51= "Rainwater" 61= "Tanker truck" 71= "Bottled water or sachet" 96= "Other" 99= "Missing"; run; proc print data=work.homework2 (obs=10); format HV201 HV201A. ; run; proc freq data=work.homework2; format HV201 HV201A. ; run; Log:   1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 72 73 libname Assig2 "/folders/myfolders/study3"; NOTE: Libref ASSIG2 was successfully assigned as follows: Engine: V9 Physical Name: /folders/myfolders/study3 74 data work.homework2; 75 set Assig2.homework2; NOTE: Data file ASSIG2.HOMEWORK2.DATA is in a format that is native to another host, or the file encoding does not match the session encoding. Cross Environment Data Access will be used, which might require additional CPU resources and might reduce performance. 76 run;   NOTE: Format HV003A was not found or could not be loaded. NOTE: Format HV025A was not found or could not be loaded. NOTE: Format HV106A was not found or could not be loaded. NOTE: Format HV108A was not found or could not be loaded. NOTE: Format HV201A was not found or could not be loaded. NOTE: Format HV204A was not found or could not be loaded. NOTE: Format HV205A was not found or could not be loaded. NOTE: Format HV206A was not found or could not be loaded. NOTE: Format HV213A was not found or could not be loaded. NOTE: Format HV214A was not found or could not be loaded. NOTE: Format HV215A was not found or could not be loaded. NOTE: Format HV219A was not found or could not be loaded. NOTE: Format HV220A was not found or could not be loaded. NOTE: Format HV243AA was not found or could not be loaded. NOTE: There were 3832 observations read from the data set ASSIG2.HOMEWORK2. NOTE: The data set WORK.HOMEWORK2 has 3832 observations and 20 variables. NOTE: DATA statement used (Total process time): real time 0.02 seconds cpu time 0.01 seconds     77 proc format; 78 value HV201fmt 79 11="Piped into dwelling" 80 12= "Piped to yard/plot" 81 13= "Public tap/standpipe" 82 21= "Tube well or borehole" 83 31= "Protected well" 84 32= "Unprotected well" 85 41="Protected spring" 86 42= "Unprotected spring" 87 43= "River/dam/lake/ponds/stream/canal/irrigation channel" 88 51= "Rainwater" 89 61= "Tanker truck" 90 71= "Bottled water or sachet" 91 96= "Other" 92 99= "Missing"; NOTE: Format HV201FMT is already on the library WORK.FORMATS. NOTE: Format HV201FMT has been output. 93 run;   NOTE: PROCEDURE FORMAT used (Total process time): real time 0.00 seconds cpu time 0.00 seconds     94 proc print data=work.homework2 (obs=10); 95 format HV201 HV201A. ; 96 run;   NOTE: There were 10 observations read from the data set WORK.HOMEWORK2. NOTE: PROCEDURE PRINT used (Total process time): real time 0.06 seconds cpu time 0.06 seconds     97 proc freq data=work.homework2; 98 format HV201 HV201A. ; 99 run;   NOTE: There were 3832 observations read from the data set WORK.HOMEWORK2. NOTE: PROCEDURE FREQ used (Total process time): real time 0.89 seconds cpu time 0.90 seconds     100 101 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 113     ... View more

Hi , I am quite new using SAS studio. I started this code to analyze data in a .dat file. In the input step, I used some informats and one is mmddyy10. The problem is that in the result some dates are missing. So, I would like to know what the problem is with the code that only shows some dates and others not. I have attached a sample of the data. Thanks in advance Thanks for any advice.     this is the code:   Data assigment; infile '/folders/myfolders/study2/MemberData_RuralHealth.dat' LRECL=50 MISSOVER ; input @1 Line 2.0 @3 Country $3. @6 Cluster 4.0 @10 House_hn 4.0 @14 Househ_s 8.6 @22 Date mmddyy10. @32 Bank_A 1.0 @33 FHMSIH 1.0 @34 Geo_zone 1.0 @35 BMI_w 4.0 @39 Hgb_w 3.1 @42 Anemia_w 1.0 @43 BMI_m 4.0 @47 Hgb_m 3.1 @50 Anemia_m 1.0 ; format Date mmddyy10. ; run; proc print data= assigment; run;         This is the log results:   1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 72 73 Data assigment; 74 infile '/folders/myfolders/study2/MemberData_RuralHealth.dat' LRECL=50 MISSOVER ; 75 input 76 @1 Line 2.0 77 @3 Country $3. 78 @6 Cluster 4.0 79 @10 House_hn 4.0 80 @14 Househ_s 8.6 81 @22 Date mmddyy10. 82 @32 Bank_A 1.0 83 @33 FHMSIH 1.0 84 @34 Geo_zone 1.0 85 @35 BMI_w 4.0 86 @39 Hgb_w 3.1 87 @42 Anemia_w 1.0 88 @43 BMI_m 4.0 89 @47 Hgb_m 3.1 90 @50 Anemia_m 1.0 91 ; 92 format Date mmddyy10. ; 93 run;   NOTE: The infile '/folders/myfolders/study2/MemberData_RuralHealth.dat' is: Filename=/folders/myfolders/study2/MemberData_RuralHealth.dat, Owner Name=root,Group Name=vboxsf, Access Permission=-rwxrwx---, Last Modified=01Feb2020:15:20:50, File Size (bytes)=35256   NOTE: Invalid data for Date in line 1 22-31. RULE: ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0 1 4ZZ6 1 25 104950229/06/201502219981013 Line=4 Country=ZZ6 Cluster=1 House_hn=25 Househ_s=1.049502 Date=. Bank_A=0 FHMSIH=2 Geo_zone=2 BMI_w=1998 Hgb_w=10.1 Anemia_w=3 BMI_m=. Hgb_m=. Anemia_m=. _ERROR_=1 _N_=1 NOTE: Invalid data for Date in line 10 22-31. 10 2ZZ6 3 6 26246627/08/2015001 Line=2 Country=ZZ6 Cluster=3 House_hn=6 Househ_s=0.262466 Date=. Bank_A=0 FHMSIH=0 Geo_zone=1 BMI_w=. Hgb_w=. Anemia_w=. BMI_m=. Hgb_m=. Anemia_m=. _ERROR_=1 _N_=10 NOTE: Invalid data for Date in line 11 22-31. 11 4ZZ6 3 7 26246626/08/2015001 Line=4 Country=ZZ6 Cluster=3 House_hn=7 Househ_s=0.262466 Date=. Bank_A=0 FHMSIH=0 Geo_zone=1 BMI_w=. Hgb_w=. Anemia_w=. BMI_m=. Hgb_m=. Anemia_m=. _ERROR_=1 _N_=11 NOTE: Invalid data for Date in line 12 22-31. 12 3ZZ6 3 12 26246628/08/2015001 Line=3 Country=ZZ6 Cluster=3 House_hn=12 Househ_s=0.262466 Date=. Bank_A=0 FHMSIH=0 Geo_zone=1 BMI_w=. Hgb_w=. Anemia_w=. BMI_m=. Hgb_m=. Anemia_m=. _ERROR_=1 _N_=12 NOTE: Invalid data for Date in line 13 22-31. 13 5ZZ6 3 14 26246625/08/2015001 Line=5 Country=ZZ6 Cluster=3 House_hn=14 Househ_s=0.262466 Date=. Bank_A=0 FHMSIH=0 Geo_zone=1 BMI_w=. Hgb_w=. Anemia_w=. BMI_m=. Hgb_m=. Anemia_m=. _ERROR_=1 _N_=13 NOTE: Invalid data for Date in line 14 22-31. 14 6ZZ6 3 27 26246626/08/2015001 Line=6 Country=ZZ6 Cluster=3 House_hn=27 Househ_s=0.262466 Date=. Bank_A=0 FHMSIH=0 Geo_zone=1 BMI_w=. Hgb_w=. Anemia_w=. BMI_m=. Hgb_m=. Anemia_m=. _ERROR_=1 _N_=14 NOTE: Invalid data for Date in line 15 22-31. 15 5ZZ6 4 8 29429920/09/2015003 Line=5 Country=ZZ6 Cluster=4 House_hn=8 Househ_s=0.294299 Date=. Bank_A=0 FHMSIH=0 Geo_zone=3 BMI_w=. Hgb_w=. Anemia_w=. BMI_m=. Hgb_m=. Anemia_m=. _ERROR_=1 _N_=15 NOTE: Invalid data for Date in line 16 22-31. RULE: ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0 16 3ZZ6 4 16 29429920/09/2015013 Line=3 Country=ZZ6 Cluster=4 House_hn=16 Househ_s=0.294299 Date=. Bank_A=0 FHMSIH=1 Geo_zone=3 BMI_w=. Hgb_w=. Anemia_w=. BMI_m=. Hgb_m=. Anemia_m=. _ERROR_=1 _N_=16 NOTE: Invalid data for Date in line 17 22-31. 17 4ZZ6 4 24 29429920/09/2015013 Line=4 Country=ZZ6 Cluster=4 House_hn=24 Househ_s=0.294299 Date=. Bank_A=0 FHMSIH=1 Geo_zone=3 BMI_w=. Hgb_w=. Anemia_w=. BMI_m=. Hgb_m=. Anemia_m=. _ERROR_=1 _N_=17 NOTE: Invalid data for Date in line 21 22-31. 21 1ZZ6 6 10 184670926/06/201500121051204 Line=1 Country=ZZ6 Cluster=6 House_hn=10 Househ_s=1.846709 Date=. Bank_A=0 FHMSIH=0 Geo_zone=1 BMI_w=2105 Hgb_w=12 Anemia_w=4 BMI_m=. Hgb_m=. Anemia_m=. _ERROR_=1 _N_=21 NOTE: Invalid data for Date in line 22 22-31. 22 5ZZ6 6 12 184670925/06/2015001 Line=5 Country=ZZ6 Cluster=6 House_hn=12 Househ_s=1.846709 Date=. Bank_A=0 FHMSIH=0 Geo_zone=1 BMI_w=. Hgb_w=. Anemia_w=. BMI_m=. Hgb_m=. Anemia_m=. _ERROR_=1 _N_=22 NOTE: Invalid data for Date in line 23 22-31. 23 2ZZ6 6 25 184670926/06/2015011 Line=2 Country=ZZ6 Cluster=6 House_hn=25 Househ_s=1.846709 Date=. Bank_A=0 FHMSIH=1 Geo_zone=1 BMI_w=. Hgb_w=. Anemia_w=. BMI_m=. Hgb_m=. Anemia_m=. _ERROR_=1 _N_=23 NOTE: Invalid data for Date in line 24 22-31. 24 1ZZ6 6 26 184670927/06/2015001 Line=1 Country=ZZ6 Cluster=6 House_hn=26 Househ_s=1.846709 Date=. Bank_A=0 FHMSIH=0 Geo_zone=1 BMI_w=. Hgb_w=. Anemia_w=. BMI_m=. Hgb_m=. Anemia_m=. _ERROR_=1 _N_=24 NOTE: Invalid data for Date in line 25 22-31. 25 10ZZ6 6 30 184670927/06/2015011 Line=10 Country=ZZ6 Cluster=6 House_hn=30 Househ_s=1.846709 Date=. Bank_A=0 FHMSIH=1 Geo_zone=1 BMI_w=. Hgb_w=. Anemia_w=. BMI_m=. Hgb_m=. Anemia_m=. _ERROR_=1 _N_=25 NOTE: Invalid data for Date in line 26 22-31. 26 8ZZ6 6 31 184670927/06/2015001 Line=8 Country=ZZ6 Cluster=6 House_hn=31 Househ_s=1.846709 Date=. Bank_A=0 FHMSIH=0 Geo_zone=1 BMI_w=. Hgb_w=. Anemia_w=. BMI_m=. Hgb_m=. Anemia_m=. _ERROR_=1 _N_=26 NOTE: Invalid data for Date in line 27 22-31. 27 1ZZ6 7 1 45712514/06/2015013 Line=1 Country=ZZ6 Cluster=7 House_hn=1 Househ_s=0.457125 Date=. Bank_A=0 FHMSIH=1 Geo_zone=3 BMI_w=. Hgb_w=. Anemia_w=. BMI_m=. Hgb_m=. Anemia_m=. _ERROR_=1 _N_=27 NOTE: Invalid data for Date in line 29 22-31. 29 2ZZ6 8 5 79835716/08/201501322811143 Line=2 Country=ZZ6 Cluster=8 House_hn=5 Househ_s=0.798357 Date=. Bank_A=0 FHMSIH=1 Geo_zone=3 BMI_w=2281 Hgb_w=11.4 Anemia_w=3 BMI_m=. Hgb_m=. Anemia_m=. _ERROR_=1 _N_=29 NOTE: Invalid data for Date in line 30 22-31. 30 4ZZ6 8 7 79835716/08/2015013 Line=4 Country=ZZ6 Cluster=8 House_hn=7 Househ_s=0.798357 Date=. Bank_A=0 FHMSIH=1 Geo_zone=3 BMI_w=. Hgb_w=. Anemia_w=. BMI_m=. Hgb_m=. Anemia_m=. _ERROR_=1 _N_=30 NOTE: Invalid data for Date in line 31 22-31. 31 4ZZ6 8 8 79835716/08/2015013 2396 792 Line=4 Country=ZZ6 Cluster=8 House_hn=8 Househ_s=0.798357 Date=. Bank_A=0 FHMSIH=1 Geo_zone=3 BMI_w=. Hgb_w=. Anemia_w=. BMI_m=2396 Hgb_m=7.9 Anemia_m=2 _ERROR_=1 _N_=31 NOTE: Invalid data for Date in line 32 22-31. WARNING: Limit set by ERRORS= option reached. Further errors of this type will not be printed. 32 4ZZ6 8 13 79835716/08/2015003 Line=4 Country=ZZ6 Cluster=8 House_hn=13 Househ_s=0.798357 Date=. Bank_A=0 FHMSIH=0 Geo_zone=3 BMI_w=. Hgb_w=. Anemia_w=. BMI_m=. Hgb_m=. Anemia_m=. _ERROR_=1 _N_=32 NOTE: 678 records were read from the infile '/folders/myfolders/study2/MemberData_RuralHealth.dat'. The minimum record length was 50. The maximum record length was 50. NOTE: The data set WORK.ASSIGMENT has 678 observations and 15 variables. NOTE: DATA statement used (Total process time): real time 0.02 seconds cpu time 0.02 seconds     94 proc print data= assigment; 95 run;   NOTE: There were 678 observations read from the data set WORK.ASSIGMENT. NOTE: PROCEDURE PRINT used (Total process time): real time 7.06 seconds cpu time 7.05 seconds     96 97 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 109   ... View more