About Tap222

Reeza · ‎12-28-2016

Please don't start a new thread for the same question.

Reeza · ‎12-26-2016

To find the macro definition, note the 5th line of your log, which provides the program from %cmpres auto call macro.

Kurt_Bremser · ‎12-23-2016

@Tap222 wrote: Instead book.ytdsales.I am using work.ytd slaes its working.When I run this code a library name book created but In SAS log file it says book doesnot exist. This is because the path for your library book does not exist (in the scope of your SAS process, which might be on a remote server or in a virtual machine).

Kurt_Bremser · ‎12-15-2016

proc means creates summary statistics, proc print only does simple output. Simply run them, and you'll see. And READ THE DOCUMENTATION: proc means proc print

ballardw · ‎12-13-2016

Also the use of single quotes around a character literal also allows placing a single (or odd number of) double quote into the value such as the use of " for inch measurements: '5.3"' <= that is " followed with ' and vice versa "John's car". While possible to do with just one quote style the alternate 'John''s car' <= the '' is two single quotes, isn't quite as obvious in some situations and can be difficult to deal with for multiple single quotes needed within a single string.

Astounding · ‎12-13-2016

Macro language contains just a handful of functions. DATA steps, on the other hand, contain hundreds of functions. %SYSFUNC was invented so that you could tell macro language to use a DATA step function. That way, the macro language would not have to reprogram all those DATA step functions into a macro language version. Most DATA step functions (not all) can be called using %SYSFUNC.

Reeza · ‎12-13-2016

%SYSFUNC(function(argument(s))<, format>) The second parameter to SYSFUNC() is a format, so whatever is processed as the first argument will get formatted as MONNAME9. SYSFUNC MONNAME format -> Writes date values as the name of the month. MDY() function -> Returns a SAS date value from month, day, and year values. SAS Functions by Category: http://support.sas.com/documentation/cdl/en/lefunctionsref/69762/HTML/default/viewer.htm#p0w6napahk6x0an0z2dzozh2ouzm.htm So first argument is creating a date and second formats it as a month.

Cynthia_sas · ‎12-03-2016

Hi: To illustrated Kurt's point. cynthia ** temporary data set, will be in WORK library; ** WORK library is "cleared" at the end of every session; data class; set sashelp.class; age_in_5_yrs = age + 5; run; ** permanent data set will be in C:\mydata folder; ** and will persist after SAS session ends; libname perm 'c:\mydata'; data perm.class; set sashelp.class; age_in_5_yrs = age + 5; run;

Online Status	Offline
Date Last Visited	‎01-01-2017 07:30 AM

Re: SAS programming

SAS programming

Re: MacoSAS

Macro SAS - %CMPRES function

Re: Macro SAS

Macro SAS

PROC MEANS and PROC PRINT

single quote and double quote

function

%Sysfunc function

Re: MacoSAS

Re: SAS programming

Re: MacoSAS

Re: Macro SAS

Re: PROC MEANS and PROC PRINT

Re: single quote and double quote

Re: %Sysfunc function

Re: function

Re: Code to create permanent data set