About PROCDATARUN

PROCDATARUN · ‎10-26-2023

Hello SAS Community, Running into the following result when attempting to convert character UTC Date to Datefield. Input data ActivationUTC = 08-FEB-23 10.54.32 PM UTC (INPUT(t2.ActivationUTC , datetime20.)) FORMAT=DESDFDT7. AS ActivationDate Output data = 18Jul19 Expected data = 08Feb23 Can you correct my code ?

PROCDATARUN · ‎01-19-2022

data TARGET.TABLEA; set MYLIB.TABLEA; run; How do I add ON_ERROR step to the above data step to overcome the below error, data is allowed and not skipped. ERROR: Error executing COPY command: Numeric value '-specific scope position:' is not recognized File '@~/user/SASSNBL_XYWYYVYVYMMM.dat', line 151, character 1 Row 151, column "TABLEA"["on_error":1] If you would like to continue loading when an error is encountered, use other values such as 'SKIP_FILE' or 'CONTINUE' for the ON_ERROR option. For more information on loading options, please run 'info loading_data' in a SQL client.

PROCDATARUN · ‎12-05-2021

Hello Geeks, I am using the following code to export, what code modification would zip the file on exporting ? data _null_; set WORK.Output ; file '/sasd/cs/sasd/John/WORK.Output.csv' dsd ; if _n_ = 1 then do; put "This is a header row"; end; put (_all_) (+0); run;

PROCDATARUN · ‎12-01-2021

How do I add the header row to the following export code. data _null_; set WORK.Output ; file '/sasd/cs/sasd/John/WORK.Output.csv' dsd ; put (_all_) (+0); run;

PROCDATARUN · ‎12-01-2021

PROCDATARUN · ‎11-30-2021

Thanks @Kurt_Bremser Am trying to export a large dataset to CSV which fails due to size when export step is used on EG query builder. 2 mill rows and 100 columns. Export step on query builder does allow exporting to desktop. How would you overcome this issue ? Exporting to a unix location and then downloading adds more time.

PROCDATARUN · ‎11-30-2021

data _null_; set Work.Sample ; file 'C:\Users\John\Desktop\Sample.csv' dsd ; put (_all_) (+0); run; ERROR: Insufficient authorization to access /sas/config/compute/SASApp/C:\Users\John\Desktop\Sample.csv. Why would export default to server, what am I missing here to set the export to desktop ?

PROCDATARUN · ‎11-04-2020

Thanks Novin, Could you help with the full code here ? Proc or Data ?

PROCDATARUN · ‎11-04-2020

Hello Programmers, I have a simple ask to concatenate 5 columns with a comma separator with a condition. Dataset = INPUTA Columns = C1 through C5 Expected Outcome Need a column that would concatenate all 5 columns with comma separator in sequence when there is a value and ignore if the column is blank. State C1 C2 C3 C4 C5 CustomColumn CA X A X,A WI X R B X,R,B MI Y T X I Y,T,X,I

PROCDATARUN · ‎09-03-2020

I have a WORK.STATS output on SAS that will be written to a table (MYSQL.STATSINPUT) in SQL server. Table is already created in SQL server, data will be dropped using delete statement. How to write WORK.STATS to MYSQL.STATSINPUT - all of the data.

PROCDATARUN · ‎09-03-2020

After deleting data in a table, what is the syntax to write all data to a table with no filtering ?

PROCDATARUN · ‎06-19-2020

How do I declare the fields correctly so the output dataset is generated as expected. **************** data INPUT; input Order: $4. Set: $4. Track: $7. SubGroup: $1.; datalines; O123 J001 456Y A O123 J001 456Y B O123 J001 456Y C O123 J001 3284G A O123 J001 3284G B O123 J001 5657G A ; Actual Order Set Track Subgroup O123 O123 O123JO O Expected Order Set Track Subgroup O123 J001 456Y A O123 J001 456Y B O123 J001 456Y C O123 J001 3284G A O123 J001 3284G B O123 J001 5657G A

PROCDATARUN · ‎06-18-2020

Thanks a ton to @RichardDeVen for helping with the set up of code. Am running into the following error for the below code, any help is appreciated. More Background Here Statement is not valid or it is used out of proper order. **CODEBELOW******* data have; input Order: $4. Set: $4. Track: $7. SubGroup: $1.; datalines; O123 J001 456Y A O123 J001 456Y B O123 J001 456Y C O123 J001 3284G A O123 J001 3284G B O123 J001 5657G A O123 J001 490456B B O123 J001 490456C C O123 J001 490456D A O123 J001 490E B O123 J001 490F A O123 J001 490G B O123 J001 490H C O123 J001 490I A O123 J001 490J B O123 J002 456Y A O123 J002 456Y B O123 J002 456Y C O123 J002 3284G A O123 J002 3284G B O123 J002 5657G A O123 J002 490456B B O123 J002 490456C C O123 J002 490456D A O123 J002 490E B O123 J002 490F A O123 J002 490G B O123 J002 490H C O123 J002 490I A O123 J002 490J B O346 J001 456Y A O346 J001 456Y B O346 J001 456Y C O346 J001 3284G A O346 J001 3284G B ; data want; set have; by order set; attrib Page format=4. ; if _n_ = 1 then do; FromSet = Set; declare hash tracks(); tracks.defineKey('Track'); tracks.defineData('Page'); tracks.defineData('FromSet'); tracks.defineDone(); end; if first.order then tracks.Clear(); if first.set then seq_TrackInSet = 0; if tracks.find() ne 0 then do; /* new track in set */ seq_TrackInSet + 1; if seq_TrackInSet <= 10 then do; Page = seq_TrackInSet; FromSet = Set; tracks.add(); end; end; * for edification, flag the wanted row; if tracks.num_items <= 100 and 1 <= seq_TrackInSet <= 10 and Set=FromSet then want_row = '*'; if want_row = '*'; *subsetting if; drop want_row seq_TrackInSet;

