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: 
SaschaD
‎03-17-2022
  • 19 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Variable value does not appear in Email

by Obsidian | Level 7 in SAS Programming
‎03-17-2022 05:39 AM
‎03-17-2022 05:39 AM
Hello,   My code below runs successfully, but only shows the text of the two variables count_NO_contract and count_NO_sales. How do I have to change the code?       filename REPORT "%sysfunc(pathname(work))\output.html"; filename SEND email to = "XXX@XXX.com" SUBJECT = "Test Subject" content_type = "text/html" ATTACH = "&PATHNAME"; ods html file = REPORT style = HTMLBlue; PROC REPORT DATA=APPG.AZL_NG_BESTAND; COLUMN workday workvalue; DEFINE workday / GROUP; DEFINE workvalue / F = COMMAX10.; RBREAK AFTER / SUMMARIZE; WHERE workday >= 20220201; RUN; ods html close; data _null_; infile REPORT; file SEND; input; if _infile_ ne '</html>' then put _infile_; else do; PUT 'Process finished'; PUT 'unknown contracts: &count_NO_contract'; PUT 'unknown sales: &count_NO_sales'; end; run;   Thanks Sascha   ... View more

SAS filename of output

by Obsidian | Level 7 in SAS Programming
‎08-12-2020 10:45 AM
‎08-12-2020 10:45 AM
Hi,   I want to add to the filename the date of today. I tried the code below but it does'nt work. How can I use my variable pathname in the filename syntax?   data _NULL_; StringA = '/project/XXXXX/out/XX_EXPORT_'; StringM = %sysfunc(today(), YYMMYYN6.); StringE = '.csv'; %LET pathname = cats(StringA, StringM, StringE); put pathname; run; filename OUTPUT &pathname encoding='utf-8'; proc export data=XXXXXX.XX_NG outfile=OUTPUT dbms=csv; run; Thanks, Sascha ... View more

Store Date in Variable

by Obsidian | Level 7 in SAS Programming
‎08-11-2020 02:55 AM
‎08-11-2020 02:55 AM
Hello,   I need to store the date in a variable which I want use in other case later.   Below you will find my code. The output of variblae StartDate_OUT is "StartDate=."   If I try to write %LET StartDate_OUT = date(); I get an syntax error.   Where is my mistake?   data _NULL_; format StartDate mmddyy10.; StartDate = date(); %LET StartDate_OUT = StartDate=; run; data _NULL_; PUT &StartDate_OUT; run;  Thanks, Sascha ... View more

Re: Proc SQL Where Clause with Date

by Obsidian | Level 7 in SAS Programming
‎07-23-2020 02:36 AM
‎07-23-2020 02:36 AM
Yeah, you are right, Thanks. My fault. ... View more

Re: Proc SQL Where Clause with Date

by Obsidian | Level 7 in SAS Programming
‎07-23-2020 02:31 AM
‎07-23-2020 02:31 AM
I tried that, but I got this message: WARNING: This SAS global statement is not supported in PROC SQL. It has been ignored. ... View more

Re: Proc SQL Where Clause with Date

by Obsidian | Level 7 in SAS Programming
‎07-23-2020 02:17 AM
‎07-23-2020 02:17 AM
Ok, but what should I do now? The result is the same, I got the value 22118.   The structure of today should be 20200722 numeric, how can I convert the date to this format? ... View more

Re: Proc SQL Where Clause with Date

by Obsidian | Level 7 in SAS Programming
‎07-23-2020 01:59 AM
‎07-23-2020 01:59 AM
Thanks for your response.   But it doesn't work, because the value of INTNX('Day', TODAY(), -1, 'SAME') is 22118.   But I need the format YYYYMMDD like 20200722.   The values of salesday also have this format. ... View more

Proc SQL Where Clause with Date

by Obsidian | Level 7 in SAS Programming
‎07-22-2020 11:08 AM
‎07-22-2020 11:08 AM
Hi,   I tried to add to my where clause a calculated date like Today()-1, but I got always the error that the datatypes differs. The format from the salesday are YYYYMMDD and numeric.   PROC SQL; CREATE TABLE WORK.NG_Export AS SELECT T1.SAS_ID__c, T1.Salesday__c, FROM APPG.KOPIE_V_APP_NG T1 WHERE T1.Salesday__c = PUT(INTNX('Day', TODAY(), -1, 'SAME'), yymmddn8.); QUIT; Could you help me plase.   Thanks, Sascha ... View more

Create Index (ID) and increment

