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: 
andreas_lds
  • 3,749 Posts
  • 1,335 Likes Given
  • 375 Solutions
  • 1,323 Likes Received
This widget could not be displayed.

Re: PROC Report footer

by Jade | Level 19 in SAS Programming
‎08-29-2017 03:51 AM
‎08-29-2017 03:51 AM
Several papers exists describing the more advanced uses of proc report: http://www2.sas.com/proceedings/sugi24/Coders/p080-24.pdf http://support.sas.com/resources/papers/proceedings10/215-2010.pdf   ... View more

Re: How do I create an ID variable accounting for duplicates?

by Jade | Level 19 in SAS Programming
‎08-28-2017 09:57 AM
‎08-28-2017 09:57 AM
@Kurt_Bremser: Thanks for the example dataset 😉   You can use a one-way-hash-function:   data have_ssn; input ssn $ child; cards; 4567 1 32676 1 4567 2 45678 1 ; run; data want_ssn; set work.have_ssn(rename=(ssn = ori_ssn)); length ssn $ 32; format ssn $hex64.; ssn = sha256(ori_ssn); drop ori_ssn; run; ... View more

Re: Mapping visits for study

by Jade | Level 19 in SAS Programming
‎08-28-2017 03:58 AM
‎08-28-2017 03:58 AM
@siri6 wrote: It is not working, still need assistance, thanks in advance Than please post input an desired output. ... View more

Re: is there any option to send procedures used in program to output f...

by Jade | Level 19 in SAS Programming
‎08-25-2017 04:42 AM
‎08-25-2017 04:42 AM
SAS Enterprise Guide 7.x can create Excel files from the any procedures output without additional code. Depending on the SAS version available to you and the environment you are working in, you will have to search for "ods excel" and/or "ods tagset.excelxp". Your will moist likely find a paper explaining the details.   If you want to move the procedures logic to Excel: no that is not possible. ... View more

Re: How can I change my SAS Studio IP to Asia-Pacific instead of USA?

by Jade | Level 19 in SAS Studio
‎08-25-2017 04:29 AM
‎08-25-2017 04:29 AM
Sorry, but i don't understand your problem. Chaning your computers ip-address has nothing to do with SAS. ... View more

Re: Help resolving SAS errors - Statement is not valid

by Jade | Level 19 in SAS Programming
‎08-24-2017 04:32 AM
‎08-24-2017 04:32 AM
Afaik there is only one ELSE statement allowed after IF. But you don't need IF at all:   efac = resolve(cats('&earnq', quarter));   Edit: missed the IFs ... ... View more

Re: base sas

by Jade | Level 19 in SAS Programming
‎08-24-2017 04:15 AM
‎08-24-2017 04:15 AM
SAS provides a detailled product documentation, there you will an explanation of almost every aspect of the sas programming language. ... View more

Re: ERROR: The connection was reset by a peer..

by Jade | Level 19 in SAS Programming
‎08-23-2017 05:18 AM
‎08-23-2017 05:18 AM
Did you check the url from sas server or from your computer? ... View more

Re: Macro in a Macro?

by Jade | Level 19 in SAS Programming
‎08-22-2017 10:24 AM
‎08-22-2017 10:24 AM
By using the option sheet_interval="none" both outputs are written to one sheet, but the given stating positions are ignored. ... View more

Re: input without knowing length

by Jade | Level 19 in SAS Programming
‎08-22-2017 09:11 AM
‎08-22-2017 09:11 AM
Another way to verify that the char var has been converted successfully, uses the double ? modifier in the input function. Thanks to @Kurt_Bremser for provding example data 😉   data test; input b :$32.; a = input(b, ?? best32.); if missing(a) and not missing(b) then put 'WARNING: Failed to convert ' b 'Check obs' _n_= ; format a best32.; cards; 123456.78 12345678912.22 1.12345678905 bob 3.14159265358979323846 ; run; proc print data=test noobs; run; ... View more

Re: The file associated with this view could not be located.

by Jade | Level 19 in SAS Programming
‎08-22-2017 04:18 AM
‎08-22-2017 04:18 AM
EGPs are zipped folders. In case of an emergency unzipping it could be the only way to find out what went wrong. You will find the contents of your project in numerous xml-files, code is stored in normal sas-program-files.   On opening code, i have never seen such an error message. ... View more

Re: Sizekmg format to show TB

by Jade | Level 19 in SAS Programming
‎08-22-2017 03:52 AM
‎08-22-2017 03:52 AM
Unfortunately the fortmatted value in the 4th obs is wrong. 65536 Bytes are 64 kiB. ... View more

Re: SASUSER Library ?FOLDERID_Documents\My SAS Files\9.4 Fails on Task...

by Jade | Level 19 in SAS Programming
‎08-22-2017 03:44 AM
‎08-22-2017 03:44 AM
Which user starts the job when running as task? ... View more

Re: cleaning character columns

by Jade | Level 19 in SAS Programming
‎08-11-2017 03:03 AM
‎08-11-2017 03:03 AM
Write down every rule you want to apply to the variable Addresses, then start coding.   Maybe deleting the unwanted content is easier than extracting the required information, the last line of your example give that approach additional complexity.   Regular Expression seem to be the best way to extract the street names. ... View more

Re: SAS Enterprise Guide Breite vom Properties-Fenster dauerhaft vergr...

by Jade | Level 19 in CoDe SAS German
‎08-10-2017 10:39 AM
‎08-10-2017 10:39 AM
Da gibt es wohl - mal wieder - Unterschiede in der Art und Weise wie das Eigenschaftenfenster geöffnet wird. Wenn ich es direkt aus Serverliste öffne, dann verhält es sich exakt so, wie beschrieben. Wenn ich die Eigenschaften eines geöffneten Datasets anschaue, dann sind alle relevanten Spalten direkt sichtbar. Warum es hier überhaupt zwei so unterschiedliche Dialoge gibt ist kaum nachvollziehbar.   Für einige Dialoge werden die Einstellungen im Verzeichnis  %APPDATA%\SAS\EnterpriseGuide\7.1 gespeichert, aber scheinbar nicht für den Eigenschaften-Dialog. ... View more
Contact Me
Group Hubs for andreas_lds
View All
Likes given to
View All
Likes from
Quick links