topic Re: Create data set in SAS Programming

Create data set

Ronein — Mon, 20 Jan 2020 08:39:58 GMT

Hello

What is the problem that I get only one row ?

Data RawTbl;
INFILE DATALINES DLM=',';
input ID Customer1901 $ Branch1901 $
         Customer1902 $ Branch1902 $ 
         Customer1903 $ Branch1903 $
         Customer1904 $ Branch1904 $
         Customer1905 $ Branch1905 $
         Customer1906 $ Branch1906 $
         Customer1907 $ Branch1907 $
         Customer1908 $ Branch1908 $
         Customer1909 $ Branch1909 $
         Customer1910 $ Branch1910 $
         Customer1911 $ Branch1911 $
         Customer1912 $ Branch1912 $;
cards;
3188,22339829,855,22339829,855,22339829,855,22339829,855,22339829,855,22339829,855,22339829,855,22339829,855,22339829,855,22339829,855,22339829,855,22339829,855
3195,40031612,832,40031612,832,40031612,832,40031612,832,40031612,832,40031612,832,40031612,832	40031612,832,40031612,832,40031612,832,40031612,832,40031612,832
;
run;

Re: Create data set

PeterClemmensen — Mon, 20 Jan 2020 08:43:12 GMT

You're missing a comma

Data RawTbl;
INFILE DATALINES DLM=',';
input ID Customer1901 $ Branch1901 $
         Customer1902 $ Branch1902 $ 
         Customer1903 $ Branch1903 $
         Customer1904 $ Branch1904 $
         Customer1905 $ Branch1905 $
         Customer1906 $ Branch1906 $
         Customer1907 $ Branch1907 $
         Customer1908 $ Branch1908 $
         Customer1909 $ Branch1909 $
         Customer1910 $ Branch1910 $
         Customer1911 $ Branch1911 $
         Customer1912 $ Branch1912 $;
cards;
3188,22339829,855,22339829,855,22339829,855,22339829,855,22339829,855,22339829,855,22339829,855,22339829,855,22339829,855,22339829,855,22339829,855,22339829,855
3195,40031612,832,40031612,832,40031612,832,40031612,832,40031612,832,40031612,832,40031612,832,40031612,832,40031612,832,40031612,832,40031612,832,40031612,832
;
run;