About PTD_SAS

PTD_SAS · ‎02-22-2015

Yes, I think this is the most likely cause. I asked our IT department to compare the properties of the 2 accounts.

PTD_SAS · ‎02-18-2015

Yes, it runs fine under my own account in batch or interactively. It's the other account we have specifically for batch jobs that is giving the problem. The workbook has quite a few sheets but I wouldnt think that would be a problem.

PTD_SAS · ‎02-18-2015

Thanks!

PTD_SAS · ‎02-18-2015

Kurt, Thanks for that. Would you have any example code using tagsets for Excel? Just in case, because I'm not familiar with this. Thanks!

PTD_SAS · ‎02-18-2015

I run 64 bit SAS 9.4 M2 on Windows 7 and using PROC EXPORT with EXCELCS engine to export to 32 bit Excel. SAS PC Files service is installed. The workbook I export to has multiple sheets and has xlsb format. I have installed the correct version of PC Files Server to match the bits and SAS version. The problem I have is everything runs fine under my own account but the program hangs without errors under another account we have to run SAS batch jobs. Both accounts have administrator privileges. It's very puzzling, it looks like the cause may be some differences in the account properties/attributes? Would anyone be able to help? Thanks.

PTD_SAS · ‎10-06-2014

Thank you Reeza, saved me a lot of time!

PTD_SAS · ‎10-06-2014

Could I get some help on how to create centered values of variables in a dataset? In the attached example I'd like to calculate the grand mean for score1 and score2 and then subtract each value of score1 and score2 from their corresponding grand mean. I need to do this on a grand scale for many variables so I suppose it's an exercise in how to merge the raw data with the grand means of each variable. Or, is there a statistical procedure that can do it? Thanks!!

PTD_SAS · ‎08-19-2014

Thanks, good hints.

PTD_SAS · ‎08-19-2014

Thanks, very smart with just one line of code! Exactly what I wanted.

PTD_SAS · ‎08-19-2014

Thank you, helpful hints. Fethon

PTD_SAS · ‎08-19-2014

Would anyone suggest an algorithm to group dates by cponsecutive bi-monthly groups? I.e. similar to quarters but insteaed of 3 to have 2 month groups. For example, Jan-Feb 2014 would be B1 (similar to Q1 for quarters), Mar-Apr 2014 would be B2 etc. Thanks, Fethon Naoum

PTD_SAS · ‎05-21-2014

I specified the length when I merged the datasets and it worked fine! Thank you...

PTD_SAS · ‎05-21-2014

How can I modify the length of all variables in a dataset without having to recreate them? Can it be done with Proc Datasets? I have an old and a new dataset with the same variable names but diffrent lengths, when I merge them I get the warning "Multiple lengths specified for the variable xxxx. This may cause truncation of data".

PTD_SAS · ‎11-05-2013

Thanks Peter, that's an elegant way of doing it.

PTD_SAS · ‎11-03-2013

Thanks Jagadish, that answered my question! Fethon Naoum

Online Status	Offline
Date Last Visited	‎05-01-2018 02:05 AM

Re: PROC SQL

Trim variables in PROC SQL

Re: Varying colours in vaxis

Re: Varying colours in vaxis

Varying colours in vaxis

Re: SAS colors for overlay graphs

Re: SAS colors for overlay graphs

SAS colors for overlay graphs

Colors in overlay graphs

Re: Changing colors in waterfall charts

Re: PROC SQL

Re: Varying colours in vaxis

Re: SAS colors for overlay graphs

Re: SAS colors for overlay graphs

Re: Colors in overlay graphs

Re: PROC EXPORT with PCFILES Service

Re: PROC EXPORT with PCFILES Service

Re: PROC EXPORT with PCFILES Service

Re: PROC EXPORT with PCFILES Service

PROC EXPORT with PCFILES Service

Re: Centering variables

Centering variables

Re: Grouping dates by bi-monthly groups

Re: Grouping dates by bi-monthly groups

Re: Grouping dates by bi-monthly groups

Grouping dates by bi-monthly groups

Re: Modifying the length of variables in a dataset

Modifying the length of variables in a dataset

Re: Saving log files

Re: Saving log files