About NKormanik

NKormanik · ‎01-26-2015

Perhaps using 0 to 4 would work, too, as opposed to 1 to 5. I don't see that it would make any difference. So Proc Rank may be the one to use. I would greatly prefer not having to put in specific values of the raw data, as I have a hundred such variables to recode.

NKormanik · ‎01-26-2015

Please suggest a way of recoding a continuous variable into a 'Likert Scale' variable. Lowest 20% should be translated to 1. Next 20% should be translated to 2. . . Top 20% should be translated to 5. Your help is greatly appreciated. Nicholas Kormanik

NKormanik · ‎10-16-2013

Outstanding. Thank you!

NKormanik · ‎10-16-2013

Because I don't know how to do it. I'm the one asking how. At this point I'd like a clear path for others out there that search for the answer.

NKormanik · ‎10-16-2013

Perhaps I should concisely restate the objective: User wants to convert all the SAS data files in folder XYZ into Excel format. Any number of files. Whatever the file names. Maintain file names, only changing the extension in created output. I feel this problem is pretty basic, in that many people around the globe would like to be able to easily do this. When they do an Internet search for the answer..., I hope they will come upon this thread, and happily find the answer. This all seems a lot more complicated than it should be.

NKormanik · ‎10-16-2013

Yes, , your assumption is correct. I've looked over your code and can't see any easy way of solving the truncation issue. So..., how is it done?

NKormanik · ‎10-15-2013

In the original question I did say, "Resulting converted/exported files should retain the filename, but have the .xls extension." I haven't a clue how to fix the truncation...... All Greek to me.

NKormanik · ‎10-13-2013

Fantastic. It works. Only minor problem is that the code causes a truncation of the first character of the filename. I wonder if you can fix what's causing that? Example: _00001.sas7bdat ---> 00001.xls data.sas7bdat ---> ata.xls Thanks!

NKormanik · ‎10-12-2013

Hmmm. Not quite, apparently: ERROR: Variable memtype is not on file SASHELP.VSTABLE. NOTE: The SAS System stopped processing this step because of errors.

NKormanik · ‎10-12-2013

By the way, if it wasn't clear..., the SAS data files are being held within the folder C:\Downloads (which is also libref Nicholas). That would be the same location I'd like to place the converted/exported files. I tried the code you used in your reply, and indeed it worked fine. Could the code be generalized so that any SAS data filename would work? Thanks.

NKormanik · ‎10-12-2013

Perhaps the problem I had was in the naming of the files. The test files I used had different names from the example I gave at the outset. Sorry for that confusion. I was assuming in my original question that any filename would work with the code.

NKormanik · ‎10-12-2013

Thanks for trying, Patrick. I placed several test SAS data files into C:\Downloads and tried your code. Unfortunately..., no go: NOTE: There were 0 observations read from the data set SASHELP.VSTABLE. WHERE (libname='Nicholas') and (PRXMATCH('/^_\d+ *$/', memname)>0); Any further ideas?

NKormanik · ‎10-11-2013

In my primary working folder are 1000 .sas7bdat data files. C:\Downloads which is also libref Nicholas I would like to batch convert these into Excel format. Resulting converted/exported files should retain the filename, but have the .xls extension. The converted files should be placed in the same primary working folder as the original files. Below is how I've been exporting single files: proc export data=nicholas.wxyz outfile= "C:\Downloads\wxyz.xls" dbms=xls label replace; putnames=yes; run; If it can be done, would someone please help with the SAS code to accomplish it? Thanks much. Your help is greatly appreciated. Nicholas Kormanik

NKormanik · ‎08-02-2013

Finally, as a motivator of sorts, let's imagine the data set representing professional basketball. And the top five contestants will be awarded multi-million dollar contracts. Huge money awaits the grand winners. All up to our statistical pronouncements.

NKormanik · ‎08-02-2013

An additional question I'd like to ask regarding the data set is: Is it possible to derive any additional information from the results, besides the primary objective of determining individual 'winners'? Any procedure in SAS come to mind, to bring out a pattern, that is not so obvious, but that statistically is present?

Online Status	Offline
Date Last Visited	4 weeks ago

When is your SAS program good enough???

Re: Reset SAS without restarting SAS????

Reset SAS without restarting SAS????

Re: PROC GAMSELECT

Re: PROC GAMSELECT

PROC GAMSELECT

Re: Fascinating exchange with LLM

Fascinating exchange with LLM

Re: Trouble getting a macro to execute....

Trouble getting a macro to execute....

Re: When is your SAS program good enough???

Re: When is your SAS program good enough???

Re: When is your SAS program good enough???

Re: When is your SAS program good enough???

Re: When is your SAS program good enough???

Re: Using SAS Studio Online to Convert A Dataset

Re: User wants SAS code to return to Log window

Re: Logistic Regression -- Understanding Maximum Likelihood

Re: Interpreting 'Predicted' in Proc Logistic -- What's your take?

Interpreting 'Predicted' in Proc Logistic -- What's your take?

Re: Recode continuous variable into a 1 through 5 variable

Recode continuous variable into a 1 through 5 variable

Re: Batch convert (export) a set of SAS data files to Excel format

Re: Batch convert (export) a set of SAS data files to Excel format

Re: Batch convert (export) a set of SAS data files to Excel format

Re: Batch convert (export) a set of SAS data files to Excel format

Re: Batch convert (export) a set of SAS data files to Excel format

Re: Batch convert (export) a set of SAS data files to Excel format

Re: Batch convert (export) a set of SAS data files to Excel format

Re: Batch convert (export) a set of SAS data files to Excel format

Re: Batch convert (export) a set of SAS data files to Excel format

Re: Batch convert (export) a set of SAS data files to Excel format

Batch convert (export) a set of SAS data files to Excel format

Re: Determine top five winners (Part 2) -- Breakdown of Pairs

Re: Determine top five winners (Part 2) -- Breakdown of Pairs