topic Re: Select last 3 columns in SAS Programming

Select last 3 columns

meckarthik — Wed, 05 Jun 2019 16:14:04 GMT

Hi,

creating some automation report, I need to select only the last 3 columns. for example: If I run in April need to select column Jan, Feb, Mar. If run in Dec select Sep, Oct, Nov along with ID, etc.

ID	January	February	March
1	1	1	4
2	14	12	33
I3	5	3	3
4	1	3	3

Any help is much appreciated

Re: Select last 3 columns

Jagadishkatam — Wed, 05 Jun 2019 17:07:50 GMT

you could try the below example of sashelp.class where we are keeping only the last three apart from the main variable i..e name

proc sql;
select name into: vars separated by ' ' from dictionary.columns where libname='SASHELP' and memname='CLASS' having max(varnum)-varnum in (0,1,2);
quit;
%put &vars;

data want;
set sashelp.class;
keep name &vars;
run;

Re: Select last 3 columns

Ksharp — Thu, 06 Jun 2019 14:10:25 GMT

You can produce some macro variables .

%let one=%sysfunc(intnx(month,%sysfunc(today()),-1,s),monname.);
%let two=%sysfunc(intnx(month,%sysfunc(today()),-2,s),monname.);
%let three=%sysfunc(intnx(month,%sysfunc(today()),-3,s),monname.);


%put &one &two &three;

Re: Select last 3 columns

meckarthik — Thu, 06 Jun 2019 14:36:09 GMT

thank you. this is what I want, cheers!

Re: Select last 3 columns

meckarthik — Thu, 06 Jun 2019 14:36:42 GMT

Thank you!