cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
maggi2410
‎10-21-2015
  • 43 Posts
  • 6 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: excel to SAS dataset in UNIX

by Obsidian | Level 7 in Microsoft Integration with SAS
‎11-30-2012 02:13 PM
‎11-30-2012 02:13 PM
Actually I dont have PC SAS. SAS is installed on other servers, and I submit the code via XTERM. Now, everytime I submit the code, I guess, whichever server is free, the code is submitted on that. So its random. What do you think in this case, can I still use PCFILES? For now, I am converting the sheet into dab delimited file and then reading it. It is still truncating the columns , maximum length being 201. The code I am using is: data temp.temp1     ;     infile '../test.txt' delimiter='09'x MISSOVER DSD lrecl=800 firstobs=3 ;               length chg_ref    $800;               format _all_;informat _all_;                     input     chg_ref    ;     run; Do you think there is any problem in this. This UNIX system is getting on my nerves now. ... View more

excel to SAS dataset in UNIX

by Obsidian | Level 7 in Microsoft Integration with SAS
‎11-29-2012 07:27 PM
‎11-29-2012 07:27 PM
Hi , I have an excel file, which columns having length around 500-600 chars. I have to convert this to SAS dataset, in UNIX. I am trying to use the excel libname with PCFILES statement, but it has one more argument , ie SERVER. Now I am not very sure, what should be its value. I am running the code using XTERM. But the SAS Code and excel file are on some other drive, say U drive. If the server name is of U drive , then how could I find out its server name. Any thoughts? ... View more

Re: converting excel file to SAS dataset using xlxp2sas

by Obsidian | Level 7 in SAS Programming
‎11-29-2012 06:21 PM
‎11-29-2012 06:21 PM
This is a simple excel file, 2003, not an xml file ... View more

converting excel file to SAS dataset using xlxp2sas

by Obsidian | Level 7 in SAS Programming
‎11-29-2012 06:21 PM
‎11-29-2012 06:21 PM
Hi All, I am converting an excel file to SAS dataset using xlxp2sas. The reason I am using xlxp2sas is: My excel file has columns with text more then 250 characters and I am using UNIX(9.2) system, and the sheet name has special characters, and the header names has special characters ..phew!! the excel libname statement doesnt work on UNIX, and Proc import causes truncation. In short, I have to use xlxp2sas. Nowwhen I use it on test file(with 1 row, 1 column), even throws error "ERROR: Expected an XML document prolog or element.", even on test file. I am using the attached map file. Do anyone has any idea to resolve this pesky error??? My code is : %xlxp2sas(excelfile=./test.xls,                    mapfile=./excelxp.map); ... View more

Re: Substituting reference values

by Obsidian | Level 7 in SAS Programming
‎11-14-2012 07:52 PM
‎11-14-2012 07:52 PM
@art: U r awesome. Your solution is just so unique and perfect.Thanku so much. Update is really helpful. I should read more about it. @richard: Many thanks for introducing update! ... View more

Substituting reference values

by Obsidian | Level 7 in SAS Programming
‎11-14-2012 05:31 PM
‎11-14-2012 05:31 PM
Hi, I have two datasets. Ref contains refrence values, with ID and 1000 variables but just one row. B dataset contains ID, DOB, and same 1000 variables. Now Some of those 1000 variables in dataset B are populated and some are missing. Wherever those vallues are missing I need to pick the value of that variable from Ref dataset . Do anyone has a short way of doing it. I dont want to rename 1000 variables in ref dataset and then after merging substitute the value. I was thinking of using coalesce function in SQL, but that also needs naming all the variables. Any help would be appreciated. Thanks! ... View more

Re: to name excel tabs

by Obsidian | Level 7 in ODS and Base Reporting
‎09-18-2012 02:07 PM
‎09-18-2012 02:07 PM
It doesnt work. Excel converts hypehn and bracket to underdcores... ... View more

to name excel tabs

by Obsidian | Level 7 in ODS and Base Reporting
‎09-18-2012 01:48 PM
‎09-18-2012 01:48 PM
Hi, I have three datasets, and I am exporting the data to excel using libname AS FOLLOWS: libname excl "..\export\&infl."; data excl.Sheet1(dblabel=yes);    set FINAL1; run; Now the problem is I have three datasets final1, final2, final3.While exporting to excel I have to create thrree tabs with these three datasets and rename the exc el tab as : Base-line(Geno), Post-Bl(Geno) etc etc.. ie with Hyp[hen and brackets. How can I do that? I can use libname statement only to export data as My data has very long character fields. Thanks! ... View more

Re: labels while proc exporting

by Obsidian | Level 7 in SAS Programming
‎08-09-2012 08:10 PM
‎08-09-2012 08:10 PM
Great. I guess it depends a lot in your sas version and your platform. Mine is 9.1 on UNIX. and somehow didnt work. ... View more

Re: labels while proc exporting

by Obsidian | Level 7 in SAS Programming
‎08-09-2012 07:10 PM
‎08-09-2012 07:10 PM
yes..nothing worked for me.. but i got this solution finally: via libname statement use dslabel dataset option. But it doesnt replace your excel. So you have to add an extra piece of code to do so. Thanks ... View more

labels while proc exporting

by Obsidian | Level 7 in SAS Programming
‎08-09-2012 06:08 PM
‎08-09-2012 06:08 PM
Hi, I have a sas dataset with columns having labels. While using the proc export, I want the labels to be the first row in the excel. I have tried label option and putnames=no too. But nothing works for me. Any idea? Mine is 64 bit SAS and DBMS = excel(not xls) is used. Thanks!! ... View more

Re: Proc Import eliminating zeroes from decimal places

by Obsidian | Level 7 in SAS Programming
‎08-07-2012 02:30 PM
‎08-07-2012 02:30 PM
Thanks everybody for your valuable answers.   it still doesnt work for me this solution also wont work for me. Firstly, because mine is a UNIX server. And DDE isnt working on it. Also, as I got to automate this process of excel to tab delimited file conversion without any data change, I can't add rows to even duplicate copy of excel(coz that would again involve reading excel which would again cause the same issue). Again, my task is to convert the excel(with all possible values) to tab delimited txt file AUTOMATICALLY. ... View more

Re: Proc Import eliminating zeroes from decimal places

by Obsidian | Level 7 in SAS Programming
‎08-06-2012 07:15 PM
‎08-06-2012 07:15 PM
My excel already has a row for the column names. thats why i used yes. ... View more

Re: Proc Import eliminating zeroes from decimal places

by Obsidian | Level 7 in SAS Programming
‎08-06-2012 07:00 PM
‎08-06-2012 07:00 PM
I dont know why..but it still isnt working.. ... View more

Re: Proc Import eliminating zeroes from decimal places

by Obsidian | Level 7 in SAS Programming
‎08-06-2012 06:51 PM
‎08-06-2012 06:51 PM
@Art: If you mean something as shown below: If my excel has three records like this :       ,xxx(extra record) aaa, 12.20 bbb, 12.2 ccc,12.22 This also doesnt work for me ...:( This is the code m using PROC IMPORT OUT= tfl      DATAFILE= "./docs/tnf.xls" DBMS=XLS REPLACE;      sheet="tfl";  GETNAMES=YES;  MIXED=YES; RUN; ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎10-21-2015 02:01 PM
Likes given to
Quick links