topic Re: importing many variables from a data set in SAS Programming

importing many variables from a data set

Shuail_Ibrahim — Tue, 26 May 2020 07:01:31 GMT

I have to import a few columns from a data set from 1 to 4. in future I might have from 1 to n. Currently, the issue I'm facing is if i give as (diag_1 $ diag_2 $ diag_3 $ diag_4 $ ) its able to pick the string value , but if i give as (diag_1 $ - diag_4 $;) only in 1 and 4th we are getting the string , ,

Please can anyone help me on this, since I'm new to SAS.

data file1;
infile '/folders/input/step1/file5.csv' dlm=',' firstobs=2;
input recipno diag_1 $ - diag_4 $;
run;

Re: importing many variables from a data set

Kurt_Bremser — Tue, 26 May 2020 07:25:49 GMT

This is the proper use of a variable list in the INPUT statement:

input recipno (diag_1-diag_4) ($);

It is a variation of what is described in INPUT Statement: Formatted

Re: importing many variables from a data set

ChrisNZ — Tue, 26 May 2020 07:46:46 GMT

A text file is not a data set.

A data set is a SAS table. At least when talking to SAS users like you are here. Use the proper terminology to get the best help. 🙂

You want to import from a text file into a SAS data set.

Re: importing many variables from a data set

Shuail_Ibrahim — Thu, 28 May 2020 08:07:44 GMT

@ChrisNZ, I'm extremely sorry for that, since I'm new to SAS that's why these sets of questions get arrived. if I get experienced I can match your terminology ... which will make you easier to answer.

Re: importing many variables from a data set

ChrisNZ — Thu, 28 May 2020 23:02:51 GMT

No worries. That's exactly why I highlight the terminology issue 🙂