proc freq data=WORK.SYPHILIS; tables age sex_o genderC genderB / plots=(freqplot cumfreqplot); where age_group= '18 to 50'; run; Log: 1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 72 73 /* 74 * 75 * Task code generated by SAS Studio 3.8 76 * 77 * Generated on '8/5/20, 12:06 PM' 78 * Generated by 'u49152646' 79 * Generated on server 'ODAWS02-USW2.ODA.SAS.COM' 80 * Generated on SAS platform 'Linux LIN X64 3.10.0-1062.9.1.el7.x86_64' 81 * Generated on SAS version '9.04.01M6P11072018' 82 * Generated on browser 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) 82 ! Chrome/84.0.4147.105 Safari/537.36' 83 * Generated on web client 83 ! 'https://odamid-usw2.oda.sas.com/SASStudio/main?locale=en_US&zone=GMT-07%253A00&ticket=ST-58631-NKEgz3Gaqesii60Jleii-cas' 84 * 85 */ 86 87 proc freq data=WORK.SYPHILIS; 88 tables age sex_o genderC genderB / plots=(freqplot cumfreqplot); 89 where age_group= '18 to 50'; ERROR: Variable age_group is not on file WORK.SYPHILIS. 90 run; NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE FREQ used (Total process time): real time 0.00 seconds user cpu time 0.00 seconds system cpu time 0.00 seconds memory 1375.50k OS Memory 38572.00k Timestamp 08/05/2020 07:33:34 PM Step Count 265 Switch Count 0 Page Faults 0 Page Reclaims 242 Page Swaps 0 Voluntary Context Switches 0 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 0 91 92 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 104 ... View more

Thanks ... View more

I have it now. I need a frequency table for an age group (18-50) along with gender  proc freq data=WORK.SYPHILIS; tables genderC genderB age / plots=(freqplot cumfreqplot); run; How do I write the code for an age group of 18-50 ... View more

My end goal is to create a frequency table..it lets me enter the source of the data but the data set is not showing up in the library  ... View more

I finally got it!! Thank you for all your help!  ... View more

