proc import datafile='F:\B04a.csv' out=want dbms=csv replace; run; Thanks,Jag 0 Likes dapenDaniel Obsidian | Level 7 Re: Import CSV into SAS Posted 09-22-2018 10:05 PM (17198 views) | In reply to Jagadishkatam I tried it but this code cannot solve the two problems I...
Without using any start-up code, I will be able to see all of the .sas7bdat files in (.csv files and .xlsx files need to be converted to the .sas7bdat format first)There are definitely more ways to import data into SAS OnDemand for Academics: E...
Without using any start-up code, I will be able to see all of the .sas7bdat files in (.csv files and .xlsx files need to be converted to the .sas7bdat format first)There are definitely more ways to import data into SAS OnDemand for Academics: Ent...
dbjosiah Obsidian | Level 7 Re: PROC Import - why is it creating an automatic variable name? Posted 06-15-2021 11:32 AM (6670 views) | In reply to ballardw Thanks everyone. I'm guessing from the array of answers that there's no easy fix here. In response to your...
ashna Obsidian | Level 7 Re: Import excel with DateTime format in SAS Data Integration Studio Posted 02-17-2019 11:38 PM (6064 views) | In reply to ChrisNZ Nope, I don't have any strings in the column. As mentioned before, few of the cells or observations in ...
marcel Obsidian | Level 7 Re: Cannot import excel file (xls) into SAS 9.4 version in window 10 environment Posted 09-27-2020 06:22 PM (6477 views) | In reply to joon1 Hi, you could save your excel files as "xx.csv" files and that should give no problem at al...
Also, I would check with your IT, they may already have something in place (most have ticketing systems which use emails, so may be able to pull that data directly into a DB and you extract from there). 0 Likes Reply cmoore Obsidian | Level 7 Re: Import Data from Outlook fo...
avinashns Obsidian | Level 7 Re: SAS import text file Posted 02-28-2017 03:00 AM (2114 views) | In reply to ramya_sahu filename orders 'C:\orders.txt'; data want; infile orders firstobs=2; informat orderdate date7.; format orderdate date7.; input ID Orderdate Model $12. ...
makset Obsidian | Level 7 Re: Import data from a file sas7bdat to excel Posted 08-26-2014 10:16 AM (25417 views) | In reply to jakarman hello I have a question as to export to csv file if sas export the column format datetime21. csv file how to import it to excel ...