Hi, i finanlly read an excel table with 5000 columns and 100 rows into SAS now the task is to correct the variable types, informats and formats, since SAS probably didnt get them all right. To this purpose, i have another excel table, say informationtable, documenting the right types and formates etc. (you can image a table with 2 colums and 5000 rows, the first column lists the variables names and the second column contains statements like 'long text', 'number without decimal places', 'procent with two decimal places', 'dates' and so on). now i would like to correct the data with the values from the informationtable. I dont know how to do it with such a big number of variables that i am having. I am thinking about joining the tables together and using 'where'. can somehow help me with the code? thanks very much. BR  Dingdang ... View more

Hi, I've been trying to import an excel table with around 5000 columns (variables) and 100 rows (observations) into SAS 9.2. This is directly not possible, while SAS can only import 255 variables at a time. I tried converting my table into .txt data with Tab delimited. Somehow in this process, some variable names went wrong. I am guessing because in my original table there are cells that contain a lot of characters and texts. So if i read this .txt data into SAS, I only got some of the variable names right. the others are renamed by SAS to VAR. I looked up this in internet, and it says it might be caused, because some names contain multiple spaces. I can copy the log and do the correction per hand, but with the number of variables i am having, this will take long and since i probably only need to import the data once (not once every month or sth. ), this is really not my first option. I thought about transposing the excel data first and in that case, i only have 100 variables. SAS can read all of them at a time and then i can transpose them back, but the problem is, some characters were showed as 'missing values' after the import, which i dont quite understand why. Can someone please share his/her experience with me reading such a dataset into SAS? I am very grateful for any kind of tipps or suggestions. BR  Dingdang ... View more

Hi, I know there are already a lot of old posts to this question. I read them through but I still cannot solve my problem. I have an excel table with more than 255 columns. that is why i saved the excel data to a .txt data with tab-delimited values. and then i used the following code to read it into SAS: PROC IMPORT OUT=libl.texttest DATAFILE="R:\Test\myfile.txt"; DBMS=DLM REPLACE; GETNAMES=YES; DELIMITER='09'x; SCANTEXT=YES; RUN; when i look at the log, it shows error 180-322. can someone help me solve this problem or give me a hint, how it came out like this? I am very grateful for that. BR  Dingdang ... View more