Got it...Now I have an output but it is empty...I tried coding a different way from the tutorial videos that you sent me... data sample; infile '/home/u49152646/EPG194/rapid_syphilis/sample.csv' dlm=',' firstobs=2; input rapid_syphilis race gendec genderb sex_o housing_status sessiondate age druguse condom risk; run; Log was pretty long but it says invalid data and gain my output data was empty: 1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; SYMBOLGEN: Macro variable _SASWSTEMP_ resolves to /home/u49152646/.sasstudio/.images/52784700-4b6e-40f6-aa6a-258160043ad9 SYMBOLGEN: Some characters in the above value which were subject to macro quoting have been unquoted for printing. SYMBOLGEN: Macro variable GRAPHINIT resolves to GOPTIONS RESET=ALL GSFNAME=_GSFNAME; 72 73 data sample; 74 infile '/home/u49152646/EPG194/rapid_syphilis/sample.csv' dlm=',' firstobs=2; 75 input rapid_syphilis race gendec genderb sex_o housing_status sessiondate age druguse condom risk; 76 run; NOTE: The infile '/home/u49152646/EPG194/rapid_syphilis/sample.csv' is: Filename=/home/u49152646/EPG194/rapid_syphilis/sample.csv, Owner Name=u49152646,Group Name=oda, Access Permission=-rw-r--r--, Last Modified=04Aug2020:10:54:25, File Size (bytes)=826571 NOTE: Invalid data for rapid_syphilis in line 2 1-8. NOTE: Invalid data for race in line 2 10-14. NOTE: Invalid data for gendec in line 2 16-19. NOTE: Invalid data for genderb in line 2 21-24. NOTE: Invalid data for sex_o in line 2 26-33. NOTE: Invalid data for housing_status in line 2 35-46. NOTE: Invalid data for sessiondate in line 2 48-65. NOTE: Invalid data for age in line 2 67-75. NOTE: Invalid data for condom in line 2 80-81. NOTE: Invalid data for risk in line 2 83-100. RULE: ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0 2 Received,White,Male,Male,Bisexual,Not Homeless,West Hollywood MTU,27-Apr-18,50,No,Did not use condom 101 ,High 105 rapid_syphilis=. race=. gendec=. genderb=. sex_o=. housing_status=. sessiondate=. age=. druguse=50 condom=. risk=. _ERROR_=1 _N_=1 NOTE: Invalid data for rapid_syphilis in line 3 1-8. NOTE: Invalid data for race in line 3 10-14. NOTE: Invalid data for gendec in line 3 16-19. NOTE: Invalid data for genderb in line 3 21-24. NOTE: Invalid data for sex_o in line 3 26-36. NOTE: Invalid data for housing_status in line 3 38-49. NOTE: Invalid data for sessiondate in line 3 51-68. NOTE: Invalid data for age in line 3 70-78. NOTE: Invalid data for condom in line 3 83-84. NOTE: Invalid data for risk in line 3 86-103. 3 Received,White,Male,Male,Gay/Lesbian,Not Homeless,West Hollywood MTU,28-Apr-18,23,No,Did not use con 101 dom,High 108 rapid_syphilis=. race=. gendec=. genderb=. sex_o=. housing_status=. sessiondate=. age=. druguse=23 condom=. risk=. _ERROR_=1 _N_=2 NOTE: Invalid data for rapid_syphilis in line 4 1-8. NOTE: Invalid data for race in line 4 10-14. NOTE: Invalid data for gendec in line 4 16-19. NOTE: Invalid data for genderb in line 4 21-24. NOTE: Invalid data for sex_o in line 4 26-33. NOTE: Invalid data for housing_status in line 4 35-42. NOTE: Invalid data for sessiondate in line 4 44-61. NOTE: Invalid data for age in line 4 63-71. NOTE: Invalid data for condom in line 4 76-77. NOTE: Invalid data for risk in line 4 79-96. 4 Received,White,Male,Male,Bisexual,Homeless,West Hollywood MTU,28-Apr-18,49,No,Did not use condom,Hig 101 h 101 rapid_syphilis=. race=. gendec=. genderb=. sex_o=. housing_status=. sessiondate=. age=. druguse=49 condom=. risk=. _ERROR_=1 _N_=3 NOTE: Invalid data for rapid_syphilis in line 5 1-12. NOTE: Invalid data for race in line 5 14-35. NOTE: Invalid data for gendec in line 5 37-40. NOTE: Invalid data for genderb in line 5 42-45. NOTE: Invalid data for sex_o in line 5 47-57. NOTE: Invalid data for housing_status in line 5 59-70. NOTE: Invalid data for sessiondate in line 5 72-89. NOTE: Invalid data for age in line 5 91-99. NOTE: Invalid data for condom in line 5 104-105. NOTE: Invalid data for risk in line 5 107-124. RULE: ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0 5 Not Received,Black/African American,Male,Male,Gay/Lesbian,Not Homeless,West Hollywood MTU,28-Apr-18, 101 52,No,Did not use condom,High 129 rapid_syphilis=. race=. gendec=. genderb=. sex_o=. housing_status=. sessiondate=. age=. druguse=52 condom=. risk=. _ERROR_=1 _N_=4 NOTE: Invalid data for rapid_syphilis in line 6 1-12. NOTE: Invalid data for race in line 6 14-18. NOTE: Invalid data for gendec in line 6 20-23. NOTE: Invalid data for genderb in line 6 25-28. NOTE: Invalid data for sex_o in line 6 30-40. NOTE: Invalid data for housing_status in line 6 42-53. NOTE: Invalid data for sessiondate in line 6 55-72. NOTE: Invalid data for age in line 6 74-82. NOTE: Invalid data for condom in line 6 87-88. NOTE: Invalid data for risk in line 6 90-103. 6 Not Received,Asian,Male,Male,Gay/Lesbian,Not Homeless,West Hollywood MTU,28-Apr-18,26,No,Did use con 101 dom,Low 107 rapid_syphilis=. race=. gendec=. genderb=. sex_o=. housing_status=. sessiondate=. age=. druguse=26 condom=. risk=. _ERROR_=1 _N_=5 NOTE: Invalid data for rapid_syphilis in line 7 1-12. NOTE: Invalid data for race in line 7 14-18. NOTE: Invalid data for gendec in line 7 20-23. NOTE: Invalid data for genderb in line 7 25-28. NOTE: Invalid data for sex_o in line 7 30-40. NOTE: Invalid data for housing_status in line 7 42-53. NOTE: Invalid data for sessiondate in line 7 55-72. NOTE: Invalid data for age in line 7 74-82. NOTE: Invalid data for condom in line 7 87-88. NOTE: Invalid data for risk in line 7 90-103. 7 Not Received,White,Male,Male,Gay/Lesbian,Not Homeless,West Hollywood MTU,28-Apr-18,27,No,Did use con 101 dom,Low 107 rapid_syphilis=. race=. gendec=. genderb=. sex_o=. housing_status=. sessiondate=. age=. druguse=27 condom=. risk=. _ERROR_=1 _N_=6 NOTE: Invalid data for rapid_syphilis in line 8 1-12. NOTE: Invalid data for race in line 8 14-35. NOTE: Invalid data for gendec in line 8 37-40. NOTE: Invalid data for genderb in line 8 42-45. NOTE: Invalid data for sex_o in line 8 47-58. NOTE: Invalid data for housing_status in line 8 60-71. NOTE: Invalid data for sessiondate in line 8 73-90. NOTE: Invalid data for age in line 8 92-100. NOTE: Invalid data for condom in line 8 105-106. NOTE: Invalid data for risk in line 8 108-125. 8 Not Received,Black/African American,Male,Male,Heterosexual,Not Homeless,West Hollywood MTU,28-Apr-18 101 ,39,No,Did not use condom,High 130 rapid_syphilis=. race=. gendec=. genderb=. sex_o=. housing_status=. sessiondate=. age=. druguse=39 condom=. risk=. _ERROR_=1 _N_=7 NOTE: Invalid data for rapid_syphilis in line 9 1-12. NOTE: Invalid data for race in line 9 14-24. NOTE: Invalid data for gendec in line 9 26-36. NOTE: Invalid data for genderb in line 9 38-41. NOTE: Invalid data for sex_o in line 9 43-58. NOTE: Invalid data for housing_status in line 9 60-71. NOTE: Invalid data for sessiondate in line 9 73-90. NOTE: Invalid data for age in line 9 92-100. NOTE: Invalid data for condom in line 9 105-106. NOTE: Invalid data for risk in line 9 108-121. RULE: ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0 9 Not Received,Multiracial,Transgender,Male,Unknown/Declined,Not Homeless,West Hollywood MTU,28-Apr-18 101 ,39,No,Did use condom,Low 125 rapid_syphilis=. race=. gendec=. genderb=. sex_o=. housing_status=. sessiondate=. age=. druguse=39 condom=. risk=. _ERROR_=1 _N_=8 NOTE: Invalid data for rapid_syphilis in line 10 1-8. NOTE: Invalid data for race in line 10 10-14. NOTE: Invalid data for gendec in line 10 16-19. NOTE: Invalid data for genderb in line 10 21-24. NOTE: Invalid data for sex_o in line 10 26-36. NOTE: Invalid data for housing_status in line 10 38-49. NOTE: Invalid data for sessiondate in line 10 51-68. NOTE: Invalid data for age in line 10 70-78. NOTE: Invalid data for condom in line 10 83-84. NOTE: Invalid data for risk in line 10 86-99. 10 Received,White,Male,Male,Gay/Lesbian,Not Homeless,West Hollywood MTU,28-Apr-18,29,No,Did use condom, 101 High 104 rapid_syphilis=. race=. gendec=. genderb=. sex_o=. housing_status=. sessiondate=. age=. druguse=29 condom=. risk=. _ERROR_=1 _N_=9 NOTE: Invalid data for rapid_syphilis in line 11 1-12. NOTE: Invalid data for race in line 11 14-18. NOTE: Invalid data for gendec in line 11 20-23. NOTE: Invalid data for genderb in line 11 25-28. NOTE: Invalid data for sex_o in line 11 30-40. NOTE: Invalid data for housing_status in line 11 42-53. NOTE: Invalid data for sessiondate in line 11 55-72. NOTE: Invalid data for age in line 11 74-82. NOTE: Invalid data for condom in line 11 87-88. NOTE: Invalid data for risk in line 11 90-103. 11 Not Received,White,Male,Male,Gay/Lesbian,Not Homeless,West Hollywood MTU,28-Apr-18,26,No,Did use con 101 dom,Low 107 rapid_syphilis=. race=. gendec=. genderb=. sex_o=. housing_status=. sessiondate=. age=. druguse=26 condom=. risk=. _ERROR_=1 _N_=10 NOTE: Invalid data for rapid_syphilis in line 12 1-12. NOTE: Invalid data for race in line 12 14-18. NOTE: Invalid data for gendec in line 12 20-23. NOTE: Invalid data for genderb in line 12 25-28. NOTE: Invalid data for sex_o in line 12 30-40. NOTE: Invalid data for housing_status in line 12 42-53. NOTE: Invalid data for sessiondate in line 12 55-72. NOTE: Invalid data for age in line 12 74-82. NOTE: Invalid data for condom in line 12 87-88. NOTE: Invalid data for risk in line 12 90-103. 12 Not Received,Asian,Male,Male,Gay/Lesbian,Not Homeless,West Hollywood MTU,28-Apr-18,21,No,Did use con 101 dom,Low 107 rapid_syphilis=. race=. gendec=. genderb=. sex_o=. housing_status=. sessiondate=. age=. druguse=21 condom=. risk=. _ERROR_=1 _N_=11 NOTE: Invalid data for rapid_syphilis in line 13 1-12. NOTE: Invalid data for race in line 13 14-24. NOTE: Invalid data for gendec in line 13 26-29. NOTE: Invalid data for genderb in line 13 31-34. NOTE: Invalid data for sex_o in line 13 36-43. NOTE: Invalid data for housing_status in line 13 45-56. NOTE: Invalid data for sessiondate in line 13 58-75. NOTE: Invalid data for age in line 13 77-85. NOTE: Invalid data for condom in line 13 90-91. NOTE: Invalid data for risk in line 13 93-110. 13 Not Received,Multiracial,Male,Male,Bisexual,Not Homeless,West Hollywood MTU,28-Apr-18,27,No,Did not RULE: ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0 101 use condom,High 115 rapid_syphilis=. race=. gendec=. genderb=. sex_o=. housing_status=. sessiondate=. age=. druguse=27 condom=. risk=. _ERROR_=1 _N_=12 NOTE: Invalid data for rapid_syphilis in line 14 1-12. NOTE: Invalid data for race in line 14 14-18. NOTE: Invalid data for gendec in line 14 20-23. NOTE: Invalid data for genderb in line 14 25-28. NOTE: Invalid data for sex_o in line 14 30-40. NOTE: Invalid data for housing_status in line 14 42-53. NOTE: Invalid data for sessiondate in line 14 55-72. NOTE: Invalid data for age in line 14 74-82. NOTE: Invalid data for condom in line 14 87-88. NOTE: Invalid data for risk in line 14 90-103. 14 Not Received,White,Male,Male,Gay/Lesbian,Not Homeless,West Hollywood MTU,28-Apr-18,61,No,Did use con 101 dom,Low 107 rapid_syphilis=. race=. gendec=. genderb=. sex_o=. housing_status=. sessiondate=. age=. druguse=61 condom=. risk=. _ERROR_=1 _N_=13 NOTE: Invalid data for rapid_syphilis in line 15 1-12. NOTE: Invalid data for race in line 15 14-18. NOTE: Invalid data for gendec in line 15 20-23. NOTE: Invalid data for genderb in line 15 25-28. NOTE: Invalid data for sex_o in line 15 30-40. NOTE: Invalid data for housing_status in line 15 42-53. NOTE: Invalid data for sessiondate in line 15 55-72. NOTE: Invalid data for age in line 15 74-82. NOTE: Invalid data for condom in line 15 87-88. NOTE: Invalid data for risk in line 15 90-107. 15 Not Received,White,Male,Male,Gay/Lesbian,Not Homeless,West Hollywood MTU,28-Apr-18,31,No,Did not use 101 condom,High 112 rapid_syphilis=. race=. gendec=. genderb=. sex_o=. housing_status=. sessiondate=. age=. druguse=31 condom=. risk=. _ERROR_=1 _N_=14 NOTE: Invalid data for rapid_syphilis in line 16 1-12. NOTE: Invalid data for race in line 16 14-35. NOTE: Invalid data for gendec in line 16 37-40. NOTE: Invalid data for genderb in line 16 42-45. NOTE: Invalid data for sex_o in line 16 47-57. NOTE: Invalid data for housing_status in line 16 59-70. NOTE: Invalid data for sessiondate in line 16 72-89. NOTE: Invalid data for age in line 16 91-99. NOTE: Invalid data for condom in line 16 104-105. NOTE: Invalid data for risk in line 16 107-124. 16 Not Received,Black/African American,Male,Male,Gay/Lesbian,Not Homeless,West Hollywood MTU,28-Apr-18, 101 38,No,Did not use condom,High 129 rapid_syphilis=. race=. gendec=. genderb=. sex_o=. housing_status=. sessiondate=. age=. druguse=38 condom=. risk=. _ERROR_=1 _N_=15 NOTE: Invalid data for rapid_syphilis in line 17 1-12. NOTE: Invalid data for race in line 17 14-18. NOTE: Invalid data for gendec in line 17 20-23. NOTE: Invalid data for genderb in line 17 25-28. NOTE: Invalid data for sex_o in line 17 30-40. NOTE: Invalid data for housing_status in line 17 42-53. NOTE: Invalid data for sessiondate in line 17 55-72. NOTE: Invalid data for age in line 17 74-82. NOTE: Invalid data for condom in line 17 87-88. NOTE: Invalid data for risk in line 17 90-107. 17 Not Received,White,Male,Male,Gay/Lesbian,Not Homeless,West Hollywood MTU,28-Apr-18,55,No,Did not use 101 condom,High 112 rapid_syphilis=. race=. gendec=. genderb=. sex_o=. housing_status=. sessiondate=. age=. druguse=55 condom=. risk=. _ERROR_=1 _N_=16 NOTE: Invalid data for rapid_syphilis in line 18 1-12. NOTE: Invalid data for race in line 18 14-18. NOTE: Invalid data for gendec in line 18 20-23. NOTE: Invalid data for genderb in line 18 25-28. NOTE: Invalid data for sex_o in line 18 30-40. NOTE: Invalid data for housing_status in line 18 42-53. NOTE: Invalid data for sessiondate in line 18 55-72. NOTE: Invalid data for age in line 18 74-82. NOTE: Invalid data for condom in line 18 87-88. NOTE: Invalid data for risk in line 18 90-107. RULE: ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0 18 Not Received,White,Male,Male,Gay/Lesbian,Not Homeless,West Hollywood MTU,28-Apr-18,21,No,Did not use 101 condom,High 112 rapid_syphilis=. race=. gendec=. genderb=. sex_o=. housing_status=. sessiondate=. age=. druguse=21 condom=. risk=. _ERROR_=1 _N_=17 NOTE: Invalid data for rapid_syphilis in line 19 1-12. NOTE: Invalid data for race in line 19 14-18. NOTE: Invalid data for gendec in line 19 20-23. NOTE: Invalid data for genderb in line 19 25-28. NOTE: Invalid data for sex_o in line 19 30-40. NOTE: Invalid data for housing_status in line 19 42-53. NOTE: Invalid data for sessiondate in line 19 55-72. NOTE: Invalid data for age in line 19 74-82. NOTE: Invalid data for condom in line 19 87-88. NOTE: Invalid data for risk in line 19 90-107. 19 Not Received,White,Male,Male,Gay/Lesbian,Not Homeless,West Hollywood MTU,28-Apr-18,18,No,Did not use 101 condom,High 112 rapid_syphilis=. race=. gendec=. genderb=. sex_o=. housing_status=. sessiondate=. age=. druguse=18 condom=. risk=. _ERROR_=1 _N_=18 NOTE: Invalid data for rapid_syphilis in line 20 1-12. NOTE: Invalid data for race in line 20 14-18. NOTE: Invalid data for gendec in line 20 20-23. NOTE: Invalid data for genderb in line 20 25-28. NOTE: Invalid data for sex_o in line 20 30-40. NOTE: Invalid data for housing_status in line 20 42-53. NOTE: Invalid data for sessiondate in line 20 55-72. NOTE: Invalid data for age in line 20 74-82. NOTE: Invalid data for condom in line 20 87-88. NOTE: Invalid data for risk in line 20 90-103. 20 Not Received,Asian,Male,Male,Gay/Lesbian,Not Homeless,West Hollywood MTU,28-Apr-18,26,No,Did use con 101 dom,Low 107 rapid_syphilis=. race=. gendec=. genderb=. sex_o=. housing_status=. sessiondate=. age=. druguse=26 condom=. risk=. _ERROR_=1 _N_=19 NOTE: Invalid data for rapid_syphilis in line 21 1-12. NOTE: Invalid data for race in line 21 14-18. NOTE: Invalid data for gendec in line 21 20-23. NOTE: Invalid data for genderb in line 21 25-28. NOTE: Invalid data for sex_o in line 21 30-41. NOTE: Invalid data for housing_status in line 21 43-54. NOTE: Invalid data for sessiondate in line 21 56-73. NOTE: Invalid data for age in line 21 75-83. NOTE: Invalid data for condom in line 21 88-89. NOTE: Invalid data for risk in line 21 91-108. WARNING: Limit set by ERRORS= option reached. Further errors of this type will not be printed. 21 Not Received,Asian,Male,Male,Heterosexual,Not Homeless,West Hollywood MTU,28-Apr-18,22,No,Did not us 101 e condom,High 113 rapid_syphilis=. race=. gendec=. genderb=. sex_o=. housing_status=. sessiondate=. age=. druguse=22 condom=. risk=. _ERROR_=1 _N_=20 NOTE: 6981 records were read from the infile '/home/u49152646/EPG194/rapid_syphilis/sample.csv'. The minimum record length was 90. The maximum record length was 155. NOTE: The data set WORK.SAMPLE has 6981 observations and 11 variables. NOTE: DATA statement used (Total process time): real time 0.03 seconds user cpu time 0.01 seconds system cpu time 0.00 seconds memory 1407.65k OS Memory 33452.00k Timestamp 08/05/2020 03:52:58 PM Step Count 120 Switch Count 2 Page Faults 0 Page Reclaims 251 Page Swaps 0 Voluntary Context Switches 20 Involuntary Context Switches 0 Block Input Operations 1200 Block Output Operations 1288 77 78 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; SYMBOLGEN: Macro variable GRAPHTERM resolves to GOPTIONS NOACCESSIBLE; 90 ... View more