by Obsidian | Level 7 in SAS Programming
‎06-18-2020 06:25 AM
‎06-18-2020 06:25 AM
Hello,   I have a very simple table with sale information.   Name | Value | Index AAC | 1000 | 1 BTR | 500 | 2 GRS | 250 | 3 AAC | 100 | 4   I add a new column Name Index. And I run the first time the following code DATA BSP; Index = _N_; SET BSP; RUN; This works fine for the first time. But now I add more and more sales items and the new line should be get a new indexnumber. The highest index + 1 .... The old sales should keep the indexnumber. But if I run the code below all new lines get the index = 1. What is wrong with the code. proc sql noprint; select max(Index) into :max_ID from WORK.BSP; quit; DATA work.BSP; SET work.BSP; RETAIN new_Id &max_ID; IF Index = . THEN DO; new_ID + 1; index = new_id; END; RUN; Thanks, Sascha ... View more

Re: How can I increment my ID

by Obsidian | Level 7 in SAS Programming
‎05-18-2020 09:35 AM
‎05-18-2020 09:35 AM
Ok, I need the max ID instead of 10000. ... View more

Re: How can I increment my ID

by Obsidian | Level 7 in SAS Programming
‎05-18-2020 09:32 AM
‎05-18-2020 09:32 AM
Example: DATA BSP; LENGTH Name $20 Firstname $20; INPUT Name $ Firstname; DATALINES; Sample Bernd Sample Sabine Sample Georg Sample Heinz; RUN; DATA work.BSP_2; SET work.BSP; RETAIN _ID; IF Index ~= . THEN _ID = Index; ELSE DO; _ID+1; END; DROP ID; RENAME _ID = Index; RUN; So, now is correct with Index and ID. I need the highest Id/Index Number to increment +1 .... ... View more

How can I increment my ID

by Obsidian | Level 7 in SAS Programming
‎05-18-2020 09:08 AM
‎05-18-2020 09:08 AM
Hello,   I tried to add an Id to my table, it works if I start with 1, but how can I increment new line to this table. It is necessary to keep the old Ids.   DATA work.BSP_2; SET work.BSP; RETAIN _ID; IF Index ~= . THEN _ID = Index; ELSE DO; _ID+1; END; DROP ID; RENAME _ID = ID; RUN; Thanks, Sascha ... View more

Re: Code improvement SELECT often same source

by Obsidian | Level 7 in SAS Programming
‎10-10-2019 03:28 AM
‎10-10-2019 03:28 AM
Hi Patrick,   You are right, its just an update from another table.   SERVER.VIEW_TABLE has 10.000 lines / DUMMY 6.000 lines Both tables on the the same Server.    I tried the Code which you have posted, but I got the error below:   141 proc sql; 142 UPDATE GRV_Export_Dummy D 143 SET 144 D.Supervisor= v.Supervisor__c _ 73 76 ERROR 73-322: Expecting an =. ERROR 76-322: Syntax error, statement will be ignored. CODE: proc sql; UPDATE GRV_Export_Dummy D SET D.Supervisor= v.Supervisor__c from GRV_Export_Dummy D, SERVER.VIEW_TABLE V WHERE D.Contract= V.VTGONR ; quit; Regards, Sascha ... View more

Code improvement SELECT often same source

by Obsidian | Level 7 in SAS Programming
‎10-08-2019 07:30 AM
‎10-08-2019 07:30 AM
Hello,   my code below works fine so far, but it takes so much time. It is possible to write this code more comfortable to speed up? All lines have the same source.   UPDATE GRV_Export_Dummy D SET 'Supervisor'n = (SELECT 'Supervisor__c'n FROM SERVER.VIEW_TABLE V WHERE D.Contract = V.VTGONR), 'Account'n = (SELECT 'Account__c'n FROM SERVER.VIEW_TABLE V WHERE D.Contract = V.VTGONR), 'Street'n = (SELECT 'Street__c'n FROM SERVER.VIEW_TABLE V WHERE D.Contract = V.VTGONR), 'Country'n = (SELECT 'Country__c'n FROM SERVER.VIEW_TABLE V WHERE D.Contract = V.VTGONR), 'Postcode'n = (SELECT 'Postcode__c'n FROM SERVER.VIEW_TABLE V WHERE D.Contract = V.VTGONR), 'City'n = (SELECT 'City__c'n FROM SERVER.VIEW_TABLE V WHERE D.Contract = V.VTGONR), 'Contract_start'n = (SELECT 'Contract_start__c'n FROM SERVER.VIEW_TABLE V WHERE D.Contract = V.VTGONR), 'Contract_form'n = (SELECT 'Contract_form__c'n FROM SERVER.VIEW_TABLE V WHERE D.Contract = V.VTGONR), 'Contract_level'n = (SELECT 'Contract_level__c'n FROM SERVER.VIEW_TABLE V WHERE D.Contract = V.VTGONR) WHERE D.Contract IN (SELECT V.VTGONR FROM SERVER.VIEW_TABLE V WHERE D.Contract = V.VTGONR);   Thanks, Sascha   ... View more

