What is the purpose of the trailing @? The @@? How would you
use them?
Answers were Sorted based on User's Feedback
Answer / imran syed
@@ is used when we have multiple observations per line of
raw data. It is used at the end of the INPUT statement. It
tells SAS to hold that line of data and continue to read
observations until it either runs out of data or reaches an
INPUT statement that does not end with a double trailing @.
When we use @ only without specifying n, SAS will hold that
line of data until it reaches either the end of the DATA
step or an INPUT statement that does not end with a trailing @.
Both are line-hold specifiers; the difference is how long
they hold a line of data for input. The trailing @ holds a
line of data for subsequent INPUT statements, but releases
that line of data when SAS returns to the top of the DATA
step to begin building the next observation. The double
trailing @ holds a line of data for subsequent INPUT
statements even when SAS starts building a new observation.
In both cases, the line of data is released if SAS reaches a
subsequent INPUT statement that does not contain a line-hold
specifier.
| Is This Answer Correct ? | 59 Yes | 3 No |
Answer / giri
both @AND @@ TAILARING used for the hold the
datalines,difference is how long they hold the data in the
complilation process,@ hold the the data till the end of
the line,but it release the dataline when it reach the end
of the line, but @@ holds the datalines untill the end of
the process
| Is This Answer Correct ? | 31 Yes | 9 No |
Answer / srinu
both @AND @@ TAILARING used for the hold the
datalines,difference is how long they hold the data in the
complilation process,@ hold the the data till the end of
the line,but it release the dataline when it reach the end
of the line, but @@ holds the datalines untill the end of
the process
| Is This Answer Correct ? | 11 Yes | 2 No |
Answer / no name is require
@-is used to reading part of a rawdata file we using traling @
@@-is used to reading multiple observations of rawdata
| Is This Answer Correct ? | 8 Yes | 4 No |
Answer / vikas pherwani
@ is a column pointer holds the input record for the
execution of the next input statement
@@ if we have two relevant obs in same line we need to hold
that too we need double trailing either after taking first
value sas move to another line leaving the first.
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / sumalatha.ch
@it holds the record at the end of the input statement or
when the next input will come it will read the data. and
@ is also pointer controll .if we want to read particular
character in a data set then we can use this @
@@ it is used for reading single line multiple
observations.
| Is This Answer Correct ? | 5 Yes | 3 No |
Answer / sunil
The trailing at sign (@) holds the input record for the
execution of the next INPUT statement.
The double trailing at sign (@@) holds the input record for
the execution of the next INPUT statement, even across
iterations of the DATA step.
| Is This Answer Correct ? | 4 Yes | 3 No |
Answer / raj
@:Hold an input record for the execution of the next input statement with in the same iteration of the data step.
use:The trailing @ must be the last item in the INPUT statement.
@@:Holds an input record for the execution of the next input statement across iteration of the data step.
Uses:The double trailing @ must be the last item in the INPUT statement.
| Is This Answer Correct ? | 2 Yes | 2 No |
Answer / chiranjeevi
These are those which works on the variable level by
default.It should appear and besides the variables in
sas.The columnpointers are
1)@
2)@@
@:the '@'is a column pointer which commands SAS to hold the
line strongly.The '@' is if it used,it is trailing of '@'
pointer.It reads only the first line across the available
variables data.
@@:It is used for the entire data from the external source
or internal by reading into a single variable.
| Is This Answer Correct ? | 2 Yes | 6 No |
Answer / santhi swaroop
@ is the pointer input that will hold the point at a
specific point variables inthe data
@@ is the on that may be useful to read the singleline of
raw data into multiple observations of the sas data set.
syn
data santhi;
infile path;
input var 1 2 3 4 @@;
run;
| Is This Answer Correct ? | 4 Yes | 12 No |
how do you read binary data in sas?
How do you specify the number of iterations and specific condition within a single do loop?
How would you include common or reuse to be processed along with your statements?
what is difference in window SAS & Unix SAS.....how do define working environment in both???
how are numeric and character missing values represented internally? : Sas programming
Describe 5 ways to do a “table lookup” in SAS?
hi tell be about pfizer? how to compare the work with other companies ? please tell me how to login and work also?
i have multiple .csv files in a unix directory. every file is having variable names as header.even for empty file also. suppose take 3 files a.csv b.csv c.csv a.csv contains data as name;age,salary; raja;34;4000; ravi;33;5000; kumar;25;3000; b.csv contains data as name;age,salary; ajay;40;4500; and c.csv contains name;age,salary; (only headers) Now i want to import and append all these files in to a single dataset. i tried infile statement with *.csv to import all at a time. but i m not getting correct data. please help me . its urgent. thank you in advance
you have a data set like this. data qqq; input name $ total; cards; qq 22 ww 33 qq 22 ee 44 rr 33 ww 44 ; run; and you want output like this......... name total qq 22 ww 44 Do it by data set step.
what is hash files in sas and why we are using this one in sas?
what are input dataset and output dataset options?
In SAS how to read the variable values having different formats. eg:mar99,mar1999 (in a single variable)
8 Answers GSK GlaxoSmithKline,