About data_null__

data_null__ · ‎11-16-2020

Post your data as text please.

data_null__ · ‎11-13-2020

The B8601DA in-format will impute DTC. 18 data _null_; 19 do dtc="2017-07-07","2017","2007-11"; 20 date = input(dtc,b8601da.); 21 put (_all_)(=); 22 end; 23 format date date11.; 24 run; dtc=2017-07-07 date=07-JUL-2017 dtc=2017 date=01-JAN-2017 dtc=2007-11 date=01-NOV-2007

data_null__ · ‎10-28-2020

I didn't know I had to look it up.

data_null__ · ‎10-28-2020

@ballardw wrote: You might be able to use an NLMNLBRLw.d informat. data example; x='R$123,456.78'; y= input(x,NLMNLBRL32.); run; There is a corresponding form to display the values in the same form. I believe this is the better option because you don't have to fiddle with LOCALE.

data_null__ · ‎10-28-2020

@ballardw wrote: You might be able to use an NLMNLBRLw.d informat. data example; x='R$123,456.78'; y= input(x,NLMNLBRL32.); run; There is a corresponding form to display the values in the same form. I believe that @ballardw suggestion is best option because you don't have to change the LOCALE.

data_null__ · ‎10-28-2020

You need the LOCALE system option and an NLS informat. 554 data _null_; 555 x = 'R$100,50'; 556 y = input(x,NLMNY10.); 557 z = input(x,NLMNY10.2); 558 put (y z)(=NLMNY10.2); 559 put _all_; 560 run; y=R$100,50 z=R$100,50 x=R$100,50 y=100.5 z=100.5 _ERROR_=0 _N_=1

data_null__ · ‎10-26-2020

See the documentation for using SAS on z/OS. You want "non interactive mode"

data_null__ · ‎10-22-2020

Please provide better HAVE data in the form of a data step with cards data. data have; infile cards expandtabs; input FI&$64. a b; id + 1; label a='101 Capital Region R Uwgt' b='101 Capital Region R 000s'; cards; Health Products Use Vitamins tablets capsules 66 64 Health Products Use Anti smoking products 5 5 Anti smoking prdcts Freq Buy Every 2 to 3 months 0 0 Anti smoking prdcts Freq Buy Every 4 to 6 months 0 0 Weight Loss Remedies Freq Buy Every 2 to 3 months 3 5 Weight Loss Remedies Freq Buy Every 4 to 6 months 0 0 ;;;; proc print; run; proc transpose data=have out=want(drop=_name_) prefix=FI label=F1; var a b; id id; idlabel fi; run; proc contents varnum; proc print; run; proc print label; label f1=' '; run;

data_null__ · ‎10-21-2020

You need a different variable nested under across. I'm not sure why you're using ACROSS if all the variables under are NOPRINT. This fixed the context issue. proc report data=sashelp.cars /*list showall*/; columns Origin Make Type, (msrp) msrp=msrp0 msrp=msrpq1 msrp=msrpq3 stats; define Origin /" " group; define Make /" " group; define Type / " " across; define msrp / n noprint; *<===; define msrp0 / analysis median noprint; define msrpq1 / analysis q1 noprint; define msrpq3 / analysis q3 noprint; define stats / computed; compute stats / character length=50; stats = catt(put(msrp0, dollar7.1-l), " (", put(msrpq1, dollar7.1-l), "-", put(msrpq3, dollar7.1-l), ")"); endcomp; run;

data_null__ · ‎10-14-2020

I think you can use NRSTR for that but you need to escape the % sign in the expression %% 183 options symbolgen=1; 184 data c; 185 input cics $; 186 put _all_; 187 cards; cics=PthiTZ _ERROR_=0 _N_=1 cics=XthiT1 _ERROR_=0 _N_=2 cics=P--T1 _ERROR_=0 _N_=3 NOTE: The data set WORK.C has 3 observations and 1 variables. 191 ;;;; 192 193 %let a = %nrstr(cics like "P%%TZ" or cics like "P%%T1"); 194 195 data _null_; 196 set c; SYMBOLGEN: Macro variable A resolves to cics like "P%TZ" or cics like "P%T1" SYMBOLGEN: Some characters in the above value which were subject to macro quoting have been unquoted for printing. 197 where &a; 198 put _all_; 199 run; cics=PthiTZ _ERROR_=0 _N_=1 cics=P--T1 _ERROR_=0 _N_=2 NOTE: There were 2 observations read from the data set WORK.C. WHERE cics like 'P%TZ' or cics like 'P%T1';

data_null__ · ‎09-28-2020

Giving a variable (that does not exist) a label is not enough to create the variable. For example... 7 data test; 8 set sashelp.class; 9 label correcta='This is a label'; 10 run; NOTE: Variable correcta is uninitialized. NOTE: There were 19 observations read from the data set SASHELP.CLASS. NOTE: The data set WORK.TEST has 19 observations and 5 variables. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.01 seconds And the contents of TEST.

data_null__ · ‎08-21-2020

My variable names are on row 2. I would like to PROC COPY all sheets with range $A2:0 but I don't know if it is possible or if I just can't figure the syntax. 30 libname xl xlsx './zzzzzzzzzzz.xlsx' access=read; NOTE: Libref XL was successfully assigned as follows: Engine: XLSX Physical Name: (system-specific file/path name) 31 32 data test; 33 set xl.'ADJAE007$A2:0'n; 34 run; NOTE: The import data set has 122 observations and 13 variables. NOTE: The data set WORK.TEST has 122 observations and 13 variables. NOTE: DATA statement used (Total process time): real time 0.02 seconds cpu time 0.02 seconds 37 38 proc copy in=xl out=work; 39 select 'ADJAE007$A2:0'n; 40 run; ERROR: The file XL.ADJAE007$A2:0 (memtype=ALL) was not found, but appears on a SELECT statement. NOTE: Statements not processed because of errors noted above.

data_null__ · ‎08-16-2020

Did you look at the documentation? My answer on SO. https://stackoverflow.com/questions/63434128/contrast-statement-in-proc-surveyreg

data_null__ · ‎08-16-2020

Why not use a DEFINE statement? define mean / format=8.3;

data_null__ · ‎06-30-2020

ods pdf file='answers.pdf'; data have; file print; infile cards dsd dlm=' '; length fac_name $16; array ans $24 yes no always sometimes never; input (fac_name ans[*]) (:); put 'Facility name: ' fac_name; length Answered $16; do i = 1 to dim(ans); Answered = quote(vname(ans[i])); put answered= +(-1) ': ' ans[i]; end; put; datalines; "Facility A" "yes answers" "no answers" "always answers" "sometimes answers" "never answers" "Facility B" "yes answers" "no answers" "always answers" "sometimes answers" "never answers" ;;;; run; ods pdf close;

Online Status	Offline
Date Last Visited	11 hours ago