Hello Experts, Hope I able to get answer for my requirement in this forum   Requirement: I am having more than 100 files(contains xlsx, xls and csv format) in a path. I need to import only one observation from these files. So, My output like I need to create 100 dataset for 100 files and all dataset need to have only one observation(I don't want remaining records in my dataset)   This is my code:   %let file_path=C:\Users\sas\coding\; /*************************************************************************/ /* FETCHING ALL FILE NAME FROM PATH */ /*************************************************************************/ data fetching_files1; length fref $8 fname $200; did = filename(fref,"&file_path."); did = dopen(fref); do i=1 to dnum(did); fname = dread(did,i); output; end; did = dclose(did); did = filename(fref); keep fname; run; /*************************************************************************/ /* SEPERATING FILE NAME AND FILE TYPE */ /*************************************************************************/ data fetching_files; set fetching_files1; name=scan(fname,1,'.'); type=scan(fname,2,'.'); run; /*************************************************************************/ /* IMPORTING ALL FILES INTO WORK LIBRARY */ /*************************************************************************/ %macro importing_data(dataset); proc sql;  select count(*) into :NObs trimmed from &dataset;  select fname into :file1-:file&NObs. from &dataset; select name into :name1-:name&NObs. from &dataset; select type into :type1-:type&NObs. from &dataset;  quit; %do i=1 %to &nobs; PROC Import datafile="&file_path.\&&file&i." out="&&name&i."n dbms=&&type&i replace; getnames=yes; run; %end; %mend importing_data; %importing_data(fetching_files); I tried two methods     1. Using Option obs before PROC IMPORT %do i=1 %to &nobs; options obs=1; PROC Import datafile="&file_path.\&&file&i." out="&&name&i."n dbms=&&type&i replace; getnames=yes; run; options obs=max; %end;   2. By giving last row of sheet as a datarow   %do i=1 %to &nobs; PROC Import datafile="&file_path.\&&file&i." out="&&name&i."n dbms=&&type&i replace; getnames=yes; datarow=1048576; run; %end; But These two methods are consuming same amount of time as importing entire file.   Please suggest me some less time consuming method to import only one row.   Thanks in advance ... View more

Hello Experts,   Hope you are all doing good   I need to compare the datasets. I am having 5 datasets, Dataset names may vary depend upon the project. In two library the datasets are saved. I need to compare the dataset between those two library.   In Temp library, I am having 7 files( File count won't change between library) CT_Sales Payment_1 Payment_2 Payment_3 758_Transaction CT758_2_Store Product   In Temp1 Library, I am 7 files   CT_Sales Payment_1 Payment_2 Payment_3 758_Transaction CT758_2_Store Product   As we can compare these files easily by using PROC COMPARE. But, i want to do it using Macro(Dynamically) so that when the file name changes i don't need to update in the code.   Before comparing i need to do some changes in the dataset.  Some time we will have multiple dataset which has different observation but same variable name. So, If i am having multiple dataset means i need to append those dataset and create a new dataset In my dataset, the original name is(Sales,Payment,Transaction,Store,Product) But I am having some prefix to it and it wont be the same for all dataset. So i need to remove those before comparing. I tried Compress function but, I am not able to achieve the expected result Once We modify our dataset as mentioned above then I need to compare it dynamically using macro function.   I know it's a lot to ask for. But, I am learning so it would be helpful for my learning   Thanks in advance   ... View more