So i see that the s drive is not on my computer or on SAS studio...My folder and csv file were the first thing i uploaded into files and folder shortcuts....Can you look at the code and tell me why it keeps saying file does not exist....and I watched the videos that's where I noticed the s drive was missing. proc import datafile= '/home/u49152646/EPG194/rapid_syphilis.csv' DBMS= CSV out= work.import replace; run; Log: 1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; SYMBOLGEN: Macro variable _SASWSTEMP_ resolves to /home/u49152646/.sasstudio/.images/df44adc9-fc7c-4f0d-819e-04c0171340b2 SYMBOLGEN: Some characters in the above value which were subject to macro quoting have been unquoted for printing. SYMBOLGEN: Macro variable GRAPHINIT resolves to GOPTIONS RESET=ALL GSFNAME=_GSFNAME; 72 73 proc import datafile= '/home/u49152646/EPG194/rapid_syphilis.csv' 74 DBMS= CSV 75 out= work.import replace; 76 run; NOTE: Unable to open parameter catalog: SASUSER.PARMS.PARMS.SLIST in update mode. Temporary parameter values will be saved to WORK.PARMS.PARMS.SLIST. ERROR: Physical file does not exist, /home/u49152646/EPG194/rapid_syphilis.csv. ERROR: Import unsuccessful. See SAS Log for details. NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE IMPORT used (Total process time): real time 0.02 seconds user cpu time 0.02 seconds system cpu time 0.00 seconds memory 8220.50k OS Memory 39196.00k Timestamp 08/05/2020 03:15:33 PM Step Count 78 Switch Count 5 Page Faults 0 Page Reclaims 1115 Page Swaps 0 Voluntary Context Switches 26 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 40 ... View more

