Solved: Physical file does not exist - Page 2

Kimberly_2020 · Posted 08-05-2020 01:18 AM

SAS on demand for Academics

Kurt_Bremser · Posted 08-05-2020 01:33 AM

@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.

Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
The macro for direct download as ZIP
How to post code
Please vote for Provide Sequential Search Capability for Hash Objects
How to deal with locked files on UNIX

Kimberly_2020 · Posted 08-05-2020 11:17 AM

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

Kurt_Bremser · Posted 08-05-2020 12:41 PM

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.

Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
The macro for direct download as ZIP
How to post code
Please vote for Provide Sequential Search Capability for Hash Objects
How to deal with locked files on UNIX

Kimberly_2020 · Posted 08-05-2020 12:55 PM

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

Kimberly_2020 · Posted 08-05-2020 01:17 PM

I finally got it!! Thank you for all your help!

Kurt_Bremser · Posted 08-05-2020 01:40 AM

The tutorials found here also cover uploading your data.

Did your teacher/tutor not guide you to these pages?

Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
The macro for direct download as ZIP
How to post code
Please vote for Provide Sequential Search Capability for Hash Objects
How to deal with locked files on UNIX

Kimberly_2020 · Posted 08-05-2020 01:20 AM

/*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

Kimberly_2020 · Posted 08-04-2020 03:29 PM

 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

ballardw · Posted 08-04-2020 04:04 PM

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.

Kimberly_2020 · Posted 08-04-2020 03:31 PM

 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.

Reeza · Posted 08-04-2020 03:10 PM

Does the code work without any macro variables?

Kimberly_2020 · Posted 08-04-2020 03:14 PM

No it gave me syntax error..and it didn't work with it

Re: Physical file does not exist

Re: Physical file does not exist

Re: Physical file does not exist

Re: Physical file does not exist

Re: Physical file does not exist

Re: Physical file does not exist

Re: Physical file does not exist

Re: Physical file does not exist

Re: Physical file does not exist

Re: Physical file does not exist

Re: Physical file does not exist

Re: Physical file does not exist

Re: Physical file does not exist

Ready to join fellow brilliant minds for the SAS Hackathon?