Answer / hsong001

Use the idea of variable list (varlist) wildcard :

e.g.,
proc print data=xxx ;
var A: ;
run ;
This will list all variables start with letter A.

Answer / a

proc print data=;
where name like 'A%';
run;

Answer / ashish

proc print data=datset(obs=5) ;
var s:;
quit;

Answer / henry

proc print data=sashelp.class;
var height weight;
where upcase(substr(name,1,1))='A';
run;

Answer / parbhat517

PROC PRINT DATA = X;
WHERE SUBSTR(NAME,1,1) = 'A';
RUN;

Answer / naveen

proc sql;
select *
from qqq
where name contains "A";
quit;

Answer / sunil chilaka

Dear fndz to print only variables that begin with
the letter "A" we can use

keep=option

Answer / naveen

proc print data=abc;
var name;
where name contains="A";
run;

what is validvarname and varnum? why we are using this options; explain with a syntax for this options?

1 Answers   Max India,

what is sas enterprise intelligence architecture? : Sas-bi

0 Answers  

What is the purpose of trailing @ and @@? How do you use them?

0 Answers  

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

2 Answers   Tech Mahindra,

what is hash files in sas and why we are using this one in sas?

0 Answers   L&T, SAS,

What is shift table? have you ever created shift that?

2 Answers   Accenture, Clinical Research, Quintiles,

what are the types of interactive display types? : Sas-bi

0 Answers  

What is _n_?

22 Answers  

What is the difference between the proc sql and data step?

0 Answers  

Describe a time when you were really stuck on a problem and how you solved it?

0 Answers   DELL,

how to generate the test data in sas without input data? : Sas-administrator

0 Answers  

i have a dataset with 100000 records. i want 100 records from that dataset and create a dataset.we need to pick the observations random order like 100obs,500obs,1020obs,1890obs,2565obs like that i need 100 obs in random order? how can we create this one?

5 Answers   L&T,