/*Import a CSV File*/ options Mprint Mlogic SGEN; %let path=S:\CSV Import; options validvarname=v7; proc import datafile= "s:\CSV Import\rapid_syphilis.csv" out=syphilis dbms=csv replace; run; This is my log: 1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; SYMBOLGEN: Macro variable _SASWSTEMP_ resolves to /home/u49152646/.sasstudio/.images/b114a1e4-9dfe-4060-b4d9-b3e222d0734a SYMBOLGEN: Some characters in the above value which were subject to macro quoting have been unquoted for printing. SYMBOLGEN: Macro variable GRAPHINIT resolves to GOPTIONS RESET=ALL GSFNAME=_GSFNAME; 72 73 /*Import a CSV File*/ 74 options Mprint Mlogic SGEN; 75 76 %let path=S:\CSV Import; 77 options validvarname=v7; 78 79 proc import datafile= "s:\CSV Import\rapid_syphilis.csv" 80 out=syphilis 81 dbms=csv replace; 82 run; NOTE: Unable to open parameter catalog: SASUSER.PARMS.PARMS.SLIST in update mode. Temporary parameter values will be saved to WORK.PARMS.PARMS.SLIST. ERROR: Physical file does not exist, /pbr/biconfig/940/Lev1/SASApp/s:\CSV Import\rapid_syphilis.csv. ERROR: Import unsuccessful. See SAS Log for details. NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE IMPORT used (Total process time): real time 0.02 seconds user cpu time 0.02 seconds system cpu time 0.01 seconds memory 8217.00k OS Memory 39452.00k Timestamp 08/05/2020 05:14:25 AM Step Count 133 Switch Count 5 Page Faults 0 Page Reclaims 1183 Page Swaps 0 Voluntary Context Switches 25 Involuntary Context Switches 1 Block Input Operations 0 Block Output Operations 40 83 84 85 86 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; SYMBOLGEN: Macro variable GRAPHTERM resolves to GOPTIONS NOACCESSIBLE; 98 ... View more

