About Tecla1

Tecla1

Tnks

Tecla1

Hi Tom, I see well your first replay. Tnks a lot. Tecla

Tecla1

Hi Tom, i need the format but it's non important for the result !! I have a question: why "first." wasn't a good solution? Tnks a lot !!

Tecla1

Hi Tom many tnks for your kindly help!!! after your replay everything seems so simple !!! I tnks all community for the help everityme it give.... have a nice new Year !!!

Tecla1

Hi bluefish, many tnks, you are rigth, I was trying more solution but I know what you have explained so well... Now i try your kindly solution ....

Tecla1

Hi to all, I need you another time... In the case a variable is not populate i need to put a number that is the maxmum of the variable +1. I try with this: PROC SORT DATA= &nome_tab6.&load_date_g._3; BY descending TBU_NUMREK ; DATA &nome_tab6.&load_date_g._4; SET &nome_tab6.&load_date_g._3; format c bestd5.; RETAIN C; c=first.TBU_NUMREK; IF NOT MISSING(TBU_NUMREK) THEN TBU_NUMREK=TBU_NUMREK; ELSE TBU_NUMREK=C+1; RUN; TBU_5CODUF TBU_NUMREK 00845 7681 06064 7682 06084 7683 00687 7684 08534 7685 08535 7686 08540 7687 08545 ?????? 08550 08555 08560 08565 08570 08575 08580 08585 08590

Tecla1

Thank you very much Peter!! The whole community is always very helpful and kind... I wish everyone a very happy new year!!

Tecla1

Hi, Tnks, ods excel file="&outputname." options(autofilter="1-6" sheet_name="&sheetname."); proc print data=&libname..&dataname. label; run; ods excel close;

Tecla1

Hello everyone, is it possible to avoid exporting the "dot" in empty numeric cells to excell? Thank you very much, Tecla

Tecla1

Excuse for mistake ... I need to sleep...

Tecla1

Many Tnks I regeived a big help !!! I think I have tu study very mach now !! SaS Community is the best!

Tecla1

Good morning everyone, I have verified your solution for which I thank you, but I have a problem: if the width of the excel cell is sufficiently wide the text dos not wrap. I need an action equal the excel comand "ALT + ENTER" to insert a line break, is it possible? It's very important for me... otherwise I'll have to reorganize a rather large DB.... Tnks!!

Tecla1

Thanks everyone, I received great help!! I'll try the solutions right away !!! have a nice dat: Tecla

Tecla1

Many tnks for your kindly help I try immediately. Have a nice day. Tecla

Tecla1

Good morning, I need to insert a label with a line breack, is possible? I have to replicate an export in Excel with column headers that contain newlines like this: "Matr. S.I." Please can you help me? I tried but in any case in te export results without a line breack.... many thanks to all.

Online Status	Offline
Date Last Visited	Wednesday

Re: populate a variable wiìth number if a condition is verified

Re: populate a variable wiìth number if a condition is verified

Re: populate a variable wiìth number if a condition is verified

Re: populate a variable wiìth number if a condition is verified

Re: populate a variable wiìth number if a condition is verified

populate a variable wiìth number if a condition is verified

Re: numeric missing values - export in excell

Re: numeric missing values - export in excell

numeric missing values - export in excell

Re: labels

Re: populate a variable wiìth number if a condition is verified

Re: populate a variable wiìth number if a condition is verified

Re: numeric missing values - export in excell

Re: labels

Re: labels

Re: DIFFERENZE TRA RIGHE SUCCESSIVE

Re: populate a variable wiìth number if a condition is verified

Re: populate a variable wiìth number if a condition is verified

Re: populate a variable wiìth number if a condition is verified

Re: populate a variable wiìth number if a condition is verified

Re: populate a variable wiìth number if a condition is verified

populate a variable wiìth number if a condition is verified

Re: numeric missing values - export in excell

Re: numeric missing values - export in excell

numeric missing values - export in excell

Re: labels

Re: labels

Re: labels

Re: labels

Re: Need to insert line break in Excel using PROC EXPORT

labels