About data_null__

data_null__ · ‎06-23-2021

I'm guessing the BY variable VALUES in A and B are different even though they may LOOK the same. Perhaps leading spaces if character. Also I usually put the sub-setting IF after the BY but I don't' think that is the problem.

data_null__ · ‎06-23-2021

@xiaopingnie wrote: Hi, I just met a problem when using proc freq crosstab. for example PROC SQL; create table CARS1 as SELECT make, type, invoice, horsepower, length, weight FROM SASHELP.CARS WHERE make in ('Audi','BMW') ; RUN; proc FREQ data = CARS1; tables make*type; run; without any suppression, I only got two rows in each cells instead of 4 rows. also there's a warning "WARNING: Format pctfmt. failed to load!" in the log window. But this warning did not show up when I ran one way proc freq. Any one know what's going on here? SUV Sedan Sports Wagon Total Audi 0 13 4 2 19 0 68.42 21.05 10.53 BMW 2 13 4 1 20 10 65 20 5 Total 2 26 8 3 39 I just ran your code and got this. Tell more of the story.

data_null__ · ‎06-10-2021

You're welcome Obsidian. @Dee2 wrote: Thanks Jade. 2. What is the variable name for day1 - day&post_days.? what does it do here? This is a "SAS Variable List" if POST_DAYS is 7 then DAY1-DAY7 Day1 minus Day7? For a "SAS Variable List" the - (minus sign) indicates a list of enumerated variables DAY1 DAY2 DAY3 ... DAY7 a. (d_member_id ne .) means d_member_id not = blank? The d_member_id shouldn't have blank. Filter the output data. Without MISSING options there should be not missing class levels. Filter d_member_id not = blank? (ne .)? also NOT missing(d_member_id) Thanks.

data_null__ · ‎06-10-2021

