About rsva

rsva · ‎08-29-2011

Thanks Duke.

rsva · ‎08-15-2011

Good Morning, Can anyone recommend a good book for using SAS in Health insurance data? For example using SAS in analyzing health insurance claims, false claims etc. Thanks in advance.

rsva · ‎07-29-2011

Thanks. I was planning to do that. But I have to resave 50 files. I wanted to see if there is a easier way to do it SAS with existing file extension.

rsva · ‎07-29-2011

How do you use namerow and startrow options with range option to import excel files with xlsx extension Thanks.

rsva · ‎07-29-2011

Sure. Below is my code. Proc import out=x; datafile='xxx.xls' dbms=excel replace; getname=yes; namerow=9; datarow=10; Run; Data x; Set x; Where variable1 ne ' '; Run; For my case footnotes in all the 50 spreadsheets starts in column2 instead of 1. If my footnotes were to start in column1 I was planning to see if I could use 'nodigit' function since my column1 has numbers.

rsva · ‎07-28-2011

Thanks. Still did not work. I find a way around. I used the namerow and datarow options in Proc Import. The data had footnote. Then in dataset I retained obs for the id variables that were not missing. this helped to get the desired result. thanks a lot again for all who responded

rsva · ‎07-27-2011

Yes, Footnote always takes up one cell. Yes, Name, age, and sex all are always present. Still doesn't work. If I use if nmiss(name sex age) ge 1 then stop; I get Error 388-185: expecting an arithmetic operator If I use if nmiss(name) ge 1 then stop; or if nmiss(name, age, sex) ge 1 then stop; I get NOTE: variable name is uninitialized and no data I am replacing the variable names, I am not sure that is causing these errors or something else that I am not seeing. Thanks once again.

rsva · ‎07-27-2011

Try this Proc import datafile="xx.xls" dbms=xls replace out=newdata; getnames=yes; namerow=3; datarow=4; Run;

rsva · ‎07-27-2011

Thanks. But it didn't work. With the code I get additional columns other than the variable name I need and there is no data. I used if nmiss(of name age sex) then stop; Since my variables are not named as v1-v4. I used them for e.g. purposed. But the variables in all the worksheets are same. I partly solved the problem with below code. Proc import out=x datafile='xxxx.xls' dbms=xlsreplace; getname=yes; namerow=9; /*this helped to use the values as variables names*/ datarow=10; Run; With this code my data looks Name Age Sex a s d Footnote I am yet to figure out how to remove the footnote. Also since there are several datasets that I am importing and the row with footnote is not consistent I am not sure how to put them in macro. Thanks.

rsva · ‎07-27-2011

50 workbooks (xls files) WorkBook1 Heading1 Heading2 Heading3 AK Name Age Sex q w e Foortnote WorkBook2 Heading1 Heading2 Heading3 AL Name Age Sex a s d f g h Footnote

rsva · ‎07-27-2011

Hello, I am importing )Proc Import) ~50 spreadsheets to SAS. There are couple of challanges. (1) variable names are in Row 9 and data begins in row 10. I tried to use datarow= option with getnames=. My variable names appear as first row instead of header in SAS. If I use datarow=10 and use getnames=yes, I get the data without any variable names (2) Data has footnotes. How to delete them? Since I am importing multiple workbooks, the row that footnote appears varies. E.g One.xlx has footnote in row 15 and two.xls has footnote in row 30. But the variable name and the first row of data alwys are in row 9 and 10. Below is a snap shot of my spreadsheet Heading1 Heading2 Heading3 AK V1 V2 V3 V4 1 2 3 4 Footnote I would like to use a macro instead of using 50 proc import statement. Any suggestions would help. Thanks.

rsva · ‎12-03-2010

Thanks for your question Peter. I tried SPR's sample code and included third row for an id. It worked fine. When I added a third row, Case1 (Coded as 2) xx1 20061023 GA 2 xx1 20080115 GA 2 xx1 20100115 GA 2 Case2 (Codes twin as 1 and the other as 2) sd45 20050203 FL 1 sd45 20050203 FL 1 sd45 20041023 FL 2 This is what my expected result was. Sorry for not being clear in my question. Thanks a lot.

rsva · ‎12-03-2010

Thanks SPR it worked perfectly.

rsva · ‎12-02-2010

I would like to compare a value between two rows. For e.g. I have duplicate id numbers in Column A, DOB in Column B, and state in Column C. Id DOB State xx1 20061023 GA xx1 20080115 GA sd45 20050203 FL sd45 20050203 FL h5g 20060709 NV h5g 20080115 NV 7uj 20071026 CA 7uj 20071026 CA I want to check if DOB for the two (same) ids are same. If they are same I would like to code as 1 else code as 2. Thanks in advance.

rsva · ‎11-15-2010

Thanks to all who replied to my post. It worked.

Online Status	Offline
Date Last Visited	‎05-31-2023 02:37 PM

Re: Automate SAS code for multiple sites

Automate SAS code for multiple sites

Re: Insufficient memory – SAS/SUDAAN PROC RLOGIST

Re: Insufficient memory – SAS/SUDAAN PROC RLOGIST

Insufficient memory – SAS/SUDAAN PROC RLOGIST

Re: Creating groups from values in different column for an ID

Creating groups from values in different column for an ID

Re: Get counts by groups across columns

Re: Get counts by groups across columns

Get counts by groups across columns

Re: Get counts by groups across columns

SAS and Health Insurance

SAS and Health Insurance

Re: variable names in "row 2" how to let PROC IMPORT to start from the...

Re: variable names in "row 2" how to let PROC IMPORT to start from the...

Importing excel with headings and footnotes to SAS

Importing excel with headings and footnotes to SAS

Importing excel with headings and footnotes to SAS

Re: Proc Import Excel

Importing excel with headings and footnotes to SAS

Importing excel with headings and footnotes to SAS

Importing excel with headings and footnotes to SAS

Re: Comparing rows

Re: Comparing rows

Comparing rows

Re: Macro