You probably just need GETNAMES=NO;   filename FT15F001 temp; parmcards; PB.PXDWXBX.SEDWVPAB.MP0|2918951|255186908| ;;;; proc import datafile=Ft15F001 out=test dbms=csv; getnames=no; delimiter='|'; run; proc print; run; ... View more

  @RichardAD wrote: Consider the requirement to convert numeric variables to same named character variables, and the character values must be the formatted numeric values, and the original column order must be maintained.  More generally, conversion is rendering process. Consider PROC TRANSPOSE.    data heart; _obs_ + 1; set sashelp.heart; run; proc contents varnum; run; options missing=' '; proc transpose prefix=_val data=heart out=flip(where=(_name_ ne '_obs_')); by _obs_; var _all_; run; data flip; set flip; _val1 = left(_val1); run; proc transpose data=flip out=flop(drop=_obs_ _name_); by _obs_; var _val1; id _name_; idlabel _label_; run; proc contents varnum; run; ... View more

Maybe this would work for you     reg query "HKCU\Control Panel\International" /v sShortDate HKEY_CURRENT_USER\Control Panel\International sShortDate REG_SZ M/d/yyyy   You can use INFILE statement option FILEVAR to execute multiple PIPEed commands.     ... View more

@linlin87 sorry I was not able to offer any further input.  Perhaps if you ask the question again some of the better programmers can help you figure this. ... View more

VNEXT sees the hash object.   9.04.01M8P011823 73 data _null_; 74 declare hash H; 75 H = _new_ hash(); 76 put _all_; 77 length _name_ $32 type $1; 78 do until(missing(_name_)); 79 call vnext(_name_,type,length); 80 put 'NOTE: ' (_all_)(=); 81 end; 82 run; _name_= type= length=. _ERROR_=0 _N_=1 NOTE: _name_=H type= length=0 NOTE: _name_=_name_ type=C length=32 NOTE: _name_=type type=C length=1 NOTE: _name_=length type=N length=8 NOTE: _name_=_ERROR_ type=N length=8 NOTE: _name_=_N_ type=N length=8 NOTE: _name_= type= length=0 NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds ... View more

@linlin87 wrote: To be a drop in RH above noise it need 3 datapoint below 30, and to be end of drop in RH it need 3 datapoint out of 30. Hope make sense now? Let me know if I understand correctly.   data rh; input datetime :datetime. loc $ RH RHDrop; format datetime datetime.; length DropFl 8; fl = rh le 30; if fl then seq + 1; else seq = .; if seq eq 3 then TempDropFl + 1; if not fl then DropFl = .; else if seq ge 3 then DropFL = TempDropFl; *drop fl seq Temp:; cards; 21NOV20:00:59 a 33 . 21NOV20:01:04 a 31 . 21NOV20:01:09 a 30 . 21NOV20:01:14 a 30 . 21NOV20:01:19 a 29 1 21NOV20:01:24 a 28 1 21NOV20:01:29 a 27 1 21NOV20:01:34 a 27 1 21NOV20:01:39 a 27 1 21NOV20:01:44 a 26 1 21NOV20:01:49 a 28 1 21NOV20:01:54 a 27 1 21NOV20:01:59 a 26 1 21NOV20:02:04 a 25 1 21NOV20:02:09 a 24 1 21NOV20:02:14 a 23 1 21NOV20:02:19 a 21 1 21NOV20:02:24 a 22 1 21NOV20:02:29 a 18 1 21NOV20:02:34 a 20 1 21NOV20:02:39 a 27 1 21NOV20:02:44 a 29 1 21NOV20:02:49 a 32 . 21NOV20:02:54 a 31 . 21NOV20:02:59 a 32 . 21NOV20:03:04 a 29 . 21NOV20:03:09 a 29 . 21NOV20:03:14 a 29 2 21NOV20:03:19 a 28 2 21NOV20:03:24 a 28 2 21NOV20:03:29 a 29 2 21NOV20:03:34 a 28 2 ;;;; run; proc print; run; ... View more

@linlin87 wrote: Thank you making SAS data. It is less than or equal 30%. You need to address @PaigeMiller question.  How can row 5 show (RH Drop Number) = 1 since there have not been "3 consecutive datapoint in humidity below a threshold (30%)" ??? You are not giving enough information for me to understand the problem. ... View more

