Thanks a lot for the help! Now the programme (finally!) works. I ended up not typing in the names, but using the var2-var2464 names, as I found it that was sufficient.
Thank you for the advises. I ended up saving the dataset in a xlsx file (each table in a seperate sheet) in stead of a csv file for each table, and now it works okay, but the programme runs much slower.
The commands:
Proc import datafile="/folders/myfolders/WIO.xlsx"
OUT=WIO&i
DBMS=XLSX
REPLACE;
Getnames=no;
sheet=WIO&i;
RUN;
So, you ignored all the advice above, choose to go with the worst possible data file format, and now your program doesn't run as quickly, and likely has many issues with the data elements or the guessing of things. You see where I am going with this...
CSV is text, straight import, Excel is a ZIP file with various subfolders and linked XML files, far more resource need to process the later.
Your right! Maybe a stupid choice by me, but I am quite new to this. I actually thought it would be better with xlsx in stead of csv after reading your advise, but I was very wrong I guess. Now I am trying with csv and another code (see above).
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.
Select SAS Training centers are offering in-person courses. View upcoming courses for: