SAShelp says that the sas7bxat file is an extended characteristics file. If so, is there supposed to be a regular data file, * sas7bdat file? If not, how do I open the sas7bxat file?
SAS Code:
libname outb "C:\Users\lnitz\NewDownloads\Covid_Hawaii\";
proc import
out=work.subset_hawaii_covid
datafile="C:\Users\lnitz\NewDownloads\Covid_Hawaii\subset of Hawaii_Covid_w_Incidence.jmp"
dbms=jmp replace;
run;
data outb.subset_processed;
set work.subset_hawaii_covid;
by Datenumeric;
Length comb_text $6000.;
retain comb_text;
if first.Datenumeric then
comb_text= tweets.text;
else
comb_text=catx(', ', comb_text, tweets.text);
if last.Datenumeric then
output;
run;
The target data was a numeric JMP date and a line of text.
