Fantastic! Thank you so much! Question, what if I need to use the tabulate sheet join with another dataset? How can I used the tabulate that I create from here as a dataset not having column direction changed to rows?
Do you want to export report or the raw data.. if you want to export the report i.e. the output of proc tabulate - 1. you can first output that in a table and then can export as any other table 2. you can use the ods process, you may like to watch below - ua-cam.com/video/wbzUMnYcQbk/v-deo.html
Hi Balakumar, Whatever we have explained in SAS OnDemand or University edition, almost all of them can be used in EG as well. SAS EG is a licensed version and usually not taken by the individuals because of affordibility. you can just post your questions here which you have specific to EG and we will try to support on that
@@learnerea Thanks for the quick response. I have asked you because, SAS Guided tutorial is still utilized for enterprise data warehouse persay but mainly has GUI. This is not available in university or On-demand. How is it the same? The semantics is little different. Data manipulation is the same in Base SAS and EG is this what you meant? My question is not relevant in this context as I wanted to do functional testing.
Another question: How to sent more than one summary to the same excel file ( in two different tabs i.e). I'm trying to sent them but the second report overlap the first one even I do put different cell addresses! Thanks again!
try below, if it works on your machine - proc export data=sashelp.cars(obs=10) outfile="/home/u49504224/excelFiles/cars.xlsb" dbms=xls replace; run; if this gives you any error, put the script and error both here in the comment, we will see it further
This is related to how SAS displays the output results in the Results Viewer when running procedures that produce tabular output. Here's a breakdown: ROW=FLOAT: It causes the output rows to flow (or 'float') continuously rather than breaking at page boundaries. This is particularly useful when generating HTML or RTF output where the concept of a "page" doesn't really apply. By setting rows to float, you avoid unnecessary page breaks in your output. COULD: It's an instruction to SAS to try to float rows, but if it can't for some reason (like some incompatibility with other options), then it won't and will fall back to default behavior. By setting option ROW=FLOAT.COULD; in your SAS session, you're telling SAS to attempt to float rows in the output, but if it encounters issues, it won't stop the process or return errors; it will just proceed with the default row behavior To use this option, you'd typically set it at the beginning of your SAS session or program: options ROW=FLOAT.COULD; /* rest of your SAS code here */
Thanks for you help …. Very informative and useful….. best lecturer ever
Glad you liked it
Thank you so much! I have a question , can we put any name in that empty A1 position (left of origin and top of type there is a empty )
Yes you can!
At 20:44, notice the line number 7, the "box" statement... you can use this statement to put whatever you want to write over there..
Fantastic! Thank you so much! Question, what if I need to use the tabulate sheet join with another dataset? How can I used the tabulate that I create from here as a dataset not having column direction changed to rows?
Such a valuable training and awesome way of explaining. Thanks for your support. kudos to entire team & good luck🙂
Glad it was helpful
Great! I want to export the whole table. Is that impossible with big basedata?
Do you want to export report or the raw data.. if you want to export the report i.e. the output of proc tabulate -
1. you can first output that in a table and then can export as any other table
2. you can use the ods process, you may like to watch below -
ua-cam.com/video/wbzUMnYcQbk/v-deo.html
Very well explained
Glad it was helpful!
Fantastic!
Thank you very much
Thank you! Have you got materials for sas EG?
Hi Balakumar,
Whatever we have explained in SAS OnDemand or University edition, almost all of them can be used in EG as well.
SAS EG is a licensed version and usually not taken by the individuals because of affordibility.
you can just post your questions here which you have specific to EG and we will try to support on that
@@learnerea Thanks for the quick response. I have asked you because, SAS Guided tutorial is still utilized for enterprise data warehouse persay but mainly has GUI. This is not available in university or On-demand. How is it the same? The semantics is little different. Data manipulation is the same in Base SAS and EG is this what you meant?
My question is not relevant in this context as I wanted to do functional testing.
Another question: How to sent more than one summary to the same excel file ( in two different tabs i.e). I'm trying to sent them but the second report overlap the first one even I do put different cell addresses!
Thanks again!
you can try exporting them on different sheet, let me know if that doesn't work
Thanks for this amazing video
Glad you liked it!
Can we add subtotal also and total as well if possible
U ARE GREAT BROTHER. KEEP IT UP AND PLEASE COTINUE TO MAKING THESE TYPES OF FULL DETAILS VIDEOS ON SAS SQL.
Glad it helped
How to export to xlsb format... Please guide.
try below, if it works on your machine -
proc export data=sashelp.cars(obs=10)
outfile="/home/u49504224/excelFiles/cars.xlsb"
dbms=xls replace;
run;
if this gives you any error, put the script and error both here in the comment, we will see it further
Nice explanation.. please post video on SQL pass through in SAS.
A very informative video. My question: how to format the summary in non decimal numbers?
Thnx
In the table statement, where you provide the numeric variable name put >> *f=18.
Great video. What if I don't want the grand total to be a sum but instead I want it to be an average (grand total)
e.g. I have 2 3 4 and I want grand total to be (2+3+4)/3=3 rather than (2+3+4)=9 ?
Try something like below -
proc tabulate data = sashelp.cars;
class origin drivetrain;
var msrp;
table origin all,msrp*(mean) all;
run;
👍
Can we add the subtotal on this Sir...!!! 🙂
Thanks for posting video..I have doubt on one option Row=float.could you plz explain.
This is related to how SAS displays the output results in the Results Viewer when running procedures that produce tabular output.
Here's a breakdown:
ROW=FLOAT: It causes the output rows to flow (or 'float') continuously rather than breaking at page boundaries. This is particularly useful when generating HTML or RTF output where the concept of a "page" doesn't really apply. By setting rows to float, you avoid unnecessary page breaks in your output.
COULD: It's an instruction to SAS to try to float rows, but if it can't for some reason (like some incompatibility with other options), then it won't and will fall back to default behavior.
By setting option ROW=FLOAT.COULD; in your SAS session, you're telling SAS to attempt to float rows in the output, but if it encounters issues, it won't stop the process or return errors; it will just proceed with the default row behavior
To use this option, you'd typically set it at the beginning of your SAS session or program:
options ROW=FLOAT.COULD;
/* rest of your SAS code here */
@@learnerea thank you so much for the detailed explanation