I would suggest design an ods layout absolute page where each obs will print in its own pdf file by cycling through the dataset.  You could then combine all the files into one document with Adobe Acrobat  or a free utility. Alternatively an ods layout gridded design will produce just one file, but you may have less control in triggering a new page. ... View more

There are many approaches to solve your issue. I have used the following and it should serve your purpose i.e., print the file if there are observations in the dataset and not when empty. I have created an empty dataset called class from sashelp.class and used it to illustrate my code. /*Creating an empty dataset*/ proc sql; create table class like sashelp.class; quit; %macro print_if_not_empty(dataset_name); /* finding the number of observations.*/ data _null_; set &dataset_name. nobs=obs; call symputx('nobs',nods); run; %if %sysfunc(symexist(nobs)) %then %do; proc print data=&dataset_name.; run; %end; %else %do; %put ****The dataset &dataset_name. is empty *****; %end; %mend; /*Call the macro */ %print_if_not_empty(class) ... View more

This icon on the message editor is for pasting code   ... View more

You have a couple of answer to produce what you asked for. Please explain it what way they are not what you need?   If they are entering into a "system" what type of file do they need? ... View more

If you just need individual csv files and not generate individual datasets, the following will do it. Note, names with embedded spaces will have the blanks removed   proc sql noprint; select distinct make into :carlist separated by '|' from sashelp.cars where make is not null; ; quit; %macro each; %local i next_car; %let i=1; %do %while (%scan(&carlist, &i) ne ); %let next_car=%scan(&carlist,&i, |); proc export data=sashelp.cars(where=(make="&next_car")) outfile="~/csv/%sysfunc(compress(&next_car)).csv" dbms=csv replace; run; %let i = %eval(&i + 1); %end; %mend; %each;   ... View more

Your comments 2 and 3 indicate that at some point you have set the ratio of the height and width of your graphics output to something other than the defaults. The ODS Graphics option NOSCALE will override the default behavior of using the ratio of your graphic display areas to set font proportions.   You may want to use the ODS Graphics option SHOW to write all of your current graphic settings to the log. Or use ODS Graphics/ reset; at the start of your program. Many of the options will persist across programs and even sessions.   Lines of title text breaking are likely a combination of window width and title font; too large of a font for the amount of text in the window and the line breaks. You might consider setting a font for the title or possibly the NOGTITLE option for the ODS PDF statement to move the title text out of the graphics area and into the document body. ... View more

@MART1  Your "real world" explanation really helps to better understand the challenge. Some representative sample data provided via a SAS data step would likely get us even closer to your reality.   Below code based on what I found on the Internet how UK postcodes look like: https://ideal-postcodes.co.uk/guides/uk-postcode-format  The code syntax to extract the codes from a string based on SAS code sample from here.   Below code may not be fully suitable for your data but it should give you the necessary pointers ...and depending on your hardware the code should execute within minutes (or less).   ...and I just realized that I've done things only for the Outward portion of the UK postcode. To change things for the full postcode shouldn't be that hard though. If you want SAS code for it then please provide representative sample data in the form of working data step code creating this data (the "users" and "postcode" tables). data users; infile datalines truncover dlm='|'; input user $ addr $40.; datalines; aa|aaad bbbd 123 xxx ab3x blah aa|aaad bbbd 2 xxx c9 blah aa|aaad bbbd xc9 xxx ab3x blah aa|aaad bbbd c9 xxx ab3x blah aa|aaad bbbd c999 xxx ab3xy blah ; data postcodes; input postcode $; datalines; ab3x c9 ; data want; if _n_=1 then do; if 0 then set postcodes(keep=postcode); dcl hash h1(dataset:'postcodes'); h1.defineKey('postcode'); h1.defineDone(); end; call missing(of _all_); set users; array postcode_candidate_ {4} $4; length _found $4; _ExpressionID = prxparse('/\b[[:alpha:]]{2}\d[[:alpha:]]\b|\b[[:alpha:]]\d[[:alpha:]]\b|\b[[:alpha:]]\d\b|\b[[:alpha:]]\d\d\b|\b[[:alpha:]]{2}\d\b|\b[[:alpha:]]{2}\d\d\b/'); _start = 1; _stop = length(addr); /* Use PRXNEXT to find the first instance of the pattern, */ /* then use DO WHILE to find all further instances. */ /* PRXNEXT changes the _start parameter so that searching */ /* begins again after the last match. */ call prxnext(_ExpressionID, _start, _stop, addr, _position, _length); do while (_position > 0); _found = substr(addr, _position, _length); if h1.check(key:_found)=0 then do; _i=sum(_i,1); postcode_candidate_[_i]=_found; end; call prxnext(_ExpressionID, _start, _stop, addr, _position, _length); end; drop _:; run;   ... View more

data test; test = "B"; output; test = "A"; output; run; proc transpose data=test out=have; var test; run; data _NULL_; set have; call symputx('macvar', catx(' ',of col:)); run; %put &=macvar;   ... View more

@nasrullah_shah0 wrote: Any login/registration of individual learners? Get in contact with SAS and present your case. ... View more

/* Here are two methods, first using transpose and the other proc iml */ /* I have expanded your data to ensure it will work with additional rows and columns */ ************; ************ ; Data raw; input Val1$ Val2 val3 val4; cards; Abc 123 1123 1231 Def 567 2567 5672 Abc 908 3908 9083 Ghf 543 4543 5434 Ghf 643 5643 6435 Ghf 743 6743 7436 ; /* First method: the var names for dup id given unique names */ proc sort out=rawsrt; by val1; run; data have; set rawsrt; by val1; if not first.val1 then do; n+1; val1=cats(val1,n); end; else n=0; run; proc transpose data=have out=want(drop=_name_); id val1; var val2 val3 val4; run; proc print; run; /* Assumption: The transposed data will be imported into Excel */ /* Second method: Create two datasets, one each for vars and data */ proc iml; use raw; read all var _CHAR_ into varnames; read all var _NUM_ into values; var1=varnames`; var2=values`; close; show names; print var1, var2 ; /* create two data sets: variables and data, respectively */ create vars from var1; append from var1; create nums from var2; append from var2; quit;   ... View more

proc format; value $cur 'A'='Euro' 'B'='Pound' 'C'='Yen'; run; proc sgplot data=fake_data; vline visit_date/group=pat_type groupdisplay=cluster; yaxis min=0; format visit_date year4. pat_type $cur.; run;     ... View more