SAS on demand for Academics  ... View more

libname syphilis "/home/u49152645/syphilis"; Note: 1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 72 73 libname syphilis "/home/u49152645/syphilis"; NOTE: Library SYPHILIS does not exist. 74 75 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 87 ... View more

Now it says libname is not assigned...I am sorry for bugging you..I am really new at this.  ... View more

Sorry about that. I changed it to sample ... View more

NOTE: PROCEDURE IMPORT used (Total process time): real time 0.00 seconds user cpu time 0.00 seconds system cpu time 0.00 seconds memory 204.09k OS Memory 30372.00k Timestamp 08/04/2020 07:23:15 PM Step Count 24 Switch Count 0 Page Faults 0 Page Reclaims 63 Page Swaps 0 Voluntary Context Switches 0 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 0 NOTE: The SAS System stopped processing this step because of errors. ... View more

NOTE: The SAS System stopped processing this step because of errors. 77 proc import datafile= s:\CSV Import\rapid_syphilis.csv _ 22 200 ERROR 22-322: Syntax error, expecting one of the following: ;, DATAFILE, DATATABLE, DBMS, DEBUG, FILE, OUT, REPLACE, TABLE, _DEBUG_. ERROR 200-322: The symbol is not recognized and will be ignored. 78 out=sample_8.3.2020.csv _____ 22 76 ERROR 22-322: Syntax error, expecting one of the following: ;, (, DATAFILE, DATATABLE, DBMS, DEBUG, FILE, OUT, REPLACE, TABLE, _DEBUG_. ERROR 76-322: Syntax error, statement will be ignored. 79 dbms=csv replace; 80 run; 81 ... View more