data want;
set have;
retain pyear pnumber;
tempy=year; tempn=number;
by id;
if first.id then do; pyear=year; pnumber=number;end;
else if year - pyear > 1 then do i=1 to (year-pyear-1);
year=pyear+i;
number=pnumber;
output;
end;
year=tempy; number=tempn;
pyear=year; pnumber=number;
output;
drop pyear pnumber tempy tempn i;
run;
... View more
proc report data=ALFRED.shoes;
COL Name Age Country Nationality Agemean;
DEFINE Nationality /order;
DEFINE Age /analysis mean;
DEFINE Country /DISPLAY 'Country of Origin';
DEFINE Agemean /COMPUTED 'Age Mean';
COMPUTE Agemean;
Agemean=Age.mean;
ENDCOMP;
BREAK AFTER Nationality / SUMMARIZE;
run;
... View more
@Shreekam wrote:
Then, I tried to create a data source. In this step I couldn't view the data set in my library.
You couldn't view the dataset in your library OR the library itself? I know the video you mentioned but her issue was not with the data, but the library itself.
... View more
data have;
infile datalines dlm=",";
length country zip format $20;
input country $ zip $;
retain Rx;
if _N_=1 then Rx=rxparse("$U to A,$D to N");
format= rxchange(rx, 1000, zip);
drop Rx;
cards;
Canada,A6C 2X8
Canada,A6C-2X8
France,31360
Switzerland,123
United States,55344
United States,TW18 4BQ
;run;
data codes;
infile cards dlm=",";
input country : $20. code : $20. ;
cards;
Canada,ANA NAN
France,NNNNN
Switzerland,NNNN
United States,NNNNN
;
run;
data want;
merge have codes;
by country;
if trim(format)= trim(code) then Improper_Flag='N';
else Improper_Flag='Y';
run;
... View more
data want ;
set have;
www=index(x, "www.");
com=index(substr(x,www+4), ".com");
website=substr(x,www,com+7);
if www and com;
if index(trim(website),' ')> 0 then website="";
drop www com;
run;
... View more
The SASUSER library is read only in SAS University Edition, and you cannot save content to this library.
Delete the statment "lib=SASUSER;" or change it to another writable library.
... View more