Improve case satement and nested statements

by Obsidian | Level 7 in SAS Programming
‎09-23-2019 10:28 AM
‎09-23-2019 10:28 AM
Hello,   my code below works but how can I improve it? Is the case syntax the best choice? Or should I use the IF statement?   PROC SQL; UPDATE GRV_Export_Dummy D SET 'PAY'n = (CASE WHEN (SELECT 'EB'n FROM SERVER.VIEW_TABLE V WHERE D.GRV = V.VTGONR) = '1' THEN 'EB/' ELSE '' END) || (CASE WHEN (SELECT 'M01'n FROM SERVER.VIEW_TABLE V WHERE D.GRV = V.VTGONR) = '1' THEN 'M/' ELSE '' END) || (CASE WHEN (SELECT 'V01'n FROM SERVER.VIEW_TABLE V WHERE D.GRV = V.VTGONR) = '1' && (SELECT 'V02'n FROM SERVER.VIEW_TABLE V WHERE D.GRV = V.VTGONR) = '1' && (SELECT 'V03'n FROM SERVER.VIEW_TABLE V WHERE D.GRV = V.VTGONR) = '1' THEN 'V/' ELSE '' END) || (CASE WHEN (SELECT 'H01'n FROM SERVER.VIEW_TABLE V WHERE D.GRV = V.VTGONR) = '1' && (SELECT 'H02'n FROM SERVER.VIEW_TABLE V WHERE D.GRV = V.VTGONR) = '1' && (SELECT 'H03'n FROM SERVER.VIEW_TABLE V WHERE D.GRV = V.VTGONR) = '1' && (SELECT 'H04'n FROM SERVER.VIEW_TABLE V WHERE D.GRV = V.VTGONR) = '1' && (SELECT 'H05'n FROM SERVER.VIEW_TABLE V WHERE D.GRV = V.VTGONR) = '1' && (SELECT 'H06'n FROM SERVER.VIEW_TABLE V WHERE D.GRV = V.VTGONR) = '1' THEN 'H/' ELSE '' END) || (CASE WHEN (SELECT 'J01'n FROM SERVER.VIEW_TABLE V WHERE D.GRV = V.VTGONR) = '1' && (SELECT 'J02'n FROM SERVER.VIEW_TABLE V WHERE D.GRV = V.VTGONR) = '1' && (SELECT 'J03'n FROM SERVER.VIEW_TABLE V WHERE D.GRV = V.VTGONR) = '1' && (SELECT 'J04'n FROM SERVER.VIEW_TABLE V WHERE D.GRV = V.VTGONR) = '1' && (SELECT 'J05'n FROM SERVER.VIEW_TABLE V WHERE D.GRV = V.VTGONR) = '1' && (SELECT 'J06'n FROM SERVER.VIEW_TABLE V WHERE D.GRV = V.VTGONR) = '1' && (SELECT 'J07'n FROM SERVER.VIEW_TABLE V WHERE D.GRV = V.VTGONR) = '1' && (SELECT 'J08'n FROM SERVER.VIEW_TABLE V WHERE D.GRV = V.VTGONR) = '1' && (SELECT 'J09'n FROM SERVER.VIEW_TABLE V WHERE D.GRV = V.VTGONR) = '1' && (SELECT 'J10'n FROM SERVER.VIEW_TABLE V WHERE D.GRV = V.VTGONR) = '1' && (SELECT 'J11'n FROM SERVER.VIEW_TABLE V WHERE D.GRV = V.VTGONR) = '1' && (SELECT 'J12'n FROM SERVER.VIEW_TABLE V WHERE D.GRV = V.VTGONR) = '1' THEN 'J/' ELSE '' END) WHERE D.GRV IN (SELECT V.VTGONR FROM SERVER.VIEW_TABLE V WHERE D.GRV = V.VTGONR); QUIT;   Additional I don't know how can I use a "nested case"?  For example  IF V01 = 1 THEN V01 IF V02 = 1 THEN V02 IF V03 = 1 THEN V03 IF V01 & VO2 & VO3 = 1 THEN V   Thanks, Sascha ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎03-17-2022 09:17 AM
Quick links