Hi All,    So I am reading a .csv file into SASUniversity and I am having an issue. All of the data should be numeric with exception to a handful. For some reason they are reading in as the first have Character and the last half numeric. I have my code below, is there a post-fix or something I need to add to get these to read in as numeric? For reference, the variable names that follow with $8 are those that are supposed to be character, everything else should be numeric.    Any help would be appreciated!    data IHC.main; infile '/folders/myfolders/IHC/EMainTable.csv' firstobs=2 dlm=',' lrecl=32000 truncover DSD; length Newid Icupt Dschrg_dspstn_cd Mortly_indctr_cd Primdischdiagcd Primdishdiag $8 Admitdiagcd1 Admitdiag1 $8 Male Age Imrs Imrsgroup Imrsgroup3 Rvitestresult Cvhx Hearrate Resprate Sbp dbp Bmi Minapache Maxapache Hypertensionhx Hyperlipidemiahx Diabhx Mihx Cadhx Cvahx Tobaccohx Pttype $8 Afibhx Dysrhythmiahx Chfhx Copdhx Respfailhx Renalfailhx Liverfailhx Tiahx Alcoholabusehx Drugabusehx Race $8 Pneumonia Adeno H1ni Hmpv Flua Flub Para Rhino Rsv Corona Bnppreclosest Bnppremax Bnpindexhospmax Bnpost90dymax Esrindexhospax Gfrindexhospmin Tropiindexhospmax Tropipost90dymax Sp02indexhospmin Staphaureusindexhosp Streppneumoindexhosp Afibindexhosp Chestpainindexhosp Chfindexhosp Cvaindexhosp Dysrhythmiaindexhosp Fallindexhosp Liverfailindexhosp Malaiseindexhosp Miindexhosp Respfailindexhosp Sepsisindexhosp Sobindexhosp Wheezeindexhosp Coughindexhosp Sputum Feverindexhosp Temp Fever Wbc Dxleukocytosis Leukosytosis Crphsindexhospmax Elevatedcrp Dxhypoxemia Hypoxemia Anydrug Antibiotic Anticoagulant Anticoagulantother Antiplatelet Antiviral Betablocker Ccb Corticosteriod Statin Warfarin Fvc Fivc Tlc Frc_n2 Fef25_75 Pef Fev1 Fev2 Fev3 Fev5 Fev6 Fev75 Dlco Vc Upperrespinfection Tuberculosis Bronchiolitis Bronchitis Bacterialpneumonia Viralpneumonia Infectiouspneumonia Influenza Infection Anypneumtest Pntestresult $8 Cpneumo Npneumo Streppneumo Anybactest Anybacpositive Anylungbactest Lungbacpositive dead Cvdeathhosp Timetodeath Cvprimcauseofdeath Cvaprimcod Miprimcod Mifu Timetomi Cvafu Timetocva Chfifu timetochf ; input Newid Icupt Dschrg_dspstn_cd Mortly_indctr_cd Primdischdiagcd Primdishdiag Admitdiagcd1 Admitdiag1 Male Age Imrs Imrsgroup Imrsgroup3 Rvitestresult Cvhx Hearrate Resprate Sbp dbp Bmi Minapache Maxapache Hypertensionhx Hyperlipidemiahx Diabhx Mihx Cadhx Cvahx Tobaccohx Pttype Afibhx Dysrhythmiahx Chfhx Copdhx Respfailhx Renalfailhx Liverfailhx Tiahx Alcoholabusehx Drugabusehx Race Pneumonia Adeno H1ni Hmpv Flua Flub Para Rhino Rsv Corona Bnppreclosest Bnppremax Bnpindexhospmax Bnpost90dymax Esrindexhospax Gfrindexhospmin Tropiindexhospmax Tropipost90dymax Sp02indexhospmin Staphaureusindexhosp Streppneumoindexhosp Afibindexhosp Chestpainindexhosp Chfindexhosp Cvaindexhosp Dysrhythmiaindexhosp Fallindexhosp Liverfailindexhosp Malaiseindexhosp Miindexhosp Respfailindexhosp Sepsisindexhosp Sobindexhosp Wheezeindexhosp Coughindexhosp Sputum Feverindexhosp Temp Fever Wbc Dxleukocytosis Leukosytosis Crphsindexhospmax Elevatedcrp Dxhypoxemia Hypoxemia Anydrug Antibiotic Anticoagulant Anticoagulantother Antiplatelet Antiviral Betablocker Ccb Corticosteriod Statin Warfarin Fvc Fivc Tlc Frc_n2 Fef25_75 Pef Fev1 Fev2 Fev3 Fev5 Fev6 Fev75 Dlco Vc Upperrespinfection Tuberculosis Bronchiolitis Bronchitis Bacterialpneumonia Viralpneumonia Infectiouspneumonia Influenza Infection Anypneumtest Pntestresult Cpneumo Npneumo Streppneumo Anybactest Anybacpositive Anylungbactest Lungbacpositive dead Cvdeathhosp Timetodeath Cvprimcauseofdeath Cvaprimcod Miprimcod Mifu Timetomi Cvafu Timetocva Chfifu timetochf; run; ... View more

