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: 
milts
‎05-12-2018
  • 339 Posts
  • 30 Likes Given
  • 0 Solutions
  • 23 Likes Received

Re: IN

by Pyrite | Level 9 in SAS Procedures
‎09-14-2009 10:10 PM
‎09-14-2009 10:10 PM
Hi Luis, You got it right. It takes the value of 1 if X is equal to 1 or 3. Regards, Milton ... View more

Re: Error reading dataset using Enterprise guide 4

by Pyrite | Level 9 in SAS Procedures
‎09-10-2009 10:23 PM
‎09-10-2009 10:23 PM
Hi HelpHelp, Log in to your SMC and kindly check the library where the dataset is located. It should have both read metadata and read allowed i think. Regards, Milton ... View more

Re: Missing Source file in a job DI studio(9.1.3)

by Pyrite | Level 9 in SAS Procedures
‎09-08-2009 08:14 PM
‎09-08-2009 08:14 PM
Hi, Have you applied the latest hotfix for DI Studio? Not sure if this solves the issue. Regards, Milton ... View more

Re: variables in a-z manner

by Pyrite | Level 9 in SAS Procedures
‎09-03-2009 04:06 AM
‎09-03-2009 04:06 AM
Hi R_Win, try this one. proc transpose data=fin out=trans; var _all_; run; proc sort data=trans; by _name_; run; proc transpose data=trans out=trans2; run; Regards, Milton ... View more

Re: lloop through a dataset

by Pyrite | Level 9 in SAS Programming
‎09-02-2009 08:00 PM
‎09-02-2009 08:00 PM
Hi Darth, use the call execute statement in your statement call execute('%UpdateValueById(id=' || id || ')'); hope this solves your problem. Regards, Milton ... View more

Re: read text from a .sas file

by Pyrite | Level 9 in SAS Procedures
‎09-02-2009 07:54 PM
‎09-02-2009 07:54 PM
Hi Neel, you used proc print to create the listing if i got it right. just add the noobs option in your proc print statement. Regards, Milton ... View more

Re: SAS warning notification

by Pyrite | Level 9 in SAS Procedures
‎09-01-2009 02:25 AM
‎09-01-2009 02:25 AM
Chris I'm not sure if there is a way but the closest thing i think is the syscc auto macro variable which returns a code to determine if the process has warning,errors,etc. it returns a specific code depending on the result of the step. for more info about the automatic variable you can use sashelp and type syscc. return codes stated in the sashelp are for unix environments fyi. Regards, Milts ... View more

foundation services

by Pyrite | Level 9 in SAS Programming
‎08-26-2009 12:40 AM
‎08-26-2009 12:40 AM
anyone knows a good document on how to implement foundation services? thanks! milton ... View more

Re: How to show new/updated records in the target table?

by Pyrite | Level 9 in SAS Procedures
‎08-26-2009 12:35 AM
‎08-26-2009 12:35 AM
Hi, I'm not sure if there's actually a way to do that. However if you would like to track changes in your dataset you might opt to use the SCD Type 2 Loader transformation. Hope this helps Regards, milton ... View more

Re: A problem with integrity constraint

by Pyrite | Level 9 in SAS Procedures
‎08-18-2009 05:54 AM
1 Like
‎08-18-2009 05:54 AM
1 Like
Hi, Try to check the columns of your target table. probably some of your columns should not contain a null value and then you try to insert records with a null value on that particular column. Hope this helps. regards, milton ... View more

Re: compress single and double quote

by Pyrite | Level 9 in SAS Procedures
‎08-12-2009 08:13 PM
‎08-12-2009 08:13 PM
thanks a lot kevin! got it now ... View more

compress single and double quote

by Pyrite | Level 9 in SAS Procedures
‎08-11-2009 10:36 PM
‎08-11-2009 10:36 PM
hi all, let's say i have a value '00012345 how can i remove the single quote or double quote? if i use compress i'll get a compilation error since syntax for compress is compress(var," "); it is enclosed in double quotes so when you put a single quote and a double quote as your arguements, you wont be able to run the code. hope i was able to explain it correctly are there any ways to remove quotes? thanks in advance! ... View more

Re: row count

by Pyrite | Level 9 in SAS Procedures
‎08-11-2009 12:35 AM
‎08-11-2009 12:35 AM
wow! thanks rob and peter. learned something new from your posts. regards, milton ... View more

Re: row count

by Pyrite | Level 9 in SAS Procedures
‎08-06-2009 03:23 AM
‎08-06-2009 03:23 AM
Thanks Daniel that's what I'm looking for. Regards, Milton ... View more

Re: row count

by Pyrite | Level 9 in SAS Procedures
‎08-05-2009 11:14 PM
‎08-05-2009 11:14 PM
hi scott, thanks for the info, but in what way are these approaches inconsistent? is there any other way other than the select count into: statement in getting the number of obs of a certain dataset? thanks, milton ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎05-12-2018 02:19 AM
Likes given to
Quick links