@aanan1417 wrote: Hi Sir,   i m trying to import csv file that consist of 20 variable and 6400000 observation. but the issue is few observation are blank due to this i am getting data only 2400000 What code did you run?  Here is how to structure a data step to read a delimited file (such as a CSV file). data want; infile "filename" dsd firstobs=2 truncover ; input var1-var20; run; The DSD option tells it to properly handle empty values and quoted values.  The TRUNCOVER option tells it to properly handle lines with fewer than 20 values.  The FIRSTOBS=2 option tells it to skip the header row, remove if your file does not have a header row. Adjust the INPUT statement to match the variable names and types needed for your file.  The syntax shown will work if all of the variable are numeric. ... View more

@aanan1417 wrote: Hi Sir,   i m trying to import csv file that consist of 20 variable and 6400000 observation. but the issue is few observation are blank due to this i am getting data only 2400000 What code did you run?  Here is how to structure a data step to read a delimited file (such as a CSV file). data want; infile "filename" dsd firstobs=2 truncover ; input var1-var20; run; The DSD option tells it to properly handle empty values and quoted values.  The TRUNCOVER option tells it to properly handle lines with fewer than 20 values.  The FIRSTOBS=2 option tells it to skip the header row, remove if your file does not have a header row. Adjust the INPUT statement to match the variable names and types needed for your file.  The syntax shown will work if all of the variable are numeric. ... View more

@aanan1417 wrote: Hi Sir,   i m trying to import csv file that consist of 20 variable and 6400000 observation. but the issue is few observation are blank due to this i am getting data only 2400000 What code did you run?  Here is how to structure a data step to read a delimited file (such as a CSV file). data want; infile "filename" dsd firstobs=2 truncover ; input var1-var20; run; The DSD option tells it to properly handle empty values and quoted values.  The TRUNCOVER option tells it to properly handle lines with fewer than 20 values.  The FIRSTOBS=2 option tells it to skip the header row, remove if your file does not have a header row. Adjust the INPUT statement to match the variable names and types needed for your file.  The syntax shown will work if all of the variable are numeric. ... View more

Given your name structure, this is done quite simply: final_age = max(of age:); ... View more

data a; input s1 s2 s3 s4; datalines; 1 2 3 4 2 2 4 5 9 9 9 9 ; proc summary data=a; var _numeric_; output out=want(drop=_type_ _freq_) sum=; run; ... View more

As written, the length of the state variable in your have and want datasets will default to 8 - too small to hold all the values. Try this: data have; length state $ 10; input state $ income; datalines; delhi 1000 delhi 3000 chandigarh 4000 chandigarh 3000 patna 300 delhi 400 ; run; data want; length state $ 10; input state $ income; datalines; chandigarh 7000 delhi 4400 ; run; proc sql; /*create table want as */ select state, sum(income) from have where lowcase(state) in ('delhi','chandigarh') group by state ; quit; May the SAS be with you 😉 ... View more

data have; input animal :$5. city :$7.; datalines; dog delhi cat delhi lion delhi bear mumbai cat mumbai mouse mumbai dog chennai mouse chennai bear chennai ; run; proc sql; create table want as select a.* from (select * from (select distinct animal from have),(select distinct city from have)) as a natural left join have as b where b.animal is missing; quit; ... View more

data have; input animal :$5. city :$7.; datalines; dog delhi cat delhi lion delhi bear mumbai cat mumbai mouse mumbai dog chennai mouse chennai bear chennai ; run; proc sql; create table want as select a.* from (select * from (select distinct animal from have),(select distinct city from have)) as a natural left join have as b where b.animal is missing; quit; ... View more

In line with @andreas_lds: data have; input accid $4. branch $25.; datalines; 1001 pune,hyderabad,banglore 1002 haryana,delhi 1003 shimla ; run; data want (drop = branch i); set have; do i = 1 to countw(branch, ","); /* i becomes a counter for the commas */ _branch = scan(branch, i, ","); /* notice the i becomes the <count> argument in the SCAN function. The loop iterates over the number of commas.*/ output; /* Output each separate branch before returning to top of loop. */ end; run; accid _branch 1001 pune 1001 hyderabad 1001 banglore 1002 haryana 1002 delhi 1003 shimla ... View more