Hi All,    So I am still a bit new to SAS. I am using SAS University and I accidentally let me license laps, so I have SAS University redownloaded, but I am needing to re-import my data that I lost access to when my license lapsed.    I have done this before, but this time around I cannot for the life of me get the data read into SAS :(.    I am using the following code:    data IHC.Emain; infile '/Users/scott/Documents/Folders/MyFolders/EMainTable.csv' firstobs=2 dlm=',' lrecl=32000 truncover DSD; length Newid Icupt Dschrg_dspstn_cd Mortly_indctr_cd Primdischdiagcd $ 8 Primdishdiag Admitdiagcd1 $ 8 Admitdiag1 Male Age Imrs Imrsgroup Imrsgroup3 Rvitestresult Cvhx Hearrate Resprate Sbp dbp Bmi Minapache Maxapache Hypertensionhx Hyperlipidemiahx Diabhx Mihx Cadhx Cvahx Tobaccohx Pttype $ 8 Afibhx Dysrhythmiahx Chfx Copdhx Respfailhx Renalfailhx Liverfailhx Tiahx Alcoholabusehx Drugabusehx Race $ 8 Pneumonia Adeno H1ni Hmpv Flua Flub Para Rihino Rsv Corona Bnppreclosest Bnppremax Bnpindexhospmax Bnpost90dymax Esrindexhospax Gfrindexhospmin Tropiindexhospmax Tropipost90dymax Sp02indexhospmin Staphaureusindexhosp Streppneumoindexhosp Afibindexhosp Chestpainindexhosp Chfindexhosp Cvaindexhosp Dysrhythmiaindexhosp Fallindexhosp Liverfailindexhosp Malaiseindexhosp Miindexhosp Respfailindexhosp Sepsisindexhosp Sobindexhosp Wheezeindexhosp Coughindexhosp Sputum Feverindexhosp Temp Fever Wbc Dxleukocytosis Leukosytosis Crphsindexhospmax Elevatedcrp Dxhypoxemia Hypoxemia Anydrug Antibiotic Anticoagulant Anticoagulantother Antiplatelet Antiviral Betablocker Ccb Corticosteriod Statin Warfarin Fvc Fivc Tlc Frc_n2 Fef25_75 Pef Fev1 Fev2 Fev3 Fev5 Fev6 Fev75 Dlco Vc Upperrespinfection Tuberculosis Bronchiolitis Bronchitis Bacterialpneumonia Viralpneumonia Infectiouspneumonia Influenza Infection Anypneumtest Pntestresult $ 8 Cpneumo Npneumo Streppneumo Anybactest Anybacpositive Anylungbactest Lungbacpositive dead Cvdeathhosp Timetodeath Cvprimcauseofdeath Cvaprimcod Miprimcod Mifu Timetomi Cvafu Timetocva Chfifu timetochf 8; input Newid Icupt Dschrg_dspstn_cd Mortly_indctr_cd Primdischdiagcd Primdishdiag Admitdiagcd1 Admitdiag1 Male Age Imrs Imrsgroup Imrsgroup3 Rvitestresult Cvhx Hearrate Resprate Sbp dbp Bmi Minapache Maxapache Hypertensionhx Hyperlipidemiahx Diabhx Mihx Cadhx Cvahx Tobaccohx Pttype Afibhx Dysrhythmiahx Chfx Copdhx Respfailhx Renalfailhx Liverfailhx Tiahx Alcoholabusehx Drugabusehx Race Pneumonia Adeno H1ni Hmpv Flua Flub Para Rihino Rsv Corona Bnppreclosest Bnppremax Bnpindexhospmax Bnpost90dymax Esrindexhospax Gfrindexhospmin Tropiindexhospmax Tropipost90dymax Sp02indexhospmin Staphaureusindexhosp Streppneumoindexhosp Afibindexhosp Chestpainindexhosp Chfindexhosp Cvaindexhosp Dysrhythmiaindexhosp Fallindexhosp Liverfailindexhosp Malaiseindexhosp Miindexhosp Respfailindexhosp Sepsisindexhosp Sobindexhosp Wheezeindexhosp Coughindexhosp Sputum Feverindexhosp Temp Fever Wbc Dxleukocytosis Leukosytosis Crphsindexhospmax Elevatedcrp Dxhypoxemia Hypoxemia Anydrug Antibiotic Anticoagulant Anticoagulantother Antiplatelet Antiviral Betablocker Ccb Corticosteriod Statin Warfarin Fvc Fivc Tlc Frc_n2 Fef25_75 Pef Fev1 Fev2 Fev3 Fev5 Fev6 Fev75 Dlco Vc Upperrespinfection Tuberculosis Bronchiolitis Bronchitis Bacterialpneumonia Viralpneumonia Infectiouspneumonia Influenza Infection Anypneumtest Pntestresult Cpneumo Npneumo Streppneumo Anybactest Anybacpositive Anylungbactest Lungbacpositive dead Cvdeathhosp Timetodeath Cvprimcauseofdeath Cvaprimcod Miprimcod Mifu Timetomi Cvafu Timetocva Chfifu timetochf; run;   and I get the following error:    ERROR: The path /Users/scott/Documents/MyFolders/EMainTable.csv is not in the list of accessible paths when SAS is in the lockdown state.   I have tried replacing "/Users/scott/Documents/MyFolders" with "/folders" but when I do that I get the following error:    ERROR: Physical file does not exist, /folders/MyFolders/EMainTable.csv.   I checked and the folder the data file is in is the one I have shared with the virtual machine I am using, it has full access and it is set to auto-mount.    I just don't know what I am doing wrong this time... any help or insight would be appreciated! ... View more