Hi Everyone,   I have 300 Excels files (file1, file2, file3.....file300) need to be read into SAS. Here is a hard code I tested and it runs well:   PROC IMPORT Out=output1 Datafile= "data\file1.xlsx" DBMS=XLSX REPLACE; SHEET='Sheet1'; GETNAMES=YES; Run;   Since it's not efficient to call the Macro variable 300 times by using: %Readin(file1); %Readin(file2); %Readin(file3);    ...    ... %Readin(file300);   So I use a do-loop in this case, but the code doesn't work. Do you have any suggestions that where I did incorrectly?    %macro Readin; %do i = 1 %to 300;       PROC IMPORT Out=output&i       Datafile= "data\file&i..xlsx"       DBMS=XLSX REPLACE;       SHEET='Sheet1';       GETNAMES=YES;       Run; %end %mend; %Readin;     Thank you, R.B   ... View more

Hi everyone,   I have a text file including several columns are all about customers' comments like this:    FilePath               Comments              Score 0937bj903.wav       I don't like your service at all balabala    Negative rt707bj690.wav    Great service         Positive      8897b66er.wav    No idea         Neutral   I have trouble reading this text file since the length of the column 'Comments' are not the same, so I am not able to define which column to start and end, which directly leads in mis-reading the column 'Score' as well. So I have to define the length of each column, but it's not working properly:   data test; length FilePath $ 13   Comments $ 30    Score$ 10; infile "data\file.txt" ; input FilePath $  Comments $   Score $ ; run;   Could you please give me some suggestions in how to dealing with this kind of text file?   Thank you in advance!   R.B ... View more

Hi,   The normal substr function is straight forward. For example , substr(var,2,6)  means substract from the 2nd place to the 6th place of var. Today I saw someone write a length function nested in substr function, do any of you know what does it mean? Substract from which place to which place?   SUBSTR(VAR,LENGTH(VAR)-4,5)   Thank you, Runrunbunny         ... View more

Hi, I would like to select 10 columns(var1 to var10) from a table:   Proc sql; select var1, var2, var3, var4, var5,var6,var7,var8,var9,var10 from table; quit;   Is there an convenient way to represent these variables instead of manually listing them? Thanks a lot!   runrunbunny ... View more

Hi SAS Users,   I have a problem when exporting a SAS file(235,009 observations) to an Excel file.   The code is:   PROC EXPORT DATA=SASFILE OUTFILE='P:\OUT\EXCELFILE.xlsx' DBMS=excel REPLACE; RUN;   However I got an error in the log:   ERROR: Execute: Unable to insert row WARNING: File deletion failed for _IMEX_.SASFILE.DATA. ERROR: Export unsuccessful. See SAS Log for details.   But there has not much information in the log. I checked the output folder(P:\OUT\) and did see the Excel file has been output but not fully output. The input SAS file has 235,009 observations, but the output Excel file only has 212,419 observations. There are 23,590 observations missing! So that's why the log says 'Unable to insert row'.   I have struggled this issue with multiple hours. Could you please give me some advice?   Thank you in advance!   Best, Runrunbunny ... View more