A text file does not have observations, only lines. "Observation" is used for a single record in a SAS dataset.
show the log
show the file
Copy/paste the text of both into a window opened with this button:
Note that you need to open the text file with a suitable text editor (e.g. Notepad++) for this.
... View more
How it is displayed is controlled by the format. The underlying value is a count of days, as mentioned, and you need to use a date literal, as mentioned, to have something human-readable in the code which can be converted to the count of days by the SAS interpreter. Or you calculate yourself how many days have passed since the start of 1960 and use that raw number 😉
... View more
If thus variable contains SAS date values (count of days starting at 1960-01-01), you must use a valid date literal:
sale_date >= '01sep2019'd
Note the DATE9 format and the trailing d which makes this a date literal. Both are mandatory.
... View more
Use only one PUT statement with all variables in it. Each single PUT will cause a linebreak (unless you use the @ modifier).
Maxim 1: Read the Documentation!
... View more
Maxim 19 at work:
data have;
input Rev12 Rev11 Rev10 Rev9 Rev8 Rev7 Rev6 Rev5 Rev4 Rev3 Rev2 Rev1;
cards;
90 80 85 89 94 90 78 75 85 -9 24 32
;
/* First, turn that stupid thing into usable data */
proc transpose data=have out=long1 (rename=(col1=value));
var rev:;
run;
data long2;
set long1;
month = input(substr(_name_,4),2.);
drop _name_;
run;
proc sort data=long2;
by month;
run;
/* Now the code is easy as it should be */
data want;
set long2;
PCT_change = ifn(_n_=1,.,(value - lag(value))/value);
format pct_change percent6.2;
run;
If you have multiple observations in the initial data, use some identifiying variable in BY statements and FIRST.[variable] as condition in the IFN.
... View more
Use a double DO loop:
data sample;
input id sex race eth outcome;
datalines;
1 0 2 1 0
1 . 2 . 1
2 1 . 0 1
2 1 1 0 1
3 . . . 0
3 0 0 1 0
3 0 0 1 1
;
data want;
do until (last.id);
set sample;
by id;
_s = coalesce(_s,sex);
_r = coalesce(_r,race);
_e = coalesce(_e,eth);
end;
do until (last.id);
set sample;
by id;
sex = _s;
race = _r;
eth = _e;
output;
end;
drop _:;
run;
But since this makes the three variables redundant, you should consider to put them in their own dataset with only one obs per id. Join/merge them in whenever needed.
... View more
%macro rrr(start,end);
/* start and end are supplied in YYMM format */
/* feed input data via parameters, not by "something which exists somewhere";
always include a comment describing the parameters */
%local month yymm;
/* prevent unwanted side effects if the variables exist in an outside context;
has to be part of any proper macro code */
%let month = %sysfunc(inputn(&start.,yymmn4.));
%do %while (&month. le %sysfunc(inputn(&end.,yymmn4.)));
%let yymm = %sysfunc(putn(&month.,yymmn4.));
/* your loop code comes here, using yymm */
%let month = %sysfunc(intnx(month;&month.,1,b));
%end;
%mend rrr;
... View more
@Ronein wrote:
What is wrong with this code please?
%sysfunc(inputn(%sysfunc(intnx(month ,%sysfunc(2306), yymmn4.), ),1,e),YYMMn4.);
%SYSFUNC expects a data step function as its first argument. 2306 is not a data step function.
... View more
Work with dates, not with simple numbers. Set the starting date, use a %DO %WHILE loop, and increment in the loop with %SYSFUNC(INTNX()). Use a YYMMN4. format to get the strings you want.
... View more
Use FILENAME EMAIL to define the file reference. Use
content_type="text/html"
and the BCC=option to create the recipient list. Check with your IT department how bcc recipients your mail relay allows for a single mail.
Use ODS HTML where you use the email fileref in the BODY= option to direct all output (up to ODS HTML CLOSE) to the email stream.
Once that is tested, you can repeatedly create the code in a macro with bcc "packages" according to the limit existing (see above).
You will need to set up a dataset containing the recipients, from which you can create the bcc lists.
... View more
