Hello, I need to create a macro that processes data files stored in different folders. The structure for storage of the files and their filenames are the same. The files are large  and havmillions of observations and many variables. I have a solution if i copy all the files I need and paste them into the same folder. I prefer to avoid doing that. I would like to reach the original folder for each file with a macro. The output I need is a file for each iteration in the makro. Here is av very simple example of the data I have and what I want to do:   I have two datasets corresponding to data for 2018: data dm18ir18; input ID Inc; datalines; 4 25 5 40 6 55 ; run;   data dm18vm18; input ID weight; datalines; 4 2 5 3 6 3 ; run;   Two datasets corresponding to data for 2017: data dm17ir17; input ID Inc; datalines; 1 25 2 40 3 55 ; run; data dm17vm17; input ID weight; datalines; 1 2 2 3 3 1 ; run; If these files are stored in the same folder : libname c 'd:\sasdata\test'; then a solution that works is the following:   %macro test(year); data want&year; merge c.dm&year.ir&year  c.dm&year.vm&year ; by ID; run; %mend; %test(17) %test (18);   The results in this case are two files : want17 and want18.   If I do not copy the files to a new folder as assumed above, the data would be in the following original folders:   'D:\sasdata\test\year17\V4'   (many files corresponding data för 2017) ''D:\sasdata\test\year18\V4'   (many files corresponding data för 2018) I still want to create two files (want17 and want18) but by using the original stored files in stead of copying them into the same folder. Thank You! ... View more

Hello,   I have a dataset with many variables and obsevations. Most variables are numeric, but not all. I Use the proc summary to collapse data by a Class variable. The Class variable is also numeric and represents the ID för members of a define group (group_ID). Is there any way to exclude the group_ID variable (which is numeric) from the Var statement? The reason why each variable is not written in the Var statement is because they are so many. Thanks!   proc summary data=x; var _numeric_ class group_ID; ouput out=Y; RUN; ... View more

Hi, I have a dataset with 7 individuals (ID) and 2 households (FAM). In addition, I have two variables, Ink and Disp. Ink shows the individual's income while Disp shows the households' disposable income. Disp thus repeats itself. I want the variable disp to be kept for the first individual in the household and get a value missing for the rest of the individuals in the household. Below is the code that shows what I have and how I want it to be. thank you! DATA HAVE; INPUT ID FAM INK DISP; DATALINES; 1 1 50 60 2 1 100 60 3 1 200 60 4 2 500 250 5 2 700 250 6 2 0 250 7 2 0 250 ; RUN; DATA WANT; INPUT ID FAM INK DISP; DATALINES; 1 1 50 60 2 1 100 . 3 1 200 . 4 2 500 250 5 2 700 . 6 2 0 . 7 2 0 . ; RUN;     ... View more

I need to export a simple SAS table to Excel and later on import it back to SAS. I need to do it multiple times (several years). The result expected is 4 Excel files and 4 SAS files. The macro is not working well in creating the Excel files. best regard MCB1  My code: %macro bilar(ar); ODS excel FILE='\\micro.intra\projekt\P0069_ESV$\Marcela\Bilar\OUTPUT\BESK_BILARX&ar.XLSX'; PROC FREQ DATA=G.BILAR&ar ; TABLES BILMODELL*BESKRIVNING*PRIS/LIST MISSING ; RUN; ODS EXCEL CLOSE;   PROC IMPORT OUT= BESK_MODELLER&ar DATAFILE= "\\micro.intra\Projekt\P0069_ESV$\Marcela\Bilar\OUTPUT\BESK_BILAR2X&ar.XLSX" DBMS=EXCEL REPLACE; RANGE="'Freq 1 - LIST Frequencies$'"; GETNAMES=YES; MIXED=NO; SCANTEXT=YES; USEDATE=YES; SCANTIME=YES; RUN; %mend; %bilar(2016) %bilar(2017) %bilar(2018) %bilar(2019);     ... View more