About Haikuo

Haikuo · ‎06-14-2016

Nope. The max length of a macro variable is 65534 chars. Very often when you encounter something like this (system limit), there are better alternatives, some even without involving macro variables. Please explain your whole picture.

Haikuo · ‎06-14-2016

I will start with reading this. Good Luck, Haikuo

Haikuo · ‎06-14-2016

If you can settel with crude distance, there is another function ZIPCITYDISTANCE(); if you want it more precise, then: Step 1. : Geocoding. Proc geocode. search it. there are many papers on this topic, and you will want street level geocoding. Step 2: apply GEODIST on the coordinates you obtained from Step1. Haikuo

Haikuo · ‎06-14-2016

Echo with @RW9. You don't want to mess around those SAS factory folders. If you absoultely 'have to' to do it, depending on your SAS deployment and your access permission, try following at your own risk: 1. Locate your SAS config file, for local deployment, you may find it some where like: C:\Program Files\SASHome2\x86\SASFoundation\9.4\nls\en\sasv9.cfg 2. Open it with a text editor (e.g. notepad), find the following line (it could be completely different depending on your deployment) -SASUSER "?FOLDERID_Documents\My SAS Files\9.4" 3. Modify it to (not in literal): -SASUSER "your myfiles path" 4. Save it and restart your SAS. Haikuo Oh, forgot mention: you need to save an orignal copy somewhere before you modify it, just in case.

Haikuo · ‎06-02-2016

CALL EXECUTE or DOSUBL if you have SAS 9.4

Haikuo · ‎06-02-2016

FDELETE

Haikuo · ‎05-23-2016

If your 'sequence' always starts from '1', here is a SQL option: data have; input account sequence; datalines; 1 1 1 2 1 3 2 2 2 3 3 1 3 2 ; proc sql; create table want as select account, (count(distinct sequence)=max(sequence)) as flag from have group by account ; quit;

Haikuo · ‎05-14-2016

You sound like you came from SQL world. Yes, indeed, most of the data step functions work on ONE obs at a time, some times some functions may appear not, however, they still DO. This is due the foundamental data processing structure in data step, aka, PDV (program data vector).

Haikuo · ‎05-13-2016

Please show some data. That is usually the best way to illustrate your problem.

Haikuo · ‎05-13-2016

Age always equal to pctl(75,age) or pctl(25,age). What do you want to achieve? There should be more than one elements in the place of 'age' if you are looking at 'percentile', otherwise, it always returns the 'age'. Please refer to SAS docs for details.

Haikuo · ‎05-13-2016

Try this: proc sql inobs=10; create table mytable_temp as select * from mylibrary.mytable; quit;

Haikuo · ‎05-12-2016

I have never tried to code STP(Stored Process) from scratch, so I can't really comment on your code part. From my base programmer background, it is easier to write the code part in EG program editor first, then convert it into STP. The following is my test code on ODS Excel, after converting to STP, it works (honestly I never thought it woundn't) FILENAME OT "/share/test/test_%SYSFUNC(TODAY(),DATE9.).XLSX"; ODS EXCEL FILE = OT ; PROC PRINT DATA=SASHELP.CLASS; RUN; ODS GRAPHICS OFF; ODS EXCEL CLOSE; I tried to run the above STP from numerous Apps (STP web app, Web report studio, information delivery portal, EG etc), it all seems normal to me.

Haikuo · ‎05-06-2016

Your code runs fine in my systems (SAS 9.4 on Linux 64 /Windows 7). filename FT15F001 temp; data Input ; %let _EFIERR_ = 0; /* set the ERROR detection macro variable */ infile FT15F001 delimiter = '|' MISSOVER DSD lrecl=32767 firstobs=2 ; informat Age best32. ; informat Name $30. ; informat Town $20. ; format Age best32. ; format Name $30. ; format Town $20. ; input Age Name $ Town $ ; if _ERROR_ then call symputx('_EFIERR_',1); /* set ERROR detection macro variable */ parmcards; Age|Name|Town 20|Kuda ZZZ|Harare 25|Fraser Bernhard |New York 30|Matthew Benhard|London ;;;; run; It must be something else.

Haikuo · ‎05-06-2016

I am not aware that EG has one. EG inherited those shortcut keys from Base SAS program editor, and they are only valid in EG program editor.

Haikuo · ‎05-05-2016

Proc sql maybe not necessary if 1X data step can get the macro variable: data have; input P1 $ P2 $ P3 $; datalines; AP AP AP 30 25 80 50 30 120 NO 50 NO NO 20 NO ; data _null_; set have end=done; array p(*) P1-P3; array _name(3) $2 _temporary_ ; do i=1 to dim(p); if p(i)='NO' then _name(i)=vname(p(i)); end; if done then call symputx ('del',catx(' ', of _name(*))); run; data final; set have(drop=&del); run;

Online Status	Offline
Date Last Visited	‎02-27-2023 12:47 PM

Re: How to convert GPS Coordinates with degree into longitudes and lat...

Re: Multiple Observations from Single Record

Re: Filling in missing sequence number and linearly interpolating betw...

Re: repeat observation by id

Re: repeat observation by id

Re: Output from Proc Datasets as a data file

Re: Warning in log - why?

Re: complicated conversion

Re: assign unscheduled visits

Re: Use a multi-selection macro variables from a prompt in pass throug...

Re: PROC JSON - create a hierarchical file

Re: Copy values based on certain criteria

Re: Importing a file with multiple delimiters per record

How to handle line breaks in csv files

Re: Importing a .CSV file from R with NA's as missing

Re: capitalize first letter of first word

Re: Copy dataset structure

Re: how to check if user is running any session and using SAS metadata...

Re: Remove leading and trailing zeros from character field

Re: how to get valid data

Re: How big a SAS macro variable can take?

Re: How to create turn column data into a hyperlink?

Re: Calculate distance between locations in SAS EG?

Re: Assigning folder containing data sets in SASUSER

Re: To create a macro call routine

Re: Using SAS code to delete .csv files in a folder

Re: Flag a record where sequence is broken

Re: Using the PCTL function in a DATA step?

Re: Using the PCTL function in a DATA step?

Re: Using the PCTL function in a DATA step?

Re: Selecting Top ten rows

Re: ODS EXCEL in Web StoreProcess

Re: Reading a | delimited file but have issues when SAS encounters fie...

Re: Recently Viewed Items Menu - Keyboard Shortcut?

Re: How Do I Delete column(variable) conditinally

SAS Analytics Explorers