Hello SAS guys,
I import multiply datasets into SAS. I want my datasets group by monthly and cumulative. If I want my reports generated both monthly and cumulative, how do I code?
Here is the sample codes:
%let report=Cumulative;
filename indata pipe "dir &datadir. /b";
data file_list;
length fname$ 256.;
infile indata truncover; /* infile statement for file names */
input fname$ 256.; /* read the file names from the directory */
run;
Proc sql noprint;
create table filename as
select fname from file_list where fname contains ".txt";
select count(DISTINCT fname) into :num_files from filename;
select distinct fname into :filein1 - :filein%left(&num_files) from filename;
create table name as
select compress( scan(fname,1,"."),"&","i" )as fname from filename;
select compress(fname," 12345abced","kis")into :name1 - :name%left(&num_files)
from name;
quit;
%macro fileread;
%do j=1 %to &num_files;
proc import datafile="&datadir.\&&filein&j." out=&&name&j. dbms=csv replace;
getnames=yes;
datarow=2;
guessingrows=32767;
run;
%end;
%mend fileread;
%fileread;
/*Now I import three monthly data into SAS. */
%macro outdata;
%if &report="Cumulative" %then %do;
data cdata;
set data10 - data12;
run;
%end;
%else %do;
data cdata;
set data12;
run;
%end;
%mend;
%outdata;
But it seems that SAS ignore the condition: &report="Cumulative".
Any help is appreciated.
you don't need double quotes here %if &report="Cumulative"
%if &report=Cumulative
you don't need double quotes here %if &report="Cumulative"
%if &report=Cumulative
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 how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.