Skip to main content

Importing a CSV file in SAS - Knowledgebase / Horizon VDI - SOMTech (Technology Services) - VCU School of Medicine

Importing a CSV file in SAS

Authors list
  • Ensure the file is in an accessible location, ideally Mapping a Network Drive to access Data in Horizon

  • Open Command Prompt

  • Paste appropriate file location link

    • Ex: “c:\Program Files\SASHome\SASFoundation\9.4\sas” -WORK "P:\yourprojectfolder\temp"

  • In SAS, File – Import Data –.csv – next

  • Browse for file:

    • Navigate to mapped drive – yourprojectfolder– source – All files

  • Select the file – Open – Next

  • Member: yourcsvfile– Next

  • Browse to data folder – name the file – Save – Finish

  • Navigating back to the TEMP folder and right-click on properties to verify progress

  • Data will load in SAS window


Note: GREY identifies specific project/data location and will change by project/user


Helpful Unhelpful