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;
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;
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;
April 27 – 30 | Gaylord Texan | Grapevine, Texas
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!
Still thinking about your presentation idea? The submission deadline has been extended to Friday, Nov. 14, at 11:59 p.m. ET.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.