SAS on demand for Academics
@Kimberly_2020 wrote:
SAS on demand for Academics
This means your SAS runs in the AWS cloud on Linux and does not have access to your desktop environment, which includes the S: drive.
You need to upload your file first with SAS Studio. After that, you can get the correct path to it by right-clicking on it in the SAS Studio navigation pane.
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
When SAS tells you a file is not there, it's not there.
Did you copy/paste the file path from the navigation pane in SAS Studio?
Mind that the Linux system of SAS ODA is case sensitive, so correct spelling of pathnames is essential.
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
I finally got it!! Thank you for all your help!
The tutorials found here also cover uploading your data.
Did your teacher/tutor not guide you to these pages?
/*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
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
The filename should be in quotes
proc import datafile= "s:\CSV Import\rapid_syphilis.csv"
The only output Proc Import will create is a SAS data set. Not CSV.
So you specify a library name and data set name.
out= libname.dataset
which uses a single dot between the SAS library name and the data set name. Multiple dots are right out. Data set names can only have letters, digits and the _ character.
If you later want to send SAS data out to a CSV file you would use Proc Export.
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.
No it gave me syntax error..and it didn't work with it
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
SAS' Charu Shankar shares her PROC SQL expertise by showing you how to master the WHERE clause using real winter weather data.
Find more tutorials on the SAS Users YouTube channel.