@Q1983 wrote: %let mydate = %sysfunc(putn(%sysfunc(intnx(day, %sysfunc(today()), -1, end)), yymmddd8.)); %put &mydate;/*SYMBOLGEN: Macro variable MYDATE resolves to 21-06-09*/ However I want this output 2020-06-09 or what ever the date is I tried yyymmdd10 with no result You should use the SYSFUNC format parameter. No need for %SYSFUNC(PUTN 55 %let mydate = %sysfunc(intnx(day,%sysfunc(today()),-1,end),yymmddd10); 56 %put &mydate Using SYSFUNC format parameter; 2021-06-09 Using SYSFUNC format parameter

data_null__ · ‎06-10-2021

@Dee2 wrote: I have few questions for the code below and would like to get some help. My understanding is it did some thing on &dsnn._2 and output to &dsnn._3 but I don't understand 1. The d_member_id, date1, and indexdt are columns. What does class do and get here? Class defines the groups for the summary. 2. What is the variable name for day1 - day&post_days.? what does it do here? This is a "SAS Variable List" if POST_DAYS is 7 then DAY1-DAY7. 3. This code "(where=(d_member_id ne .) drop=_:) max=;" a. (d_member_id ne .) means d_member_id not = blank? The d_member_id shouldn't have blank. Filter the output data. Without MISSING options there should be not missing class levels. b. drop what? Another "SAS Variable List" drop variables that begin with "_" (i.e. _TYPE_ _FREQ_) c. max what? if max a column, what is the group by? MAX of all variables in VAR statement and name the MAX same as VAR proc means data=&dsnn._2 noprint nway; class d_member_id date1 indexdt; var day1 - day&post_days.; output out=&dsnn._3(where=(d_member_id ne .) drop=_:) max=; Thanks.

data_null__ · ‎04-01-2021

I would like to test if a format can be preloaded. Is there an easy way to test: "is a SAS format, calls a function, or contains a nested format in its definition." 520 proc summary data=sashelp.class completetypes; 521 class sex / preloadfmt; 522 format sex $upcase.; 523 output; 524 run; NOTE: Multiple concurrent threads will be used to summarize data. WARNING: The format for variable Sex cannot be preloaded. A finite set of formatted values cannot be produced from the format. The format is not recognized, is a SAS format, calls a function, or contains a nested format in its definition. Preload will have no effect. NOTE: There were 19 observations read from the data set SASHELP.CLASS. NOTE: The data set WORK.DATA1 has 3 observations and 3 variables.

data_null__ · ‎03-08-2021

Open the RTF file in a text editor and see if you can find what RTF markup SAS is "writing". Might help figure how it works.

data_null__ · ‎03-06-2021

What does this do? I don't see where it was called. %macro _; %mend _; @qoit wrote: Hope the below helps: data have; infile datalines pad; input id $ abrv $ A B C D; datalines; 35 AE 284 5143.03 234 4692.75 35 AI 136 1450.67 110 1031.6 43 AE 207 4389.86 93 1890.86 43 AI 130 1419.78 36 559.68 ; run; %macro want; %macro _; %mend _; %local vars i; %let vars = a b c d; data want_ae; set have (where=(abrv = 'AE')); array ae{4} ae_a ae_b ae_c ae_d; %do i = 1 %to 4; ae{&i.} = %qscan(&vars.,&i.,%str( )); %end; drop a b c d abrv; run; data want_ai; set have (where=(abrv = 'AI')); array ai{4} ai_a ai_b ai_c ai_d; %do i = 1 %to 4; ai{&i.} = %qscan(&vars.,&i.,%str( )); %end; drop a b c d abrv; run; data want; merge want_ae want_ai; by id; run; proc sql; drop table want_ae; drop table want_ai; %mend; %want

data_null__ · ‎03-05-2021

You can do it with RENAME dataset option. You can also used RETAIN before SET. data class; retain AGE; set sashelp.class(rename=(name=NaMe height=HeiGHT)); run; proc contents varnum; run;

data_null__ · ‎03-04-2021

Would it be sufficient to search the string for the word PIPE findw(upcase(source), 'PIPE') after you find FILENAME.statement. Also note that you can also have an INFILE statement with the PIPE option that does not use a FILENAME data _null_; command = '/usr/bin/find ....'; INFILE DUMMY PIPE filevar=command end=eof; do while(not eof); input; end; stop;

data_null__ · ‎03-02-2021

Maybe something like this using CLASS statement option MLF so numeric class variables are converted to character. %let vars=sex age; proc summary data=sashelp.class missing descendtypes chartype;; class sex age / mlf; /*MLF converts numeric class to character*/ ways 1; output out=UNI; run; proc print; run; data uni; set uni; array _cls[*] &vars; i = index(_type_,'1'); vname = vname(_cls[i]); length value $64; /*or more*/ value = _cls[i]; drop &vars; run; proc print; run;

data_null__ · ‎03-02-2021

proc summary data=sashelp.class missing; class sex age; ways 1; output out=UNI; run; proc print; run;

data_null__ · ‎03-02-2021

It is important to note that the expression index(upcase(Source_Code), 'X "') is not adequate to identify all X command syntax Consider. x "cmd"; x 'cmd'; x %sysfunc(quote(&cmd)); To name just three

data_null__ · ‎03-02-2021

You don't need %STR data test; input source_code $char80.; *set work.parsed_code; if _N_=1 then do; RETAIN x_cmd_patternID; x_cmd_pattern = "/x[[:blank:]]/"; x_cmd_patternID=prxparse(x_cmd_pattern); end; reg_ex_flag_x_cmd= prxmatch(x_cmd_patternID,Source_Code); flag_x_cmd = index(upcase(Source_Code), 'X "') gt 0; cards4; data _NULL_; set sashelp.class; x "rm /this/is/a/path/to/a/file.txt" ; x "rm /this/is/another/path/to/a/file2.txt"; run; ;;;; run; proc print; run;

data_null__ · ‎03-02-2021

Your data is a picture. Make it TEXT. data test; input id y; cards; 1 1 1 1 1 2 1 1 1 1 1 1 1 3 1 1 2 1 2 2 2 1 2 1 2 1 2 3 2 1 ;;;; proc summary data=test nway missing; by id y notsorted; output out=test2(where=(y eq 1)) sum(y)=sumY; run; proc print; run;

Online Status	Offline
Date Last Visited	5 hours ago