@PaigeMiller wrote: Please provide data as working SAS data step code (examples and instructions)   How can row 5 show (RH Drop Number) = 1 since there have not been "3 consecutive datapoint in humidity below a threshold (30%)" ??? data rh; input datetime :datetime. loc $ RH RHDrop; cards; 21NOV20:00:59 a 33 . 21NOV20:01:04 a 31 . 21NOV20:01:09 a 30 . 21NOV20:01:14 a 30 . 21NOV20:01:19 a 29 1 21NOV20:01:24 a 28 1 21NOV20:01:29 a 27 1 21NOV20:01:34 a 27 1 21NOV20:01:39 a 27 1 21NOV20:01:44 a 26 1 21NOV20:01:49 a 28 1 21NOV20:01:54 a 27 1 21NOV20:01:59 a 26 1 21NOV20:02:04 a 25 1 21NOV20:02:09 a 24 1 21NOV20:02:14 a 23 1 21NOV20:02:19 a 21 1 21NOV20:02:24 a 22 1 21NOV20:02:29 a 18 1 21NOV20:02:34 a 20 1 21NOV20:02:39 a 27 1 21NOV20:02:44 a 29 1 21NOV20:02:49 a 32 . 21NOV20:02:54 a 31 . 21NOV20:02:59 a 32 . 21NOV20:03:04 a 29 . 21NOV20:03:09 a 29 . 21NOV20:03:14 a 29 2 21NOV20:03:19 a 28 2 21NOV20:03:24 a 28 2 21NOV20:03:29 a 29 2 21NOV20:03:34 a 28 2 ;;;; run; proc print; run; ... View more

url='https://geocoding.geo.census.gov/geocoder/geographies/address?street=1600+Pennsylvania+Ave+NW&city=W...' Try it with single quotes. ... View more

I see no difference other than variable LABEL.  Based on the PROC COMPARE output. ... View more

I don't know this scenario is relevant.  If a variable has a format with width less than vlength it could cause what you are seeing.   65 data test; 66 length a $20; 67 format a $16.; 68 a = '123456789012345678901234567890'; 69 l = vlength(a); 70 f = vformatw(a); 71 put 'NOTE: ' (_all_)(=); 72 put 'NOTE: ' a=$20. a=; 73 put _all_; 74 run; NOTE: a=1234567890123456 l=20 f=16 NOTE: a=12345678901234567890 a=1234567890123456 a=1234567890123456 l=20 f=16 _ERROR_=0 _N_=1 ... View more

@SASdevAnneMarie you could add a parameter to @Stu_SAS macro XMACRO to execute a macro within the %DO;   %macro split_data(data=, splits=, xmacro=xmacro); %let dsid = %sysfunc(open(&data)); %let n = %sysfunc(attrn(&dsid, nlobs)); %let rc = %sysfunc(close(&dsid)); %put Total obs: &n; %put -------------------------------; %do s = 1 %to &splits; %let firstobs = %sysevalf(&n-(&n/&splits)*(&splits-&s+1)+1, floor); %let obs = %sysevalf(&n-(&n/&splits)*(&splits-&s), floor); %&xmacro; %put split: &s; %put firstobs: &firstobs; %put obs: &obs; %put total: %eval(&obs-&firstobs+1); %put -------------------------------; %end; %mend; %macro xmacro; data cars_split&s(label="&data &firstobs:&obs"); set &data(firstobs=&firstobs obs=&obs); run; %mend xmacro; %split_data(data=sashelp.cars, splits=3);   ... View more

call symputx("%nrquote(&name.)", dsname,'G'); CALL SYMPUTX(macro-variable,value<,symbol-table>);  Use the SYMPUTX third parameter to define the symbol-table for the variable being created.  'G' for global.   ... View more

PROC TRANSREG and also be useful here.   /*0=Black, 1=White,2=American Indian,3=Asian,4=Native Hawaiian). */ data race; do race = 0,.,1 to 4; output; end; run; proc transreg data=race; model class(race/zero='1'); id race; output out=design(drop=intercept) design; run;   Or perhaps this one. /*0=Black, 1=White,2=American Indian,3=Asian,4=Native Hawaiian). */ data race; do race = 0,.,1 to 4; output; end; run; proc transreg data=race; model class(race/dev zero='1'); id race; output out=design(drop=intercept) design; run; ... View more