I'm trying to loop through a table and call a macro.  Before I call the macro I'd like to set the value of a variable.   %global curProgram; proc sql; create table AllProgramList ( SMRPRLE_PROGRAM varchar(100) ); insert into AllProgramList(SMRPRLE_PROGRAM) values ("One"); ; data _null_; set AllProgramList; file code; put '%let curProgram = bquote('SMRPRLE_PROGRAM +(-1)')'; /*put '%setProgramClause()'; put '%callStudentBody(No)'; */ run; %put curProgram &curProgram; %include code / source2; Why does  put '%let curProgram = bquote('SMRPRLE_PROGRAM +(-1)')'; Make this error message then not set the value of curProgram? 49 NOTE 49-169: The meaning of an identifier after a quoted string might change in a future SAS release. Inserting white space between a quoted string and the succeeding identifier is recommended. ... View more

Somehow the value of curProgramList1 is transformed from BS-MAC-PB1 to BSMAC-PB1 with the below.  and the error message ERROR: Invalid symbolic variable name BSMAC-PB1. is displayed.   %macro ProgramDisplay(); %do i = 1 %to &curProgramList_count; %let curProgram = %superq(&curProgramList&i); %put "Test5"; %put curProgram &curProgram; %if &curProgram eq %then %do; %end; %else %do; %put Test6; %end; %end; %mend; %ProgramDisplay(); ... View more

We just upgraded to SAS 7.5.  When importing from one environment to another development to production or public to development.  All objects in the content area are maximized one on top of another. For example, a report with two graphs side by side on development will have two graphs one on top of the other on production.  If the top graph is deleted the second graph will display instead. ... View more

I have a dataset with columns  like:   displayColumn _2014_15 _2014_15b _2015_16 _2015_16b Demo Row 1 0.5 2 0.34           I'm trying to display the data set like this with proc report.  Please advise. displayColumn 2014-15 2015-16 displayColumn _2014_15 _2014_15b _2015_16 _2015_16b Demo Row 1 0.5 2 0.34       Starting data  proc sql; CREATE TABLE have ( displaycolumn varchar2, col1 int, col2 DECIMAL(10,2), col3 int, col4 DECIMAL(10,2) ); insert into have (displaycolumn, col1, col2, col3, col4) values ("demo column", 1, .5, 2, .75); quit;   I have the display  proc report data=have; column displaycolumn col1 col2 col3 col4; define displaycolumn / group; define col1 / analysis sum '2014-15' format=comma9.; define col2 / analysis sum '2015-16' format=percent8.1; define col3 / analysis sum '2014-15 %' format=comma9.; define col4 / analysis sum '2015-16 %' format=percent8.1; run; ... View more

%macro createGradRetRowsSummaryLines(stud_type, cohortYearCount, cohortYearCount2, gradOrRen, retOrGrad, firstTime); if cohort=201510 and DisplayColumn="&cohortYearCount2 Year &gradOrRen of &stud_type" then _2014_15b=&retOrGrad._percent; %mend;   Why is Enterprise Guide throwing an error when I use &retOrGrad._percent should it read this as variable || _percent and query the variable name that matches the concatenation?   ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, a numeric constant, a datetime constant, a missing value, INPUT, PUT. ... View more

How do you set the length of the output of a column from proc report?   E.g length $100; ... View more