Sentry Page Protection
**** Question 1 ****;
** BORROWED.CSV **; filename borrowed '/folders/myfolders/proc import files/exercises/borrowed.csv'; proc import datafile=borrowed dbms=csv out =borrowed replace; guessingrows=max; run; ** DEMOGRAPHICS.CSV **; filename demo '/folders/myfolders/proc import files/exercises/demographics.csv'; proc import datafile=demo dbms=csv out =demo replace; guessingrows=max; run; ** Q8.CSV **; filename q8 '/folders/myfolders/proc import files/exercises/q8.csv'; proc import datafile=q8 dbms=csv out =q8 replace; guessingrows=max; run; **** Question 2 ****; ** RISK STRATIFICATION.XLSX **; ** Method 1 **; libname risk xlsx '/folders/myfolders/proc import files/exercises/risk stratification.xlsx'; ** Method 2 **; filename risk '/folders/myfolders/proc import files/exercises/risk stratification.xlsx'; proc import datafile=risk dbms=xlsx out =risk replace; run; ** ADC.XLSX **; ** Method 1 **; libname adc xlsx '/folders/myfolders/proc import files/exercises/adc.xlsx'; ** Method 2 **; filename adc '/folders/myfolders/proc import files/exercises/adc.xlsx'; proc import datafile=adc dbms=xlsx out =adc replace; sheet = 'QUERY RESULTS'; run; proc import datafile=adc dbms=xlsx out =adc replace; sheet = 'SUMMARY'; run; ** GENE.XLSX **; ** Method 1 **; libname gene xlsx '/folders/myfolders/proc import files/exercises/gene.xlsx'; ** Method 2 **; filename gene '/folders/myfolders/proc import files/exercises/gene.xlsx'; proc import datafile=gene dbms=xlsx out =gene replace; sheet = 'DATA'; run; proc import datafile=gene dbms=xlsx out =gene replace; sheet = 'TRANSPOSED'; run; ** RANCOL.XLSX **; ** Method 1 **; libname rancol xlsx '/folders/myfolders/proc import files/exercises/rancol.xlsx'; ** Method 2 **; filename rancol '/folders/myfolders/proc import files/exercises/rancol.xlsx'; proc import datafile=rancol dbms=xlsx out =rancol replace; run; **** Question 3 ****; ** HOTELS.TXT **; filename hotels '/folders/myfolders/proc import files/exercises/hotels.txt'; proc import datafile=hotels dbms=tab out =hotels replace; delimiter = '09'x; guessingrows=max; run; ** BEATLES.TXT **; filename beatles '/folders/myfolders/proc import files/exercises/beatles.txt'; proc import datafile=beatles dbms=dlm out =beatles replace; delimiter = ';'; guessingrows=max; run; ** SURVEY.TXT **; filename survey '/folders/myfolders/proc import files/exercises/survey.txt'; proc import datafile=survey dbms=dlm out =survey replace; delimiter = ','; guessingrows=max; run; |