About Caro17

Caro17 · ‎02-24-2021

Is it possible to do it for more variables in one table?

Caro17 · ‎02-24-2021

This one works. Thank you very much. How can I do it if the variable is a date or a checkbox (yes/no)? What have to be changed?

Caro17 · ‎02-24-2021

Can be both. It depends on the field. Therefore I want to have a solution for both cases, please. Thank you!

Caro17 · ‎02-24-2021

Hey, I just want to have a simple thing, but I can't find a solution. I want to count a field how often it is filled or empty. How can I do this? Thanx a lot for you help. Best regards Caro

Caro17 · ‎11-09-2020

Neither 1) nor 2) leads to the wished result. I still have the title of the column.

Caro17 · ‎11-09-2020

"header" is the title of the column. What do you mean by "empty TITLE statement"? Do you mean TITLE ''? I still have the title of the column.

Caro17 · ‎11-07-2020

Hey, I am using this code: data want; set order; length order_no_str $100; order_no_str = cats(put(lngorder_no, 8.),','); run; ods excel file='\\abc\agency\…\order2020.xlsx’; proc print data=want; run; ods excel close; How can I "delete" the header? Do I really need proc print? It is not necessary to see it in SAS again. Can I suppress it? Thanx! Caro

Caro17 · ‎11-07-2020

Hey, when I'm using this syntax: ods rtf file='\\User\SAS\Analysis'; proc print; run; ods rtf close; I get the error: error: insufficient authority for access to /opt/sasinside/SASConfig/Lev1/SASApp/\\User\SAS\Analysis.rtf. How can I solve this problem? I am using SAS Studio with mac. Thanx for your support! Caro

Caro17 · ‎11-05-2020

And in excel I do not need the column heading.

Caro17 · ‎11-05-2020

Do I really need proc print? It is not necessary to see it in SAS again. Now I get an excel file, but without the comma after the number.

Caro17 · ‎11-05-2020

Thank you for the quick help. But what about the other problem with the excel file?

Caro17 · ‎11-05-2020

Hey, I just want to add a comma after a lot of numbers. before 1234567 89012345 after 1234567, 89012345, I have tried it with catx, but it does not function. Then I tried it with cats and on first sight it seems to function. But a closer look showed me that the comma ends as soon as the figure changes from seven-digit to eight-digit. From this point on there are no commas after the numbers. And at the end I want to have the new column in an excel file. But the systems told me that the file cannot be opened or repaired as it is damaged. data want set order order_no_str = put(lngorder_no, 8.); format order_no_str$100.; order_no_str=cats(order_no_str,’, '); If length(order_no_str)>90 then do; put 'ERROR: …'; end; ods excel file '\\abc\agency\…\order2020.xlsx’; run; How can I solve these problems? Thanx a lot! Caro

Caro17 · ‎07-21-2020

Hey, I just want to do an inquiry and skip e. g. 30 days always from today. For example, today is 21 July 2020 and I don't want to have the data from 21 June 2020 till 21 July 2020 but all the other data. How can I do this? In SQL I used trunc and sysdate, e. g. date <= trunc(sysdate-30). Can I use this in SAS as well? I am using SAS Enterprise Guide Version 7.15 HF2. Thanx in advanced! Best regards Caro

Caro17 · ‎07-01-2020

Hey, I have many dates like this: 01.01.2018:00:00:00’. Now I want to see just the years in a proc freq. How can I do this? Thanx a lot! Caro

Caro17 · ‎06-29-2020

With the days I get between 0 and 31536000 days. That means there must be also weeks and months. But I get nothing with weeks and months. data datdif set therapy start = datepart(start); end = datepart(end); run; data datdif; set therapy days = end - start; run; proc freq data = datdif; tables days; run; data datdif; set therapy; weeks = intck('week', start, end); proc freq data = datdif; tables weeks; run; data datdif; set therapy; months = intck('month', start, end); proc freq data = datdif; tables months; run;

Online Status	Offline
Date Last Visited	‎04-24-2021 08:22 AM

Re: Amount of a field which is filled or empty

Re: Amount of a field which is filled or empty

Re: Amount of a field which is filled or empty

Amount of a field which is filled or empty

Re: ignore header

Re: ignore header

ignore header

ods rtf file error: insufficient authority for access to

Re: Comma after a number

Re: Comma after a number

Re: Amount of a field which is filled or empty

Re: Amount of a field which is filled or empty

Re: Amount of a field which is filled or empty

Amount of a field which is filled or empty

Re: ignore header

Re: ignore header

ignore header

ods rtf file error: insufficient authority for access to

Re: Comma after a number

Re: Comma after a number

Re: Comma after a number

Comma after a number

Skip days in an inquery

extract years from dates

Re: difference between two dates