How about the function tslvl().  https://go.documentation.sas.com/?docsetId=hostunx&docsetTarget=p0fjexseegel6tn1w5solsj5gofg.htm&docsetVersion=9.4&locale=en    If you're using EG you can:   data a; set _prodsavail; licensed=sysprod(prodcode); do option='A', 'D', 'E', 'F', 'H', 'I', 'M', 'P', 'S', 'T' ; tslvl = tslvl(prodmod,option); output; end; run; Otherwise try: data b; prodcode='prodnum208'; prodmod='sasdbf'; do option='A', 'D', 'E', 'F', 'H', 'I', 'M', 'P', 'S', 'T' ; tslvl = tslvl(prodmod,option); output; end; run;     ... View more

It's not quite clear to me what you want your text file to look like.  Can you provide a sample of what you expect your text file to contain?     Your %put statements write out something almost like this.  Is this what should be in your text file?     "A N102013" "A 01/10/13" "B 31/10/13" "A N102014" "A 01/10/14" "B 31/10/14" ...       ... View more

Would proc product_status; run; give you what you need? https://go.documentation.sas.com/?docsetId=proc&docsetTarget=p167ky4zsoxrn2n1myz6iisao1wc.htm&docsetVersion=9.4&locale=en  ... View more

Is this what was intended?  Does somebody want to simplify this?  I still like @ballardw 's better. proc sql noprint; create table want1 as select coalesce(a.id, b.id) as id , a.age1 , b.date1, b.type1 from have1 as a full join have2 as b on upcase(a.id) = upcase(b.id) ; create table want2 as select coalesce(a.id, c.id) as id , a.age1 , c.date2, c.type2 from have1 as a full join have3 as c on upcase(a.id) = upcase(c.id) ; create table WANT as select coalesce(w1.id, w2.id) as id , coalesce(w1.age1, w2.age1) as age1 , w1.date1, w1.type1 , w2.date2, w2.type2 from want1 as w1 full join want2 as w2 on upcase(w1.id) = upcase(w2.id) and w1.age1 = w2.age1 and w1.date1 = w2.date2 ; quit; ... View more

In order for your colleague to open the table in Base SAS your colleague will need access to the format library location.  Then in Base SAS they can say: libname udf "<userDefinedFormat library location>" access=readonly; %put %sysfunc(getoption(fmtsearch)); options append=fmtsearch=udf; %put %sysfunc(getoption(fmtsearch)); After which they should be able to open your table.   ... View more

Perhaps put the above OS commands, first, in the same script that launches the SAS session? ... View more

Since I don't have your data I used sashelp.cars.  How about this? %macro MyMacro; %let CurrentAnimal =Audi, BMW; %let dim=%sysfunc(countw(%quote(&CurrentAnimal.),%str(,))); %do i = 1 %to &dim; %let this=%scan(%quote(&CurrentAnimal.),&i,%str(,)); proc sql; create table Want_&this. as select * from sashelp.cars where make = "&this."; quit; %end; %mend MyMacro; %MyMacro ... View more

And if it's Windows, at a command prompt cd to the directory in question and: find /c /v "^$" *.csv >csvRowCount.txt   Read csvRowCount.txt into SAS and don't forget to subtract 1 from the count. ... View more

If this is on Linux then in a terminal session I would cd to the folder in question and:   wc -l *.csv 1>csvRowCounts.txt rm -f *.csv   Then in SAS you can read csvRowCounts.txt into SAS and subtract 1 from each count.  But I wouldn't rm the files until you are sure of your result.   ... View more

Building on art297's response, instead of using var _all_; specify each variable.  otherwise you'll get a row for subjid too. var sodium potassium bicarbonate glucose bloodureanitrogen creatinine SGPT SGOT GGT; ... View more