About BETO

BETO · ‎03-06-2015

TThanks for responding here is my code data table; set table(keep =active acctnumber flm slm datetime state city zip); format date date9.; date= datepart (date time); run; it works I get my date only but when i try to join to another table it converts to 01/01/00 the table is coming from a sql table don't know if that makes. Difference one more thing I sort my original table after I did the datepart an it change it to 01/01/00 one the on the original table thanks again

BETO · ‎03-06-2015

hi I have a date time field which I do a date part to convert it to date it works but when I try to join it to another table an bring in the converted date it changes to 01/01/00 on all the dates .... How can I keep date being date?

BETO · ‎02-25-2015

I Tried something like that and it worked but the tab doesn't exist it places the data right next to the pivot table.. When the tab is in the file I get and error message of it can't replace because a tab already exist...I think I will delete tab first an then paste

BETO · ‎02-24-2015

hi I have a excel file inside is a pivot table tab with a data dump which feeds the pivot table ccurrently I'm using proc export data = report outfile= " c:\report.xlsx" dbms=excel replace; sheet="data_dump"; run; it replaces the whole file I need it to just replace the tab so the pivot table can refresh with new data on open thanks again

BETO · ‎02-21-2015

PROC REPORT DATA=sashelp.prdsale NOWD STYLE(REPORT)=[PREHTML="<hr>"] /*Inserts a rule between title & body*/; COLUMNS COUNTRY PRODTYPE,ACTUAL; DEFINE COUNTRY /GROUP; DEFINE PRODTYPE /ACROSS; DEFINE ACTUAL/SUM ""; BREAK AFTER PRODTYPE /SUMMary it didn't copy correctly here is rest of code... I need for results to be added to body of outlook like a pic

BETO · ‎02-21-2015

Reeza, i Have a code so alter to this it creates the report in results but when it runs the output section it doesn't pick it up any thoughts what I'm mmight be missing? FILENAME output EMAIL SUBJECT= "Sales summary report 1" FROM= "bob@sas.com" TO= "charlie@sas.com" CT= "text/html" /* Required for HTML output */ ; ODS HTML BODY=output STYLE=sasweb; TITLE JUSTIFY=left "Total Sales by Country and Product type as of %sysfunc(date(),yymmdd10.)"; PROC REPORT DATA=sashelp.prdsale NOWD STYLE(REPORT)=[PREHTML="<hr>"] /*Inserts a rule between title & body*/; COLUMNS COUNTRY PRODTYPE,ACTUAL; DEFINE COUNTRY /GROUP; DEFINE PRODTYPE /ACROSS; DEFINE ACTUAL/SUM ""; BREAK AFTER PRODTYPE /SUMMARIZE; RUN; ODS HTML CLOSE;

BETO · ‎02-20-2015

Hi Cynthia, your correct i came up with a proc report does exactly that ...now the question how I would be able export that to the body of outlook to be able to email it out ... I have the code to auto email already I would like to know how attach the html output named report which resides in results... I'm playing around with ods but any help would be greatly appreciated

BETO · ‎02-19-2015

i have a table that looks like this id. Date. Code A1. 02/01/15. OOC A2. 02/01/2015. OOC A3. 02/03/15. DB A4. 02/04/15. DB I want create a pivot table in sas looking like this 02/01/15. 02/03/15. 02/04/15 OOC. 2. DB. 1. 1 then I would like it if I can add the pivot table to the body of outlook

BETO · ‎01-14-2015

HI, Ive tried that option an it doesn't replace the original file it happen when I convert to xlsx format. so deleteing it is best option since it runs every three hours.. i Have this code that deletes what I need but the cmd prompt window stays open any ideas how to close it? %let fname =GT.xlsx; %let dir=H:\Test\; x del "&edit.\&fname.";

BETO · ‎01-14-2015

HI, I have a data step that exports to excel . I need to delet /remove the original file. How do I go about deleting the file before the export process starts I currently have this script for deleting it's not working filename myfile "c:\daily\GT.xlsx"; rc=fdelete(myfile); run; filename myfileclear;

BETO · ‎01-08-2015

Hi Hai kuo i just reran the script an it merge the correct amount of 200k and 5 k records.... without any changes. To my script could you provide me an example of how it should look since you said mine looks incorrect ...I'm happy that is merging correctly but don't understand why it didn't first couple times ...thank you again for your assistance

BETO · ‎01-08-2015

i want to combine two tables to one table by using merge.. DAta report; merge table1 table2; run; Table1 has 200000 records TAble2. Has 5000 records when I run the merge I get 13k from table 1 and table2 has 4k somehow it brings in less record to new table".. Thanks for assistance

BETO · ‎01-08-2015

Yes with out year it's diffcult to get it thanks for the assistance

BETO · ‎01-08-2015

Hi I have a date column that looks like this 1106 1209 0101 0102 i need the data to look like this 11/06/14 12/09/14 01/01/15 01/02/15 i used this code in 2014 an was hoping for any insight how to make it work with 2014 and 2015 and any future years data table1; set table; newdate =mdy (substr(old date ,1,2),substr(old date,3,4),2014); format newdate mmddyy9.; run;

BETO · ‎01-08-2015

THanks Patrick I will use the daily pull to get my week

Online Status	Offline
Date Last Visited	‎03-13-2020 05:49 PM

Re: How to drop a variable when criteria is met

How to drop a variable when criteria is met

Re: How to apply macro to proc sql ?

Re: How to apply macro to proc sql ?

How to apply macro to proc sql ?

Re: ID the day of week

Re: ID the day of week

Re: ID the day of week

Re: ID the day of week

ID the day of week

Re: How to ID min max

Re: How to ID min max

Re: How to use date/time field with a minus 1 day

Re: Best way to import Access Table?

How to adjust for 100%?

Re: How to use date/time field with a minus 1 day

Re: Assistance with transpose

Re: Between start and end

Re: How to convert 01/01/00 to reg date ?

How to convert 01/01/00 to reg date ?

Re: Replace excel tab but not the file

Replace excel tab but not the file

Re: Embed a pivot table to body of outlook

Re: Embed a pivot table to body of outlook

Re: Embed a pivot table to body of outlook

Embed a pivot table to body of outlook

Re: how to delete excel file when exporting

how to delete excel file when exporting

Re: how to Merge two tables into new table ?

how to Merge two tables into new table ?

Re: How convert date to current year

How convert date to current year

Re: How to group by siteid and date