About vanja

vanja · ‎08-18-2024

@PaigeMiller Thank you, the solution you provided link to also worked. days = datespss/86400; datesas = date() - ( date() - MDY(10,14,1582) - days ); format datesas date9.;

vanja · ‎08-18-2024

@ballardw Thank you for taking the time to solve my problem!

vanja · ‎08-13-2024

I have imported SPSS files (.sav) into SAS Viya via proc import. But the date variables are not converted into SAS dates. After some investigation I found that the value I have got is a numeric value representing the number of seconds since October 14 year 1582. For example the number 13759718400 represents 24-Oct-2018. Is there a SAS function to translate this numeric value to a SAS date variable? Or has someone here invented the code needed for this conversion? I still have the option to save my spss file into a sas dataset and then import it. I have checked that the date variables will be ok. But now I'm curious to know if there is a very simple solution to my problem. Thanks in advance!

vanja · ‎10-12-2021

True, my real data will for sure have some observations where more periods will have same number of max years. That is a good question. I will have to look into that. Is there a way to flag them?

vanja · ‎10-12-2021

You were the first to answer so I thought it was fair to give ju the role as solution programmer. Would you rather that I gave that to @Astounding ? For other people that might have the same problem.

vanja · ‎10-12-2021

Thanks for this extra info with start and end years, could turn out to be really useful for this research project.

vanja · ‎10-11-2021

Thank you so much for helping me. I have finished working for the day but will try it out tommorow!

vanja · ‎10-11-2021

Sorry, but I can't translate the similar solutions I have found to my specific problem.

vanja · ‎10-11-2021

Hi! I want to count the maximum number of consecutive 1:s in my dataset. See example of have and want dataset. My dataset(s) have millions of rows so I want to avoid transposing the data. I have seen similar solutions of this problem here but I don't quite understand them. Is there someone who can help me with the code needed to calculate the variable maxYears? data have; input id yr2010-yr2019; datalines; 1 . . . . . . . . 1 1 2 1 1 1 . . . 1 1 1 1 3 1 1 1 1 1 . . . 1 1 4 . . . . . . 1 . . . ; run; data want; input id yr2010-yr2019 maxYears; datalines; 1 . . . . . . . . 1 1 2 2 1 1 1 . . . 1 1 1 1 4 3 1 1 1 1 1 . . . 1 1 5 4 . . . . . . 1 . . . 1 ; run;

vanja · ‎03-07-2019

Thank you for trying to help me! ODS PROCLABEL alone didn't do the trick. By examining the code to the case you referred to I realized that instead of dividing the "ods excel file" and "ods excel options" into two lines of code and put it on the same line I actually got a Table of Contents. It is not very pretty and I get some lines in my table of contents that I would rather not have; "Report" "Table 1" But still, good progress! ods excel file="&ROOTDIR.&FILENAME..xlsx" options(embedded_titles='YES' contents='yes' autofilter='on' sheet_interval='proc');

vanja · ‎03-07-2019

Hi! I am trying to generate a sheet with a table of contents with my ods excel statement. I am not quite sure of how this works but I'm hoping that it will take the titles and title2:s and display them on a separate sheet. However, no table of contents appears in my Excel file. I have several proc reports in my program. Is there anyone out there who knows what I am doing wrong or if there is something in my SAS installation that is missing? I use SAS Enterprise Guide version 7.15. ods excel file="&ROOTDIR.\&FILENAME...xlsx"; ods excel options(embedded_titles='YES' sheet_interval='proc' autofilter='all' contents='yes' ); ods excel options(sheet_name='TABLE1'); title "..."; title2 "..."; proc report; etc etc... run; ods excel close;

vanja · ‎11-29-2018

You are absolutely right, I am a bit uncustomed to ask for help in forums. Next time I will do better.

vanja · ‎11-29-2018

Thank you so much for trying to help me. When I finally got the macro code to work I stick with my original solution. But I am so grateful for the help and for explaining to me why I got that warning message. Did not at all understand it was because of leap years.

vanja · ‎11-29-2018

Thank you for the %eval-code. It made me realize that I was right from the beginning. %put >>%eval(&valuesYear1=&valuesAr1)<< ; The mistake I made when I wrote "that it didn't work" must have been that I wrote values=("&valuesYear1"), that is I wrote it within quotes. What a stupid mistake. Now my original code actually works.

vanja · ‎11-29-2018

You are absolutely right. The code looks ok to me too but the macro variable it produces does not work in the value statement. However, this macro variable works. But I would so much like it to by dynamic. %let valuesAr1="2002" "2003" "2004" "2005" "2006" "2007" "2008" "2009" "2010" "2011" "2012" "2013" "2014" "2015" "2016" "2017" "2018" "2019";

Online Status	Offline
Date Last Visited	‎08-19-2024 07:17 AM

Re: Date conversion SPSS numeric to SAS date

Re: Date conversion SPSS numeric to SAS date

Date conversion SPSS numeric to SAS date

Re: How do I count maximum consecutive 1:s?

Re: How do I count maximum consecutive 1:s?

Re: How do I count maximum consecutive 1:s?

Re: How do I count maximum consecutive 1:s?

Re: How do I count maximum consecutive 1:s?

How do I count maximum consecutive 1:s?

Re: ODS Excel options(contents='ON') - but no table of contents

Re: Date conversion SPSS numeric to SAS date

Re: How do I count maximum consecutive 1:s?

Re: How do I count maximum consecutive 1:s?

Re: How do I count maximum consecutive 1:s?

Re: Date conversion SPSS numeric to SAS date

Re: Date conversion SPSS numeric to SAS date

Date conversion SPSS numeric to SAS date

Re: How do I count maximum consecutive 1:s?

Re: How do I count maximum consecutive 1:s?

Re: How do I count maximum consecutive 1:s?

Re: How do I count maximum consecutive 1:s?

Re: How do I count maximum consecutive 1:s?

How do I count maximum consecutive 1:s?

Re: ODS Excel options(contents='ON') - but no table of contents

ODS Excel options(contents='ON') - but no table of contents

Re: Create a macro variable list with quoted values

Re: Create a macro variable list with quoted values

Re: Create a macro variable list with quoted values

Re: Create a macro variable list with quoted values