About Son_Of_Krypton

Son_Of_Krypton · ‎06-15-2020

data _null_; if 0 then set test2 nobs=NOBS; if NOBS>1 then do; put "Hello"; put "We have a problem"; put "Error: Records not matching" NOBS ; abort abend; end; stop; run; i want to check for invalid date along with above conditions

Son_Of_Krypton · ‎06-15-2020

Date 120/04/2020 as above example i have wrong date in my dataset and i want code to be fail with invalid date error and mail should be sent as wrong date identified.

Son_Of_Krypton · ‎06-11-2020

I am getting below error: filename EMAIL email; data _null_; 3834 if 0 then set TEST nobs=NOBS; 3835 if NOBS>1 then do; 3836 file MAIL to = 'user@company.com' ^ ERROR: Option "to" is not known for FILE 3837 subject = 'Error Mail message'; 3838 put "Hello"; 3839 put "We have a problem"; 3840 put "Error: Records not matching" ; 3841 end; 3842 stop; 3843 run;

Son_Of_Krypton · ‎06-11-2020

program also need to be aborted

Son_Of_Krypton · ‎06-11-2020

scenario is like if table has more than one record then it should fail and mail should be sent.as i mentioned ignore nobs then

Son_Of_Krypton · ‎06-11-2020

i want to send a mail as soon as it gets error on condition below data _null_; if nobs>0 then do; put 'ERROR: No of observations that need to be corrected are ' nobs ; abort abend; end; stop; set test; run; Mail should be sent out as nobs "need to be corrected based on test.xlsx file". Can anyone help me with this

Son_Of_Krypton · ‎10-04-2018

it was a typing mistake there is no "C" and "6" in data

Son_Of_Krypton · ‎10-04-2018

i have a data as follows Variable X Obs. 12345 Now I want output like as follows Variable X Y Z A B C Obs. 1 2 3 4 5 6 How we can do this

Son_Of_Krypton · ‎09-21-2018

Thanks for the solution '_'

Son_Of_Krypton · ‎09-21-2018

suppose i have a column named number and it has a value like 6458903 and i want this value in target table as 6500000 and its length is not fixed how we can do this.??

Son_Of_Krypton · ‎08-21-2018

asume this question as scenario not as a practical work

Son_Of_Krypton · ‎08-21-2018

looking for solution if you have any solution in your mind please share

Son_Of_Krypton · ‎08-21-2018

okay but i don't want to print it i want to create a dataset for each city by its name

Son_Of_Krypton · ‎08-21-2018

i have a below table Data Have; Input id name $ city $; cards; 100 Thomas Paris 101 Chris London 102 Martin US 103 John Hongkong ; run; for above table i want each city's own table including its records like a different table named paris which includes only paris data

Son_Of_Krypton · ‎08-20-2018

hi i have below programm data Address; input Address $30.; cards; Huston 4350 4390 Queens 7890 1245 ; run; Need Output like as follows No Address New_Address 1 Huston 4350 PO BOX Huston 4350 2 4390 PO BOX 4390 3 Queens 7890 PO BOX Queens 7890 4 1245 PO BOX 1245

Online Status	Offline
Date Last Visited	‎06-11-2024 12:16 PM

NOTE : Invalid Argument to function Input

Special Character Issue Form SAS to Oracle Using Bulkload

Re: Seperate Values From Observation

Seperate Values From Observation

Re: SAS Programing Sending Email Using macro

Re: SAS Programing Sending Email Using macro

Re: SAS Programing Sending Email Using macro

SAS Programing Sending Email Using macro

SAS Dataset Size Showing 10 times bigger in oracle

Trending Report

Re: SAS Scenario

NOTE : Invalid Argument to function Input

Re: Dates

Dates

Re: Send EMail as soon as job fails

Re: Send EMail as soon as job fails

Re: Send EMail as soon as job fails

Send EMail as soon as job fails

Re: Subsetting data

Subsetting data

Re: Rounding value up to nearest value

Rounding value up to nearest value

Re: SAS Scenario

Re: SAS Scenario

Re: SAS Scenario

SAS Scenario

Base SAS Scenario