Ask me about DS2, SAS and Hadoop, Data step, SQL/FedSQL, Macro, efficiency, SAS/Access, reading data from FTP/HTTP sources, ODS and using SAS to leverage REST APIs
Max character variable length in SAS is 32,767. Because you are writing an HTML table to the output file, when the file renders in a browser, the text it contains should automatically wrap within the table column for each row. So I'm having difficulty visualizing what you are trying to accomplish with the DO loop. Can you explain a bit more?
... View more
Because each variable contains only one word, in a DATA step you could concatenate them and count the number of words like this:
data have; infile datalines dsd dlm='|' truncover; input D1_1:$10. D1_2:$10. D1_3:$10. D1_4:$10. D1_5:$10.; datalines; yellow|blue| pink|yellow|magenta||black magenta|orange|green green|magenta|pink|white ;
For the frequency count by word, it's easiest to transpose with a DATA step first and then use good old PROC FREQ:
data forFreq (keep=word);
set have;
array w[*] D:;
do i=1 to dim(w);
word=w[i];
if not cmiss(word) then output;
end;
run;
proc freq data=forFreq;
tables word/nocum nopercent;
run;
... View more
FedSQL is pretty strictly ANSI compliant. Expressions require date constants to be written in ANSI-standard format - DATE'YYYY-MM-D'. The raw SAS date number must be formatted properly and surrounded by single quotes. You can use PUTN to format the value, but the dashes will be misinterpreted as a minus sign if you use %SYSFUNC to execute the PUTN function, and macro code won't execute if surrounded by single quotes.
Use QSYSFUNC to mask the dashes in the formatted text.
Use the %TSLIT macro to allow the macro code to resolve before adding the necessary single quotes.
Example:
data jours;
input jour;
datalines;
23038
23039
23040
23041
23042
;
%let Aujourdhui=23040;
proc FedSQL;
select *
from jours
where jour>=date%tslit(%qsysfunc(putn(&Aujourdhui,yymmddd10.)));
;
quit;
Hope this helps.
... View more
I had never heard of PROC TRAJ, and couldn't find it in any of the SAS online docs. Looks like it was created and is supported by the folks at Carnegie Mellon. You can find the documentation for it here: traj: group-based modeling of longitudinal data (cmu.edu)
... View more
These articles might help:
How to Run SAS Programs in Batch in the New SAS Viya
How to Run SAS Programs with Parameters in Batch in SAS Viya
How to Run a SAS Studio Flow in Batch
... View more
Here is a screenshot of the CSV file that was generated. You can clearly see that the results are exactly as you specified:
If you open the file in Windows using Notepad, Notepad++, or any text editor, you will see the same. If you open the file with Excel, Excel will automatically change the way the data is displayed and you will no longer see the trailing zeros:
You can't make Excel change this behavior. If you want this to look different in Excel, then you will have to create an Excel file instead of a CSV.
ods excel file="C:\temp\new.xlsx";
title;
proc print data=new noobs;
format Measure 13.1;
run;
ods excel close;
This writes an XLSX file, which includes the metadata Excel requires to display the data the way you want:
... View more
PROC EXPORT just exports data - the results are never formatted. You can use PROC PRINT and the ODS CSVALL destination to export the formatted values:
ods csvall file="C:\temp\new.csv";
title;
proc print data=new noobs;
format Measure 13.1;
run;
ods csvall close;
... View more
Not enough info here to hazard a guess. Please provide a more detailed description of what you are trying to accomplish, including:
1. What version of SAS are you using?
2. Which SAS client are you using (SAS Studio, Visual Analytics, or something else?)
3. What report are you trying to save?
... View more
Please provide a mock-up table or description for your desired output. That is, given the input data you provided, what would the correct result look like?
... View more