PROCDATARUN · ‎06-16-2020

On SAS EG 7.1 GOPTIONS ACCESSIBLE; 26 data have; 27 input 28 Order: $4. Set: $4. Track: $7. SubGroup: $1.; 29 datalines; NOTE: LOST CARD. RULE: ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0 65 ; Order=O346 Set=O346 Track=O346 J0 SubGroup= _ERROR_=1 _N_=9 NOTE: SAS went to a new line when INPUT statement reached past the end of a line. NOTE: The data set WORK.HAVE has 8 observations and 4 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.01 seconds 65 ; 66 data want; 67 set have; 68 by order set; 69 70 attrib 71 Page format=4. 72 ; 73 74 if _n_ = 1 then do; 75 FromSet = Set; 76 declare hash tracks(); 77 tracks.defineKey('Track'); 78 tracks.defineData('Page'); 79 tracks.defineData('FromSet'); 2 The SAS System Monday, June 15, 2020 11:18:00 PM 80 tracks.defineDone(); 81 end; 82 83 if first.order then 84 tracks.Clear(); 85 86 if first.set then 87 seq_TrackInSet = 0; 88 89 if tracks.find() ne 0 then do; /* new track in set */ 90 seq_TrackInSet + 1; 91 if seq_TrackInSet <= 10 then do; 92 Page = seq_TrackInSet; 93 FromSet = Set; 94 tracks.add(); 95 end; 96 end; 97 98 * for edification, flag the wanted row; 99 if tracks.num_items <= 100 and 1 <= seq_TrackInSet <= 10 and Set=FromSet then want_row = '*'; 100 101 if want_row = '*'; *subsetting if; 102 103 drop want_row seq_TrackInSet; 104 105 GOPTIONS NOACCESSIBLE; 106 %LET _CLIENTTASKLABEL=; 107 %LET _CLIENTPROCESSFLOWNAME=; 108 %LET _CLIENTPROJECTPATH=; 109 %LET _CLIENTPROJECTPATHHOST=; 110 %LET _CLIENTPROJECTNAME=; 111 %LET _SASPROGRAMFILE=; 112 %LET _SASPROGRAMFILEHOST=; 113 114 ;*';*";*/;quit;run; ____ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. NOTE: The SAS System stopped processing this step because of errors. WARNING: The data set WORK.WANT may be incomplete. When this step was stopped there were 0 observations and 6 variables. WARNING: Data set WORK.WANT was not replaced because this step was stopped. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds 115 ODS _ALL_ CLOSE; 116 117 118 QUIT; RUN; 119

PROCDATARUN · ‎06-14-2020

Thanks Richard for your continued support. Running into the below error, could you help get to the finish line here. ERROR 180-322: Statement is not valid or it is used out of proper order. data have; input Order: $4. Set: $4. Track: $7. SubGroup: $1.; datalines; O123 J001 456Y A O123 J001 456Y B O123 J001 456Y C O123 J001 3284G A O123 J001 3284G B O123 J001 5657G A O123 J001 490456B B O123 J001 490456C C O123 J001 490456D A O123 J001 490E B O123 J001 490F A O123 J001 490G B O123 J001 490H C O123 J001 490I A O123 J001 490J B O123 J002 456Y A O123 J002 456Y B O123 J002 456Y C O123 J002 3284G A O123 J002 3284G B O123 J002 5657G A O123 J002 490456B B O123 J002 490456C C O123 J002 490456D A O123 J002 490E B O123 J002 490F A O123 J002 490G B O123 J002 490H C O123 J002 490I A O123 J002 490J B O346 J001 456Y A O346 J001 456Y B O346 J001 456Y C O346 J001 3284G A O346 J001 3284G B ; data want; set have; by order set; attrib Page format=4. ; if _n_ = 1 then do; FromSet = Set; declare hash tracks(); tracks.defineKey('Track'); tracks.defineData('Page'); tracks.defineData('FromSet'); tracks.defineDone(); end; if first.order then tracks.Clear(); if first.set then seq_TrackInSet = 0; if tracks.find() ne 0 then do; /* new track in set */ seq_TrackInSet + 1; if seq_TrackInSet <= 10 then do; Page = seq_TrackInSet; FromSet = Set; tracks.add(); end; end; * for edification, flag the wanted row; if tracks.num_items <= 100 and 1 <= seq_TrackInSet <= 10 and Set=FromSet then want_row = '*'; if want_row = '*'; *subsetting if; drop want_row seq_TrackInSet;

Online Status	Offline
Date Last Visited	‎10-26-2023 05:29 AM

Convert UTC timestamp string to date

on_error on data step

Zip command to export

Re: Add header to export

Add header to export

Re: Proc Export defaulting to server

Proc Export defaulting to server

Re: Data step for repeat

Data step for repeat

Re: Write to Table

Re: Zip command to export

Re: Add header to export

Re: Add header to export

Re: Add header to export

Re: Basic Data Field Set up Question

Convert UTC timestamp string to date

on_error on data step

Zip command to export

Re: Add header to export

Add header to export

Re: Proc Export defaulting to server

Proc Export defaulting to server

Re: Data step for repeat

Data step for repeat

Re: Write to Table

Write to Table

Basic Data Field Set up Question

Statement is not valid or it is used out of proper order

Re: Page Number counter and reset

Re: Page Number counter and reset