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: Problem with PROC EXPORT

by Pyrite | Level 9 in SAS Procedures
‎01-28-2013 10:37 AM
1 Like
‎01-28-2013 10:37 AM
1 Like
what happens when you remove the DBMS option? PROC EXPORT DATA=last OUTFILE='/home/data.xlsx' DBMS=EXCEL REPLACE; SHEET="data"; version=2003; RUN; ... View more

Re: Problem with PROC EXPORT

by Pyrite | Level 9 in SAS Procedures
‎01-28-2013 10:15 AM
1 Like
‎01-28-2013 10:15 AM
1 Like
HI. Could you please try to change the extension of your file -- that you try to export to "/.../data.xlsx" and use DBMS = EXCEL; PROC EXPORT DATA=last OUTFILE='/home/data.xlsx' DBMS=EXCEL REPLACE; SHEET="data"; version=2003; RUN; Good luck! Anca. ... View more

Re: Proc Means: Getting the same information in both html and data set...

by Pyrite | Level 9 in Statistical Procedures
‎01-28-2013 09:07 AM
1 Like
‎01-28-2013 09:07 AM
1 Like
HI, you could use and ODS OUTPUT statement instead of OUTPU, something like this (I also incorporate the nice 'types ..()' as suggested by EJ above. (I am using sashelp.class as an example) proc means data=sashelp.class n mean median stddev max min skew kurtosis prt;   var age weight height;   class sex;     types sex ();     ods output Summary = temp_means;   title "Sample statistics"; run; title; data temp_means;     set temp_means;    if sex = " " then sex = "T";  *need to fill this in, we will need for transpose; run; proc transpose data = temp_means out = want; id sex; *this will keep the value of your class variable as column names; run; good luck! Anca. ... View more

Re: sample macro

by Pyrite | Level 9 in SAS Programming
‎01-25-2013 10:23 AM
1 Like
‎01-25-2013 10:23 AM
1 Like
No... %macro SASrules; else  /*this needs a preceding IF statement, you can't have an ELSE just hanging around*/ run; /* this is out of place...."ELSE;RUN;....should be more like ELSE; <statement to be performed>; RUN;*/ /*this could be ok, but you need to have a MACRO variable...maybe the 'b', or the '3'....*/ /* something like      data DS2;      set DS1;           a = sqrt(&macro_var.);           if a > 3;      run; */ data DS2; set DS1; a = sqrt(b); if (a > 3) then..../*then what?*/ %mend; ... View more

Re: convert ddmonyy:hh:mm:ss.ss to mmyyyy

by Pyrite | Level 9 in SAS Procedures
‎01-25-2013 10:17 AM
1 Like
‎01-25-2013 10:17 AM
1 Like
Great,Daniela. Would you mark it as answered ... View more

Re: 88/88/8888 mmddyy10. format

by Pyrite | Level 9 in SAS Programming
‎01-25-2013 10:04 AM
1 Like
‎01-25-2013 10:04 AM
1 Like
88/88/8888 is not a valid date... Could you provide more context? ... View more

Re: Default "view" preferences at startup of SAS

by Pyrite | Level 9 in SAS Programming
‎01-25-2013 09:28 AM
2 Likes
‎01-25-2013 09:28 AM
2 Likes
Hi. In a new SAS session, change the view to details. Then, under Tools/Options/Preferences Under the "general" tab click on "Save settings on exit" OK. Done. As far as the output window to not show up...not sure Anca. ... View more

Re: Incrementing variable backwards

by Pyrite | Level 9 in SAS Programming
‎01-24-2013 02:45 PM
3 Likes
‎01-24-2013 02:45 PM
3 Likes
HI. This may get you somewhere... or nowhere: *read in your data; data in; input ID $ 1-3   Fixed_Date; cards; Bob          0 Bob         4 Bob          5 Joe          0 Joe          6 Joe          6 Joe          6 Ed            0 Ed            9 Ed            9 ; run; *sort by ID, and create a count of how many records for each ID; *if last or first record within the ID, set the count to zero; proc sort data = in;by id; data temp;     set in;     by id;     retain cnt 0;     if first.id | last.id then cnt = 0;         else cnt ++ 1; run; *sort the data by descending 'cnt'; proc sort data = temp;by id fixed_date descending cnt;run; data want;     set temp; by id; new_date = fixed_date - cnt;     if last.id then new_dt = fixed_date; run; Please let me know if this is close to what you'd like. Thanks. Good luck. Anca. ... View more

Re: convert ddmonyy:hh:mm:ss.ss to mmyyyy

by Pyrite | Level 9 in SAS Procedures
‎01-24-2013 12:02 PM
1 Like
‎01-24-2013 12:02 PM
1 Like
How about this,Daniela? data temp;     date = '12Sep07:00:00:00'dt;*your date;     date_1 = put(datepart(date),monyy.);*your desired date; run; Good luck. Anca. ... View more

Re: Missing values in logistic regression

by Pyrite | Level 9 in SAS Programming
‎01-24-2013 11:13 AM
4 Likes
‎01-24-2013 11:13 AM
4 Likes
Hi. You could run proc mi data = your_data;     var your_list_of_variables; Ods Output MissPattern = miss_pattern; run; to get the pattern of missingness in your data. So then, you could run your model without the variable that has lots of missing (if it's not the most important predictor) Or you could impute. ... View more

Re: _n_ & _error_ in vector table

by Pyrite | Level 9 in SAS Procedures
‎01-24-2013 09:43 AM
‎01-24-2013 09:43 AM
So, _N_ and _ERROR_ are automatically created but not 'kept" in the data step; I don't think there are any 2 other variables created once _N_ initializes. _N_ and _ERROR_ are the two variables created. OK, I am talking in circles. This reading should be helpful: Step-by-Step Programming with Base SAS(R) Software ... View more

Re: _n_ & _error_ in vector table

by Pyrite | Level 9 in SAS Procedures
‎01-24-2013 09:33 AM
‎01-24-2013 09:33 AM
Hi from SAS page: SAS(R) 9.2 Language Reference: Concepts, Second Edition _N_  is initially set to 1. Each time the DATA step loops past the DATA statement, the variable _N_ increments by 1. The value of _N_ represents the number of times the DATA step has iterated. _ERROR_  is 0 by default but is set to 1 whenever an error is encountered, such as an input data error, a conversion error, or a math error, as in division by 0 or a floating point overflow. You can use the value of this variable to help locate errors in data records and to print an error message to the SAS log. Does this help? Anca ... View more

Re: Easy One.... Where string starts with [A-Z].....

by Pyrite | Level 9 in SAS Programming
‎01-24-2013 09:30 AM
1 Like
‎01-24-2013 09:30 AM
1 Like
Hi. I believe PRXMATCH would allow you to "match" any alphanumeric Something like this: data want;      set have(where = ( (prxmatch("m/[a-z]|[0-9]/i",your_variable) > 0)) ); run; For example, using sashelp.class if you want to keep the records that contain the letter 'b' or any number in the name: data want;      set sashelp.class(where = ( (prxmatch("m/|[0-9]/i",name) > 0) )); run; Good luck, Anca. ... View more

Re: SGPanel & ODS Layout - stretch chart across page

by Pyrite | Level 9 in Graphics Programming
‎01-23-2013 09:14 AM
‎01-23-2013 09:14 AM
Very interesting. Did you try 1. GOPTIONS reset = all;           2. Close SAS and open it again. ... View more

Re: Run a piece of code only if observations no is <30

by Pyrite | Level 9 in SAS Programming
‎01-23-2013 08:33 AM
‎01-23-2013 08:33 AM
Hi. Here is a similar option: In your PROC TTEST I would add an ODS OUTPUT statement: proc ttest data = ; class; var; ODS OUTPUT Statistics = number(keep = n);*THIS GIVES YOU THE NUMBER OF RECs PER CLASS; run; proc sql noprint;      select min(n) into :cnt      from number; quit; &if &cnt. > 30 %then %do; *------THE REST OF YOUR CODE; %end; Good luck! Anca. ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎11-18-2024 07:33 PM
Likes given to
Quick links