Hi, so I'm having a bit of trouble with importing this dataset because it has to come from a weblink for reproducibility. I am working in Jupyter Notebook through SAS University Edition. I have to take the following three datasets from a larger one on natality and merge them into one dataset containing the variables I select with keep. I'm a little unsure why it's not working. options nosource nonotes errors=0;
filename nat1 url "https://uofi.box.com/shared/static/gb07nz7jafspk65wzxq6awlu02kypiq7.csv" termstr=crlf;
filename nat10 url "https://uofi.box.com/shared/static/xf7r94alpzaqv4wxh5liqw7rpk21wb6l.csv" termstr=crlf;
filename nat20 url "https://uofi.box.com/shared/static/eq9k4d73ansal5p8mspu3mpslmzs7x8g.csv" termstr=crlf;
proc import datafile=nat1 out=var1(keep = M_Ht_In BMI PWgt_R DWgt_R RF_PDIAB RF_GDIAB RF_PHYPE RF_GHYPE RF_EHYPE RF_PPTERM RF_CESAR ME_PRES ATTEND PAY_REC APGAR5 APGAR10 AB_NICU BFED priorlive priordead mrace6 frace6 dplural OEGest_R3 SEX MAGER **bleep**ECOMB MEDUC FEDUC PREVIS_REC previs CIG_REC WTGAIN DMETH_REC dbwt) replace dbms=csv;
run;
proc import datafile=nat10 out=var2(keep = M_Ht_In BMI PWgt_R DWgt_R RF_PDIAB RF_GDIAB RF_PHYPE RF_GHYPE RF_EHYPE RF_PPTERM RF_CESAR ME_PRES ATTEND PAY_REC APGAR5 APGAR10 AB_NICU BFED priorlive priordead mrace6 frace6 dplural OEGest_R3 SEX MAGER **bleep**ECOMB MEDUC FEDUC PREVIS_REC previs CIG_REC WTGAIN DMETH_REC dbwt) replace dbms=csv;
run;
proc import datafile=nat20 out=var3(keep = M_Ht_In BMI PWgt_R DWgt_R RF_PDIAB RF_GDIAB RF_PHYPE RF_GHYPE RF_EHYPE RF_PPTERM RF_CESAR ME_PRES ATTEND PAY_REC APGAR5 APGAR10 AB_NICU BFED priorlive priordead mrace6 frace6 dplural OEGest_R3 SEX MAGER **bleep**ECOMB MEDUC FEDUC PREVIS_REC previs CIG_REC WTGAIN DMETH_REC dbwt) replace dbms=csv;
run;
data nat;
set var1 var2 var3;
run; I run into the following error, which isn't very helpful to me because I know these datasets do exist and are accessible, so I'm not really sure how to approach this error. ERROR: Physical file does not exist, https://uofi.box.com/shared/static/gb07nz7jafspk65wzxq6awlu02kypiq7.csv. ERROR: Import unsuccessful. See SAS Log for details. ERROR: Physical file does not exist, https://uofi.box.com/shared/static/xf7r94alpzaqv4wxh5liqw7rpk21wb6l.csv. ERROR: Import unsuccessful. See SAS Log for details. ERROR: Physical file does not exist, https://uofi.box.com/shared/static/eq9k4d73ansal5p8mspu3mpslmzs7x8g.csv. ERROR: Import unsuccessful. See SAS Log for details. ERROR: File WORK.NAT01.DATA does not exist. ERROR: File WORK.NAT02.DATA does not exist. ERROR: File WORK.NAT03.DATA does not exist.
... View more
