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: 
AncaTilea
‎11-18-2024
  • 544 Posts
  • 98 Likes Given
  • 2 Solutions
  • 293 Likes Received

Re: Removing string - in the data

by Pyrite | Level 9 in SAS Procedures
‎04-12-2013 01:48 PM
‎04-12-2013 01:48 PM
You don't need to change either of those s, or i (those are keywords for s = string, and i = case insensitive) the variable name is sample, right? ... View more

Re: Merge two records into one

by Pyrite | Level 9 in SAS Programming
‎04-12-2013 01:43 PM
‎04-12-2013 01:43 PM
Hi. Here is a very not most efficient code: data have;     input age sex $ hhnum;     cards; 0 F 1 10 M 1 45 F 1 43 M 1 10 F 2 10 M 2 15 F 2 43 M 2 ; *create an indicator for child in household or not; data temp(keep = hhnum child_flag);     set have; child_flag = ( age = 0 or age = 1); run; proc sort data = temp;by hhnum child_flag;run; data temp2;     set temp;     by hhnum;     if last.hhnum; run; data want;     merge have(where = (sex = "F" & 15 <= age <= 49))           temp2;     by hhnum;    run; let me know if it works? ... View more

Re: data

by Pyrite | Level 9 in SAS Programming
‎04-12-2013 01:31 PM
‎04-12-2013 01:31 PM
You can try this: proc sort data = trials1;by deptcode;run; data want;     set trials1;     by deptcode;     retain cnt;     if first.deptcode then cnt = 1;         else cnt ++ 1;     if cnt < 3; run; ... View more

Re: data

by Pyrite | Level 9 in SAS Programming
‎04-12-2013 01:18 PM
‎04-12-2013 01:18 PM
First, you need a dollar sign to tell SAS that department is character; data trials1; input id deptcode $ salary; datalines; 1001 FRM 23000 1002 GMM 45090 ... ; OK, so, what do you need? what two departments would you like to select? Your question is very vague. Do you need the two departments with the top salary? or? ... View more

Re: Removing string - in the data

by Pyrite | Level 9 in SAS Procedures
‎04-12-2013 01:13 PM
‎04-12-2013 01:13 PM
hmmm, something like this: Data sample; input sample $50.; cards; AMD1_9-History of another malignancy within AMD1_10-Current or prior treatment with estrogens ; Run; proc print;run; data want;     set sample;     new_sample = prxchange("s/.*[-]//i",1,(sample)); run; proc print;run; ... View more

Re: Tagsets.excelxp Error (9.3)

by Pyrite | Level 9 in ODS and Base Reporting
‎04-12-2013 01:01 PM
‎04-12-2013 01:01 PM
Can you try this? 45306 - Specifying a page dimension with PROC TABULATE and the ExcelXP tagset generates an invalid XML file in SAS® 9.3 It turns out that the "systemtitle__c__c" is already known as problematic. ... View more

Re: Removing string - in the data

by Pyrite | Level 9 in SAS Procedures
‎04-12-2013 12:54 PM
‎04-12-2013 12:54 PM
You have a variable called sample like this Sample Amd1_9- AMD1_10- Could you please be more specific what do you need the new variable to look like: Sample ? ? And for the other problem with removing the string, why do you need more ways? what's wrong with what either I or LinLin offered? data have; input string$; cards; abc -bc -a-b ; data want;   set have;   string1= prxchange("s/-//i",1,strip(string)); run; should work.... ... View more

Re: Removing string - in the data

by Pyrite | Level 9 in SAS Procedures
‎04-12-2013 12:52 PM
‎04-12-2013 12:52 PM
Which Colon part? What do you need? This is what you have for a variable named sample it takes values amd1_9- and amd1_10- Sample Amd1_9- AMD1_10- And you want an new variable new_sample to take what values exactly: New_Sample ? ? ... View more

Re: Removing string - in the data

by Pyrite | Level 9 in SAS Procedures
‎04-12-2013 12:49 PM
‎04-12-2013 12:49 PM
Hi. what does the " =: " mean? Thank you. Anca. ... View more

Re: Removing string - in the data

by Pyrite | Level 9 in SAS Procedures
‎04-12-2013 11:42 AM
‎04-12-2013 11:42 AM
How about this: data have; input v$; cards; abc -bc -a-b ; data want;   set have;   v1= prxchange("s/-//i",1,strip(v)); run; ... View more

Re: Tagsets.excelxp Error (9.3)

by Pyrite | Level 9 in ODS and Base Reporting
‎04-12-2013 11:32 AM
‎04-12-2013 11:32 AM
So, the problem with the xml that you are creating is that it gets a "bad value" specifically it gets "systemtitle__c__c" and it doesn't know what to do with it If you look at this comment http://stackoverflow.com/questions/8833929/error-in-excel-file in their case they got value 5... well in your case you get value systemtitle__c__c ... I google more ... View more

Re: Removing string - in the data

by Pyrite | Level 9 in SAS Procedures
‎04-12-2013 10:59 AM
‎04-12-2013 10:59 AM
, very nice; is the 'ifc" saying if the first character in string V is "-"?? That's awesome! Or am I misunderstanding? Yes, I am misunderstanding...I read on the IFC function. is the first(v), the FIRST function that tells SAS that if the first character is "-' then so on... still neat! ... View more

Re: Tagsets.excelxp Error (9.3)

by Pyrite | Level 9 in ODS and Base Reporting
‎04-12-2013 10:47 AM
3 Likes
‎04-12-2013 10:47 AM
3 Likes
I find it interesting that the code works (probably not creating the table you want) when you remove one comma: .... weight = "weight" *mean='' *f=comma24.0 ) ,   (sex='') ,(age='').... Without the comma, the code runs. With the comma, it doesn't. ods tagsets.excelxp  file="c:\junk.xml"     style=sasweb   options (SHEET_INTERVAL="NONE"   absolute_column_width = '14,6.5,6.5,6.5,6.5,6.5,6.5,6.5,6.5,6.5,6.5,6.5,6.5,6.5,6.5'   embedded_titles='no'   PAGES_FITWIDTH="1" FitToPages="YES"   orientation='Landscape'); ods tagsets.excelxp options (Sheet_Name = "Portfolio"); title'Delinquency Trends by Portfolio';*/; proc tabulate data=sashelp.class missing; class name sex age; var height weight;    tables  (name='')*(    height = "height" *mean='' *f=comma24.0    weight = "weight" *mean='' *f=comma24.0 ) (sex='') ,(age='') / box = '' row=float; run; ods _all_ close;title; ... View more

Re: Tagsets.excelxp Error (9.3)

by Pyrite | Level 9 in ODS and Base Reporting
‎04-12-2013 10:24 AM
‎04-12-2013 10:24 AM
Could you try to delete any existing .xml file that you've created (or make a copy with a different name) then try to run the code again? ... View more

Re: Percentiles

by Pyrite | Level 9 in Statistical Procedures
‎04-12-2013 09:48 AM
3 Likes
‎04-12-2013 09:48 AM
3 Likes
How about this: proc summary data = sashelp.class p75 print;     var age; run; But I am not sure it is the quickest. ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎11-18-2024 07:33 PM
Likes given to
Quick links