A simple DO loop will do:
data have;
infile datalines dsd dlm="09"x truncover;
input ID $ Visit $ AE_free_text $;
datalines;
1 1 1,4
2 1 1
3 1 2,4
4 1 1
5 1 1
6 1 3,9
7 1 3
8 1 2
;
data want;
set have;
do i = 1 to countw(AE_free_text,",");
AE_num = input(scan(AE_free_text,i,","),10.);
output;
end;
drop i AE_free_text;
run;
Also note how "have" data is posted readily usable in a DATA step with DATALINES. Please do so in the future,
... View more
You can always save to csv, either with Excel or alternative software (e.g. LibreOffice).
The alternatives can even provide a CLI for such actions.
... View more
Define a file reference with the compression first, then use it in usual DATA step.
filename in zip "your path to the file" gzip;
data want;
infile in
dsd
lrecl=....
dlm=","
truncover
;
length
/* define your variables here */
;
format
/* set formats for variables that need it (dates, times, etc.) */
;
input
/* list all variables */
;
keep
/* list all variables you want to keep */
;
run;
... View more
Why do you think the code does not work properly?
By now (480 posts by you) we really should not need to ask for the log and further information.
... View more
Query DICTIONARY.COLUMNS with a suitable WHERE clause in a SELECT INTO to create the variable list which you can then use in a DROP statement or DROP= dataset option.
... View more
This is not HTTP, this is the SAS Viya File Service
You would copy the file to the current working directory of your SAS process, which is (unless you change it explicitly in your code) different from WORK
Massive parallelization of I/O can easily lead to an overload of your storage subsystem, resulting in serious overall performance degradation, and no net gain
... View more
The code is pure SAS code and will work with minor modifications (path and FINFO item name/format) on UNIX.
Also see my WUSS presentation: Talking to Your Host for useful coding tips with regard to file information.
... View more
How has the library been assigned? If it is not assigned by using the metadata engine, metadata permissions will not be enforced (exception: metadata bound libraries). In this case, only operating system permissions come into play.
... View more
@Nehe3000 wrote:
"ERROR: LIBREF SAPENG IS NOT ASSIGNED."
What it says. You tried to use the library SAPENG, but it has not yet been assigned.
Look in your log(s) where the assignment is and why it failed; if you don't find it, you need to code it.
... View more
